Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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? –  DeeMac Jun 26 '12 at 13:32

Your Answer

 
discard

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.