JQL: field that contain at least 2023 Q3

[Eric Roetenberg]

Hello,

I'm looking for a JQL query that can retrieve a piece of text in a field.
Example: the field PLANNING must contain at least 2023 Q3.

who has a solution

Grtz  Eric

[Mark Markov · Accepted solution]

Hello @Tom Lister

History doesn't contain information about transitions. Only status changes.

I made little research and it seems you cannot do it with Java API.

[Tom Lister]

I agree, there is no managed API methods that I can find. I am assuming that the status is only normally changed by workflow and can find those events in the history. Although they can be mixed in with other transition form changes as well.

in the Issue Activity tab you can see events reported as transitions

e.g.

I think I'll need to download the JIRA source and see where that comes from.

[Tom Lister]

As an update, what I am seeing in debug is that I will get all the change histories for an issue, but if I look through the ChangeItem list, only the status change value is ever returned.

My comment about no items returned at all must have been fat fingers somewhere.

However this does seem to mean I have to iterate through all histories checking for items.