Forge

Library to sanitize sort attributes to be safely used in an advanced SQLs "ORDER BY" clause. The provided functions usage is similar to the BuildSafe_InClause server actions in Sanitization.

It helps to sort a column of a table record on the client side, when using a data action instead of the aggregate, in some cases, a local variable is used instead of the list in the table record, and when doing a sort through the columns, we were not able to use the tablesort variable that was used in the aggregate, in some cases we can solve it with a listsort, but this can generate a lot of rework, because we have to make some conditions with “if” and according to each column we click, it returns a string, containing the name of the sort attribute, to define which table field will be passed in the by field, and this can be a bad point if you have several columns in the table record, and with this component, you just need to define a name for your table record, and pass its id inside the component, which it does the sorting for each column on the client side.

This component will allow a user to arrange the order and visibility of columns in a standard OutSystems table. It will also persist and be unique for users. 

Generates short, unique, non-sequential IDs from numbers