I have two list items in SharePoint list.

1.approval_status='pending' and title='Test'

2.approval-status='Approved' and title='Test'

if user search item based on search title field(e.g.Test), I want to show approval_status='Approved' items only if approval_status='pending' i don't want to show the item in SharePoint search.

  • If you use the out of the box item or document approval this happens by default. – Matthew McDermott Sep 13 '18 at 11:21

In SharePoint Online, you can create a query rule or result source which modifies the query to exclude “pending” results.

Change the search query and append the query text like the following format in the Query text box to filter out the “pending” results.

-<managed property>:<value>

Manage query rules in SharePoint

Configure result sources for search in SharePoint

Building search queries in SharePoint

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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