ElasticSearch Reindexing - Modify select query for count of folder type document & children

A folder-type document containing child documents of various types (e.g., pictures, notes, XML) currently returns a total count that includes hidden documents, versions, and trashed items, which are not visible in the UI. However, during reindexing, only the visible documents are processed, excluding the hidden, versioned, or trashed ones, resulting in a mismatch between the displayed count and the number of documents reindexed. To maintain consistency between the UI and reindexing, the query should be adjusted to exclude these hidden or irrelevant documents when fetching the count and reindexing.

SELECT * FROM Document WHERE ecm:uuid=<document-uuid> OR ecm:ancestorId=<document-ancestorId> AND ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation'
        AND ecm:isVersion = 0 AND ecm:isTrashed = 0