Resources for IT Professionals >
Forums Home
>
Using Forums Forums
>
Off-Topic Posts (Do Not Post Here)
>
Need help searching based on a custom list property
Need help searching based on a custom list property
- Hi,
I'm using WSS 3.0 with Search Server 2008. I have a custom list containing documents that have some custom fields, one of which is named Categories that is a multiple choice column, e,g.:
Categories :Administration; :Ethics and Conduct; :Compliance - Privacy; :Compliance - Information Security
I need to be able to find all uploaded documents with Categories containing "Ethics and Conduct". I see the following crawled properties:
Categories(Text)
Categories0(Text)
ows_Categories0(Text)
I mapped the last two to a managed property called Categories and crawled the site. The problem is when I try to do a SQL search using Categories, I get InvalidPropertyException. Trying a keyword query with: Categories:"Ethics and Conduct" doesn't give me the correct results either.
I welcome your suggestions. Thank you for your time.
- Ed.- Moved byMike Walsh MVPMVP, ModeratorWednesday, November 04, 2009 4:34 AMSearch Server has its own forums, post Search Server questions there. (They are in the msdn set and not in the technet set of forums (From:SharePoint - Search)
All Replies
- You can check a few things. When editing a crawled property the page will show a section called "Content using property" and will show sample document urls using the property. Do you see any urls under sample documents for these crawled properties? If no documents are using this crawled property then it is possible that documents are not being crawled. Check your crawl log to see if the documents using the multi choice column are being crawled. The "InvalidPropertyException" can occur if you add a new managed property and then do a fulltextsql query before the cache is updated or there are no documents linked to any of the mapped crawled properties. You can try doing an IIS reset to force a cache refresh and try your query again. Otherwise it is probably because no documents are using any of the crawled properties.
certdev.com
