how to write a JQL query on CF value,status and number of days in that status?

Ravichandra_Itagi

I want to write a JQL query on the basis of custom field value,status of the issue and number of days the issue in the status.

I want to add a subscription to this query. when the ticket is almost more than 2 weeks in URS -Signoff status for custom field value project, notification should go to the subscribers.  

currently am using below JQL query,

issuetype = Epic AND "Development Type" = Project AND status = "urs sign-off" AND status changed before -2w.

please suggest me whether above query is correct if it is wrong suggest me the correct one.

Iago Docando

I don't know your workflow but the "status changed before -2w" will trigger with any status change, obviously, so maybe this isn't what you want.

I'll advise you to create a date custom field. Let's call it "date_of_the_transition_you_are interested_in".

You'll need then to add a postfunction to the transition you want to monitor. The trantition would be "update custom field" and you'll use the macro %%CURRENT_DATETIME%% as the value for the field.

Now you can create a JQL search based on thet field:

issuetype = Epic AND "Development Type" = Project AND status = "urs sign-off" AND customField_XXXXX < endOfDay(-2w)

With this I believe your need is covered. Hope it helps.