Basically I would like to get all results that would be returned for a normal keyword query, but I want to filter those results with a WHERE clause. I tried using KeywordQuery or FullTextSqlQuery but didn't see anything in either that would appear to let me do that.

Can someone point me in the right direction?

  • 1
    I'd suggest that you just use the KeywordQuery, if you ever want to upgrade to FAST then FullTextSqlQuery insn't suppoerted. what kind of WHERE can't you express using KeywordQuery? Commented May 25, 2012 at 22:46

1 Answer 1


Looks like you can pass in a keyword along with some parameters to filter the results. Example:

KeywordQuery kw = new KeywordQuery();
kw.QueryText = "some keyword (DocumentDate >= 1/1/2009 AND DocumentDate <= 12/31/2009)";

will return only results that would be returned for a search on "some keyword" that have a DocumentDate somewhere in 2009.

You can find the details here.

Hope this helps someone!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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