I want to limit my full text SQL query to a single site collection and I am calling the SharePoint search.asmx web service directly from Javascript. Is there some way to limit this using something in the Query Schema? This is on SharePoint 2010 Standard. I realize that Foundation would limit the results on its own, so there must be a way.

  • Could you paste your code here? – Falak Mahmood Jun 5 '12 at 15:32

You can add something like this to your query:

AND site = 'http://blah/subsite/anothersite'

But in general I'd recommend that you move to KeywordQuery syntax instead of FullTextSqlQuery as the later isn't supported by FAST.

| improve this answer | |
  • Thanks, I'll give this a shot. This is custom work for a single client that does not use FAST. I wanted to use a Keyword Query, but the requirements were such that I only query particular fields (not the entire record) so I set up Metadata properties for them. I know keyword queries can handle this, but I had a few other restrictions which caused the keyword query to never return results. – Kirk Liemohn Jun 5 '12 at 16:44
  • Question: Are alternate access mappings handled properly? If my site can be accessed as blah/sites/a or blah/sites/a or blah.com/sites/a would all work if there are AAMs defined? – Kirk Liemohn Jun 5 '12 at 16:45
  • You need to specify the url from the zone which you're crawling. RebaseUriWithAlternateUri from SPAlternateUrlCollectionManager may help you get that – Per Jakobsen Jun 5 '12 at 16:51
  • I answered my own question. AAMs are handled. Thanks! – Kirk Liemohn Jun 5 '12 at 16:52
  • I missed your answer to the AAMs before I responded and we have different answers. My observations indicate that that AAMs do work. In my case the site name had the servername in one test and a publicly available host header in the second. Both worked and both returned 0 results if I put a character at the end of the URL (making it a different site). – Kirk Liemohn Jun 5 '12 at 16:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.