Confluence query created and lastModified datetime filter

Question

I'm trying to retrieve spaces modified after some date-time value using confluence query. But what I observed that the results are filtered only by date and not by time. Below is the cql query that I've executed using search API:

/search?cql=(type=space and lastModified > "2018-08-06 10:10")

For the above cql query results are filtered only by the date value(2018-08-06) and not by the time value(10:10). I've refereed the CQL date formats mentioned here.

Is this the expected behavior? Or is there any other way to filter results by date-time.

Shreeniwas Sovani · Answer

Hi @Rambabu Patina {Appfire},

We do get the spaces in the result with the cql query mentioned in the question. The only problem is that the results are not filtered by date-time value provided in query and they are filtered by only date.

The same behavior I've observed for page and blogpost objects as well.

The query that you have suggested to use gives me all space contents(pages,blogposts) and not just the spaces. Also the results are not filtered by date-time value provided.

Rambabu Patina {Appfire} · Answer

Hi @Shreeniwas Sovani,

Does the provided search API return any results?

The supported content types for the field type is:

* page
* blogpost
* comment
* attachment

Note: An advanced search (CQL) allows you to use structured queries to search for content in Confluence

I think for your requirement you can use /search?cql=(space.type=global and lastModified > "2018-08-06 10:10") to retrieve the list of contents which is modified after the specified time. Please try it and let us know how it goes.

Thanks,
Ram.