...
In the Confluence general search screen, you can add filters to perform an advanced search. Comala Document Control adds filters for "Workflow state" or "Assigned approver".
Macros
Confluence provides some macros that support CQL filters, like the Content by label macro or the Page properties report macro.
REST API CQL
You can search with your own app using the Confluence REST APIa workflow state and workflow properties.
For example
searching for pages and content currently in the applied workflow state named Draft
...
For information refer to the Comala Document Management Developer Guides.
Macros
Confluence provides some macros that support CQL filters, like the Content by label macro or the Page properties report macro.
Related pages
Reporting tools
...