Extract table column headers information on sort change

[mar-is]

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

[Isaac-H]

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!

[mar-is]

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)?

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