SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Could you paste your code here? – Falak Mahmood Jun 5 '12 at 15:32
up vote 2 down vote accepted

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.

share|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 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 posting your answer, you agree to the privacy policy and terms of service.

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