This relates to Jira Service Desk.
I have a custom filter which is sorting by descending priority placing my highest at the top. However if an item has a due date I want that to be first if its the same date as today - so i want to do something like this:
order by iif(duedate = today(), 99, priority) desc
So the theory is that if its got a due date it will naturally be first, otherwise it would use priority order. Does anybody know how to get something like this working?
Hello @Dom Cotton
This is an Else if statement and there is no equivalent for this in JQL.
The same thing is discussed here
Answer provided by Atlassian
Natively, Jira can't do this kind of conditional searching in JQL. It might be possible for you to use something like the SQL for Jira Driver: Convert JQL to SQL to help here. This plugin lets you use more SQL like syntax when querying Jira.
What I would do is add a custom filed type Select list, for example, I'll name it "Priority Rank".
Then use automation to check due date, and if the due date is today set "Priority Rank"
Also, I would add automation to edit "Priority Rank" based on issue priority when created.
Of curse, you would need Automation for Jira plugin to achieve this.
Add two gadgets with filter results to your dashboard one to represent due day issues and other issues ordered by priority.
No plugin no, done in a few minutes.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events