Has anyone had luck querying System.Author and getting back a result as expected.
(Using the Vista Search) An example query might be:
SELECT System.ItemName, System.Author FROM SYSTEMINDEX
It seems that there might be an array of authors or something to that extent. Any examples / code examples would be appreciated. My end goal would be to get something like the author of an e-mail or the author of a document (even if there were multiple authors I'd like to be able to just view one or see how you might pull out multiple ones).
Thank you.
System.Author column (Querying the search)
Bjørnar Sundsbø
Yep, it works, but there is a catch. As far as I know, Vista integrated search (as well as Windows Desktop Search product for 2000/XP/2003) doesn't support SQL query syntax through its GUI. You give it simple queries using either basic syntax ("sometext") or advanced syntax ("size:<1000") and it translates these queries into SQL internally, but this process is completely transparent and inaccessible for end-user. To use SQL queries you must use OLE DB search provider for MS Search.
Try this Windows Index Search Sample : http://msdn2.microsoft.com/en-us/library/aa970895.aspx
I have tried your exact query ("SELECT System.ItemName, System.Author FROM SYSTEMINDEX") there and got plenty of results. Actually most of the result rows contained empty values in Author column, so the query took some time. Fortunately, it's easy to fix using standard SQL syntax: "SELECT System.ItemName, System.Author FROM SYSTEMINDEX WHERE System.Author IS NOT NULL", this one works much faster.