Table Transformer Macro SQL CASE statement not sorting correctly - help please!

[Amy Sliwinski]

Hello, 

I am trying to sort a table by two columns. First, in ascending order by the "Tentative Timeline" column and, second, in descending order by "Priority Level." 

We are using the status macro for the values in the "Priority Level" column, but I have adjusted the query to only ORDER BY "Priority Level" and that by itself worked, so there are not issues with the macro recognizing the values. The issue seems to be with the CASE statement, but I have tried slight adjustments multiple times and simply cannot figure it out. Can anyone help me figure out what I am doing wrong? 

SELECT * FROM T*
  ORDER BY 'Tentative Timeline' ASC,
   CASE
    WHEN ('Priority Level' = 'High') THEN 1
    WHEN ('Priority Level' = 'Medium') THEN 2
    WHEN ('Priority Level' = 'Low') THEN 3
    ELSE 4
   END DESC;

[Stiltsoft support]

Hi @Amy Sliwinski ,

As you've mentioned the Table Transformer macro, it means that you use our Table Filter, Charts & Spreadsheets for Confluence app.

So if you have any questions regarding our macros, you can raise a support ticket directly: here we try to find the related questions manually. Besides the portal is confidential, so you'll be able to share the details of your case freely.

Besides, you may always take a look at our documentation: here is an example of a similar use case with statuses.

[Amy Sliwinski]

My team helped me figure it out! The "Priority Level" values are case sensitive! We changed it to "HIGH" for example and it WORKED!! Yay!

[Michael Wohlgemuth _Wolge_]

Shoutout to your awesome team at this point! :D