Use case
You need to order the table data by the column containing complex version formats ( i.e. v1.6.151, etc).
Solution
- Switch the page to the edit mode.
- Insert the Table Transformer macro and paste the table within the macro body.
- Select the macro and click Edit.
- Switch to the SQL query tab.
Enter the following SQL query:
SELECT * FROM T1 ORDER BY (TEXT(IFNULL(T1.'versions', 0))->match("([0-9]+)")->1::number + IFNULL(TEXT(IFNULL(T1.'versions', 0))->match("[0-9]+.([0-9]+)")->1, 0) / 1000 + IFNULL(TEXT(IFNULL(T1.'versions', 0))->match("[0-9]+.[0-9]+.([0-9]*)")->1, 0)/1000000) ASC
- Save the macro and the page.