JQL query to filter Resolved/Not resolved by ''Service Target Date'' set on ticket

[Maja Sergienko]

Hello Community!

I'm trying to filter out and get a count of tickets resolved by ''Service Target Date'' and not resolved by it. Problem is that this ''Service Target Date'' isn't fixed, it wouldbe set for every ticket individually.

Could you please help if something like: resolved by ''Service Target Date'' or resolved <= ''Service Target Date'' might work in JQL?

Thank you!

[Aditya Verma · Accepted solution]

Hi @Maja Sergienko ,

Unfortunately JQL doesn't have the ability to compare two date fields directly. Since I use ScriptRunner as an addon, I am aware about a datecompare function offered by it for extending this functionality in Jira.

Please check if you have this add-on in your Jira instance and utilize the same.

Reference - https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_datecompare 

[Maja Sergienko]

Hello @Aditya Verma , 

Thank you!