Filter Results Gadget 6.1

Hi,

I have added "Filter Results Gadget" to my dashboard and have selected my saved filter. 

In the saved filter,my query should have ordey by with 6 columns (escalated, status, priority, CED status, SF close date, created.). This works fine in the issue nanvigator BUT in the filter results gadget the order by function has some issues for the saved filter. Is this known bug? Do we have any alternative??

I even tried testing to have columns restricting to 3 for the order by function and it then works fine  but when exceeding to more than 3 columns, discrepency is noticed.

Can someone pls assist or share thoughts on the same?? 

Thanks,
Monika 

3 answers

1 accepted

 

Hi @Penny Wyatt, Thank you very much for the response! My issue here isn't about the columns to be displayed in the filter result dashboard, but, it is about the ORDEY BY function on the saved query. My saved query has the below order by function "ORDER BY Escalated ASC, summary ASC, status, priority, "CED Status", "SalesForce Open Date", created" ... in this query, the SEQUENCE of results displayed in the filter gadget and issue navigator looks good only till 3 cordey by conditions... after which it fails. Attaching screen capture below for more clear information please

sequence of results.png

 

 

Penny Wyatt Atlassian Team Oct 27, 2014

Hi Monika, Thanks for the clarification, I now understand what you're asking and have reproduced the problem myself. I've now found that this is a known issue when there are more than 3 "order by" criteria in the filter - https://jira.atlassian.com/browse/JRA-21443 . Please vote on that issue and watch it for updates; and if this is impacting your work please raise a support ticket so that the Support team can help you find a workaround for your needs. Best wishes, Penny

Thank you very much Penny!!

You can use the Column Order to replace the Filter Results  

try 

https://marketplace.atlassian.com/plugins/at.celix.jira.plugins.column-order

Penny Wyatt Atlassian Team Oct 27, 2014

The JIRA filter results gadget has provided column ordering functionality since JIRA 5.2.

0 vote
Penny Wyatt Atlassian Team Oct 27, 2014

The Filter Results gadget shows the columns in the order that they've been configured in the gadget configuration.

e.g. Type, Key, Priority, Assignee, Created in the configuration view:

FilterResults1.1.png

Becomes Type, Key, Priority, Assignee, Created in the gadget view:

FilterResults2.1.png

The default sort order of the issues is the sort order that's saved in the filter, but you can sort by any other column inside the gadget by clicking the column headers.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

235 views 1 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you