SharePoint 2010 Search Query

Question

Hi,

I had written a custom search query for MOSS 2007 to get data where contenttype is post. However the same query is not returning any results in SharePoint 2010. Any inputs will be appreciated.

Please note that SharePoint search box is returning (parameter k in query string and also contenttype:post) appropriate results.

Thanks,

Answer 1

Did you get this issue resolved. I've got a similar issue

The following worked

SELECT TOP 3 title,path,author body FROM scope() WHERE (contenttype = 'post' ) AND CONTAINS(path,'siteurl')

This didn't work (even though it should work)

SELECT TOP 3 title,path,author body FROM scope() WHERE (contenttype = 'post' ) AND CONTAINS(path,'siteur*')

Answer 2

try:

SELECT TOP 3 title,path,author body FROM scope() WHERE (contenttype = 'post' ) AND CONTAINS(path,'"siteur*"')

add double quote to the keyword.