Can we handle Arithmetic Operations in JQL queries?

Question

We want to send custom notifications based on the due date & time field of an issue to the assignees.

But we are not able to write Arithmetic JQL queries to get the list of issues.

Can someone guide me on how we can achieve writing mathematical expressions in JQL queries or is there any addon that we can use for writing the queries with mathematical expressions.

Vinod Mendem · Answer

@Ilya Turov , Script runner seems to be paid addon.

Is there any addon that address the above query that is available for free in the Atlassian Marketplace.

Ilya Turov · Answer

scriptrunner has custom jql which might help you:

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