I've created a page that shows documents that are pending approval from different sites(content approval in libraries).
I configured a managed property RefinableString01
and RefinableInt01
and mapped it to the crawled property ows__ModerationStatus
.
In the search page, I tried using RefinableString01:'0'
, RefinableInt01:0
etc. This query doesn't work consistently.
It brings documents that are pending approval from various sites, but it also sometimes keeps showing documents that are in approved state!
Initially I thought its just due to the delay in Crawling but this keeps happening and even after waiting for 24-48 hours and re-indexing the library and site, few approved document keeps showing up.
Can we use the crawled property ows__ModerationStatus
and _ModerationStatus
and use them in queries by mapping to mapped properties? or is it not possible to show documents that are pending approval in SharePoint online