We are using Comala Metadata and Comala Document Management plugin.
We use Comala Document Management to set metadata on a page. Let us suppose we have pages with the metadata as shown in the screenshot.
What we want to achieve is to retrieve the pages based on these metadata (can be more than one conditions in the search criteria). For instance, one of the possible scenarios is to retrieve all the pages where the "Live Date" >= '2020-01-01' and "Live Date" <= '2020-12-31' and "Directorate" = 'Application'. Then, we will process the search results further to produce a custom report.
We have looked into the Comala Metadata plugin documentation, there seems to be no solution to our use case.
We have looked into Confluence JAVA APIs (one of it was CQLSearchService) documentation on how to get pages based on custom property but to didnt find a sample where we can pass metadata (custom property) in the search query.
Any idea how to can achieve this?
Cheers,
Priska
