...
In addition, you will want to add two additional clauses to the query, to filter your results to the appropriate tenant, and to filter documents that have been soft-deleted (soft-marked as deleted, but saved still present in the repositorydatabase). Here is an example query that gets values in from the acquisition schema:
...