Extract table column headers information on sort change

Hi, I want to obtain the information of the column headers ( name and sort order) on Sort Change event, how can i achieve this?

Hey there!

You can add an event handler to the table, so that when the sort is changed, it triggers an event. Then, for example, you could trigger a query which returns the sort information for that table.

Here is an example of this in action:

Sorting the table, triggers query3, which returns table1.sort

this returns the column name and sort order.

Let me know if this answers your question!

Hi, thank you for the reply

It does help, but i found a new issue with it,

With custom column, i only see the id listed as 'Custom Column x'
Is there a way to get the custom name that i assigned to the Custom Column (column header text)?

Screen Shot 2022-09-08 at 18.27.05

Edit: nevermind i can match it with the value from table.columnHeaderNames, thanks!