Ability to change the sort order of filters on a Custom Query

Hi John,

Thank you for posting your product idea, we love to hear about new ways we can make the product even better and easier to use.

We review ideas each month and work with the Community to help encourage feedback to rank suggestions that we can present to our product team for review. Not all ideas make it into the product roadmap but all ideas lead to some new thinking for our team.

Keep sharing and as soon as the status changes on your post you will know if we have moved your idea into our product roadmap or a status of 'not planned'.

Thank you,

Paul

You could possibly use a custom query for this unless the ordering is completely impossible, even then you may be able to brute force this:

Select colA
From (
  Select distinct colA, colD
  From TableB
) t1
Order by colD

or

Select colA
From (
  Select distinct colA, row_number() over(partition by colB order by colD descending) [col_ord] from TableB
) temp_table
order by [col_ord]

or brute force. My db has a calendar table. This final example changes the order of years

select year_name from
(
	select distinct Calendar.year_name, ord 
	from Calendar
	JOIN  (VALUES(2000, 5),(2001, 1), (2012,2), (2017, 3), (2019, 4)) order_table (year_name, ord)
		on order_table.year_name = Calendar.year_name
) t1
order by ord

Actually, if you make the column a reference code with your sort options, then click on that column and choose add to filter, does it not keep the order?

I did try using a ref code, but it doesn’t seem to have worked in our case (cached filters using a custom query).

John Phillips

Implementation Manager

INX Software

Level 4, 1111 Hay Street West Perth  6005  WA Australia

phone: +61 (08) 9442 2800  |  support: 1300 746 084  |  web:  www.inxsoftware.com  | address: view map  |follow us: LinkedIn    

From: Support Queue [mailto:support@Yellowfin.bi]

Sent: Wednesday, 24 July 2019 12:24 AM

To: John Phillips

Subject: New Comment in "Ability to change the sort order of filters"

Ahhh - if you need to use a Custom Query it won't work

However - if you don't - you need to set the Format to the Reference Code you want to use Then you simply do this in the Filter Formatting