I'm using an advanced query to feed a table but the sorting isn't working for the id field. I'm using a parameter tablesort with the property expand inline set to yes. In the select of the query I have {Person}.[Id] and in the table the sort attribute is set to id. Why this specific field is giving error where the other fields don't?
Hi @Fabiano Peralta,
Please check the below Links:https://success.outsystems.com/documentation/how_to_guides/development/how_to_enable_dynamic_sorting_in_a_table_fed_by_a_sql_query/https://www.outsystems.com/forums/discussion/83660/pagination-and-sorting-using-advanced-sql-in-reactive/#https://www.outsystems.com/forums/discussion/59321/sort-sql-query-in-reactive-web/#Post248415
RegardsKrishnanand Pathak
Hi @Fabiano Peralta
You can achieve it by using a Input parameter in advance SQL,
Just add sorting in your table headers and in onclick pass the column name and a certain order (ascending or descending) then pass the same column name (append ASC or DESC) variable to your SQL box query,
I hope it'll help you.
Thanks
Deep