How to query based on history or activity

Question

Currently I want to write a query which somehow 'involved' a specific user but there is no simple way to do this. I would expect something built-in like 'updated by' or 'modified by'.

I cannot find any possibility to filter items based on history (or activity) entries either:

abc created issue - 26. Sep 2019 14:12

xyz made changes - 26. Sep 2019 14:12

I'd expect a queryable field history where I can select strongly typed elements (made changes, created issue etc.) or at least define a text based constraint like contains="made changes"

How can I achieve this?

Ravi Sagar _Sparxsys_ · Answer

Hi @kzander_

Using ScriptRunner for Jira you can look into the ChangeHistory of the issues but that is not the only thing it can do. It will help you to do extreme customisations in Jira. You can evaluate it for free though and get familiar with its features.

Ravi

kzander_ · Answer

Thanks for your answer.

So there is no way to do this without buying an add-on.

Will everything what can be displayed in a Jiira item be queryable with this plugin or will I end up in limitations as well?

Ravi Sagar _Sparxsys_ · Answer

Hi @kzander_

For created you can use something like this.

creator = admin and updated > startOfDay()

For some fields you can try something like this.

status changed by "admin" and updated > startOfDay("-1")

Usually the change history has all the information about who actually did the change and when but to search on this you would need an add-on like ScriptRunner. Take a look at this thread.

Thanks,

Ravi