Contributor and modification date Search criteria

Question

hello.

When searching content, I want to find content modified by a specific user within a specific date range.
When configuring cql as shown below, the search results, contrary to the expected results, found that the entered contributor matched among the content modified within a specific date range.
Is there a way to search by date range of modifications by contributor?

cql: contributor = "user_id" and lastmodified >= "2023-09-01" and lastmodified <= "2023-09-07"

youngmin_jm4aui · Answer

I don't have DB access rights. Is there any option to search using cql query?

Sayed Bares [ServiceRocket] · Answer

@youngmin if you have access to DB then you can run some queries from backend to find the modified date and modifier. This article contain the query for each database type which you can use as a starter:

* https://confluence.atlassian.com/confkb/how-to-obtain-a-list-of-all-pages-their-authors-and-related-information-from-the-confluence-database-968687591.html