Hi,

is it possible to sort an ARI Data Table (server side pagination enabled) by a calculated column.

I am able to get the table to sort on load and continue to load properly by selecting any of the pagination numbers by using



in the SQL query.

The problem occurs when you try to sort the same table by clicking the Column Header name of the calculated column. This results in "No matching records found"

Thanks

trevor

Hello,

It is not possible when "Server side pagination" is enabled.

Regards,
ARI Soft

Are you able to add something like this as a custom project?

Do you want to use "ORDER BY" in your query to set default sorting and then change it when a user click by column name in a table?

Regards,
ARI Soft

I can use "ORDER BY" within a query but would prefer to specify the 'Column Index' along with 'Sorting Type' of the column within the module parameters 'Column Settings'. Once the table is loaded on the user side, they would then be able to click a column heading of a calculated column and have results displayed

Could you provide a sample of SQL query which you want to use?

Regards,
ARI Soft