Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 24, 20222 yr In Pages, we can create a field with a type Number. The field is created as VARCHAR in MySQL. This does not allow us to sort by this field with correct alphanumeric order. The sorting by this field results in: 1 10 2 42 9 You have to cast the values if ordered by this field SELECT * FROM table_name ORDER BY CAST(field_name as SIGNED INTEGER) ASC EDIT: I mean the sorting in record feed block or getItemsWithPermission. Edited March 24, 20222 yr by Sonya*