CQL for "Recently worked on"

Question

We want to save our users clicks by reproducing basic information of the "Recently worked on" section of the dashboard with the help of a plugin that displays the results of CQL queries.
The current CQL query is as follows:

contributor = currentUser() AND type IN (‘page’, ‘blogpost’, 'comment') order by lastmodified desc

However, this query lists pages to which the respective user has contributed, but the date of their contribution may have been a long time ago. The output lists the pages according to the date of the last change - no matter by whom.
What is the CQL expression for the output as seen on the dashboard?

Aron Gombas _Midori_ · Answer

CQL offers only a single "last modified by anyone" field. In other words, the "last modified by user X" field is not available.

Therefore, you can not write that query in CQL.

The available fields are here, maybe you can get a reasonable result by combining multiple fields: https://developer.atlassian.com/server/confluence/cql-field-reference/

Nicolai Sibler · Answer

Hi @Marc -Devoteam- ,

I just edited my question to clarify that I actually need a CQL query because the Confluence app I'm using doesn't support SQL. The answer I gave to another user with a different requirement is therefore not helpful to me in my case ;-)

Marc -Devoteam- · Answer

Hi @Nicolai Sibler

maybe this article is helpful to you, I think this is the only option.

https://confluence.atlassian.com/confkb/how-to-query-user-activity-via-sql-966042253.html

Regards,

Nicolai