I need to get all news posts from multiple sites where a yes/no field = true. Here's my search rest api call where RefinableString05 is mapped to the yes/no field:
/_api/search/query?querytext='Path:https://xxx.sharepoint.com/sites/site1 OR Path:https://xxx.sharepoint.com/sites/site2/sitepages AND SPContentType:"Site Page" AND RefinableString05:true AND PromotedState:2 AND IsDocument:True AND FileExtension:aspx'&sortlist='FirstPublishedDate:descending'&startRow=0&rowlimit=15&selectproperties='Title,Description,RefinableString05,FirstPublishedDate,PictureThumbnailURL,WebId,Path'
This call returns multiple posts where RefinableString05 is false. If I enter RefinableString05:true in the default search box or include only 1 site in the api call, the results are correct so I'm pretty sure this isn't a managed property or indexing problem.. I've also reindexed sites and waited a few days.
Is my syntax wrong or is there some other way to ensure the filters get applied to 2 or more sites? The "OR" operator is causing the filters to be ignored for the site after "OR", but though repeating all the filters does work, that doesn't seem like a very efficient solution.