Hi Vincent! As a super unhelpful note, mappers are basically just frontend and sorting is backend, so when you sort a table, it sorts based on the true data rather than the mapped data.
Would you be open to converting this data into a boolean in a JS transformer before showing it in the table? That way you could sort the boolean data since the data is coming from the "backend"! Here's a quick example:return Object.assign({{query1.data}}, {id: {{formatDataAsArray(query1.data)}}.map(row_obj => row_obj.id % 2 == 0) })
1 Like