JQL Filter

Question

Hello, can someone tell me if im (somehow) able to use JQL that will give me result of tickets which have following:

for example:
We have updated the field 5.9.2023 and 5.10.2023 it will appear in the results of this JQL

The custom field is named:

DRPF Approved - Delivery window[Dropdown]

The value is for example "1 month" and i want to get the tickets when this field was edited exactly before 1 month.

Is it possible to get it just only via JQL?

I have tried this:
project = " Dev request prioritisation funnel" AND Status changed to "Request approved" before -30d AND "DRPF Approved - Delivery window[Dropdown]" = "1 month" AND status not in (Done, Rejected)

And bard suggested this:
project = "Dev request prioritisation funnel" AND status NOT IN (Done, Rejected) AND updated >= -30d AND "DRPF Approved - Delivery window[Dropdown]" = "1 month" AND "DRPF Approved - Delivery window[Dropdown]" updated >= -30d

and this:
project = "Dev request prioritisation funnel" AND status NOT IN (Done, Rejected) AND updated >= -30d AND changelog contains "DRPF Approved - Delivery window[Dropdown] changed to 1 month" AND changelog contains "updated 30 days ago"

But bard´s queries are not working and my query is not giving me results i want.

Any suggestions what i can use?
Thanks for any reply!

František Vůjtek · Answer

Hey, thank you for reply.

I mean, When we will fill in this time picking windows, unfortunatelly its not a date time but an option custom field..

I should add date time custom field and set something like ticket or something..

When user entered 1 month, and the ticket wasn´t still closed it will give me an notification its still not finished. That´s the goal.

Walter Buggenhout · Answer

Hi @František Vůjtek,

I ldon't think I fully grasp what you are trying to do here. From what you explain, it seems that the custom field DRP Approved - Delivery window is a dropdown. In other words: a select list with predefined values. If that is true, I don't think JQL will be able to interpret those values as dates, but will read them as text values instead.

JQL lets you search for issues based on when certain fields were changed, indeed. This is called history search, but it is important to note that not all field types are supported. I am afraid that your custom field is one of those unsupported fields. You can simply validate that by running the following JQL:

"DRP Approved - Delivery window[Dropdown]" CHANGED Before -30d

If running that search displays an error message saying history searches don not support the "DRP ..." field, then you know you won't be able to query about when it was changed.

The first example JQL you shared:

project = " Dev request prioritisation funnel" AND Status changed to
"Request approved" before -30d AND "DRPF Approved - Delivery window[Dropdown]"
= "1 month" AND status not in (Done, Rejected)

should return (in human language):

* all issues that do NOT have status Done or Rejected today,
* had their status changed to Request approved more than 30 days ago
* and have 1 month as the current value in the DRP Approved - Delivery field

Have a look at where that search may not be giving you the expected results. Most likely 1 of these 3 parts of the query are not what you are trying to extract.

Could you also try to explain in more detail what you mean by:

The value is for example "1 month" and i want to get the tickets when this field was edited exactly before 1 month.