Add multi sort to table visualizations in the SQL runner

magnew commented 1 week ago

Make it possible to sort by more than one column at a time in the Table chart type in the SQL runner.

This is only for the table chart type, not for the chart results table!

The table chart type actually hits a different endpoint to the chart results table as well 👀

[ ] There should be a pill that shows me the sorts
[ ] The pill should say the number of sorts that are applied
[ ] I can click on the pill
[ ] If I open the pill, the sorts are listed.
- [ ] The first sort says Sort by
- [ ] Every sort after says then by
[ ] you're able to delete a sort by clicking on an x beside the sort (which appears on hover)
[ ] In the sort list, you can interact with the field names. If I click on the field name, I'm shown a list of the fields in my results table (with the field that's selected with a check mark beside it).
[ ] Beside the field name, there is the sorting indicated. This sorting can be changed from within the pill modal
- [ ] different to the app linked above!: we should use the same ordering indicators as we have in the Explorer
[ ] There is an option to add sort at the bottom of the modal
[ ] clicking on add sort makes the text disappear. In its place, a drop-down list opens with a search bar. The drop-down list contains the field names of the fields
- [ ] note: Bolt made me specify that the list was part of the modal here 👀 otherwise the modal would just close when I clicked on an item in the list
[ ] Once you click on a field name, the field appears in the list of sorts in the modal.

lightdash-bot commented 1 week ago

lightdash-bot commented 1 week ago

lightdash / lightdash