How to sort based on all data for custom visuals

All forum topics
Previous Topic
Next Topic

So lets say I have a dataset with 10,000 values. These values are simply 1-10,000

I load batches with 100 values at a time. When I call sort on my custom table by ascending, I get 100, 99, 98 etc. But what I really want is for the sort to query the database, and return the values 10,000, 9999, 9998 etc.

Is this possible? I want to avoid using the filter pane if possible. I noticed that the original tables make a querydata call when sorting values. How can I replicate this?