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

When running a FullTextSQLQuery - it will fail to bring back any columns that are not populated. So, for example, if the crawl didn't detect any PublishedStartDate's were populated - it wouldn't allow you to retrieve this column for anything. Is my understanding correct? And if so, is it possible to 'index' (may not be the right word) these columns in order for my query to run if they are all nulls. If not - I'll have to handle the exception from when I call the FulTextSQLQuery in order to code defensively which isn't really ideal.

share|improve this question
up vote 1 down vote accepted

We get the same issue, and the only way to index a metadata column was to create a fake document and run a crawl on it to be able to use it.

According to the dev team of my company, it was the only way we find to solve this. Sorry.

share|improve this answer
Not a problem. I have, funnily enough, just done the same - I did figure there wouldn't be much of a way around it. I still can't seem to pull back the required column though. ExpirationTime - any ideas? – JᴀʏMᴇᴇ Jun 26 '12 at 13:32

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.