Searching and defining columns to display

[Jeff Thomas]

Hi, I want to create a search that can be used my multiple people and be exported to Excel. I want it so that the same fields return in the same order so that the export can be pasted into another excel tool.

when I make this search, save it and add users to the permissions the order of the columns varied by user. Whilst I could ask each person to customise their view that would be hard especially if people change roles. 

Can I force the search to display the data in an certain order? For example something like:

project = STCBP ORDER BY key ASC and Column 1 = 'Key' and Column 2 = 'Summary' and Column 3 = 'Epic Name" and Column 4 = 'Assignee" 

[Kian Stack Mumo Systems · Accepted solution]

Jeff, you absolutely can.

Once you have a filter saved, you can define the filter columns that people can toggle to when they view the filter.

If users access this filter, they can switch to the "Filter" columns. When they export it, the data should be in the same order.