I finally got around to publishing an updated version of SearchCoder, one that supports SharePoint 2010.

DOWNLOAD

SearchCoder is a tool we put together to help developers write, test and interrogate the SharePoint Search Engine. It is comprised of two things:

1) A UI that lets you write the SQL Search Queries via a UI

2) An object model that lets you write the SQL Queries through .NET objects

Both tools are in Beta, and they work pretty well. We know of a couple of bugs in the more complex queries and given some of the work we are doing here, hoping to spend some time squashing them. We recently added support for doing some basic query performance testing, including via the web services. We are also looking at adding support for viewing the Change Log.

Stay tuned.

Actually, there was very little to do, I just had to modify the from statement so that instead of a basic query looking like this:

SELECT Title, Rank, Size, Description, Write, Path

FROM portal..scope()

ORDER BY "Rank" DESC

It looked like this:

SELECT Title, Rank, Size, Description, Write, Path

FROM Scope()

ORDER BY "Rank" DESC

Note the small change in the “FROM” statement, curious as to what prompted this change, and just how many apps around the world will break because of it!

DOWNLOAD