Hi all. I'm designing a dashboard for one of our project teams and I have this query written:
PROJECT = DX AND status != closed AND status != done AND status != removed AND status != "COMPLETE - OPS" AND status != "COMPLETE - FED" AND status != "COMPLETE - UX" AND status != "To Do" AND status != "TO DO - UX" AND status != "TO DO - OPS" AND status != "TO DO - FED" AND Labels = New-Request ORDER BY cf DESC
When I search using a basic filter search, I get results for cf and am able to sort by the value, but when I implement it into a dashboard, no values display and the column is not orderable. Any ideas what I could be missing?
Hi @Shane Burkes,
Most likely this behaviour will be related to the type of custom field cf actually is, but that is impossible to judge based on just your JQL statement.
Some types of custom fields are not supported in dashboard gadgets, possibly because they are part of a marketplace app or something else that is not very standard functionality.
On a side note, you may also optimise your query by updating it to something like this:
Project = DX AND status NOT IN (closed,done,removed,COMPLETE - OPS,COMPLETE - FED,COMPLETE - UX,To Do,TO DO - UX,TO DO - OPS,TO DO - FED) AND Labels = New-Request
or - assuming that you only want to filter out issues with any In Progress status:
Project = DX AND statuscategory = "In Progress" AND Labels = New-Request
Filters with a lot of != or NOT IN are generally less performant then filters specifying exactly what you are after.
Hope both tips are helpful!
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