SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

We have approval workflow for document library & content approval column was set to yes for it.
We have used KeywordQuery on the library by creating separate scope.
We want to display only approved items in search result for that we have set ApprovalStatus property to Zero in scope rule.
but even after adding this propert we are getting pending documents in search result.
Also after adding the property ApprovalStatus = 0 ,Item Count shows "error" as its value instead of count.
Pls let me know how to show only Approved items in search result.

share|improve this question

ows_ModerationStatus is the crawled property you are looking for. In my environment, it is not mapped to a metadata property, which is what the keyword search uses. Here is the msdn link to manage metadata properties: MSDN metadata properties. Check to make sure the mapping from moderation status to approvalstatus is set up.

share|improve this answer
I did mapping of Approvalstatus with ows_ModerationStatus. but by adding ApprovalStatus = 0 in scope rule still it is not working.Can you please tell me can I use this property in KeywordQuery & how to use it? – Rushikesh Feb 20 '13 at 12:01
Did you run a full crawl after setting up the ApprovalStatus metadata property? – Blue Murphy Feb 20 '13 at 14:58

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.