I've created a page that shows documents that are pending approval from different sites(content approval in libraries).
I configured a managed property
RefinableInt01 and mapped it to the crawled property
In the search page, I tried using
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
_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