sort live grid

  With Delphi Berlin update2, datasnap+rest+json+aurelius+firemonkey we are trying to sort a live grid without success.
  In v3.6.2.0:
   - New : LoadAllDataAndDisconnect to load all data at once and perform filtering sorting grouping ... in TTMSFMXLiveGrid.
   How could this work in my scenario?


With LoadAllDataAndDisconnect, you load all data in to the grid and disconnect from the dataset. This way, you can operate on the grid as you would on a normal grid without an active LiveBindings connection. The data is stored inside the grid. Editing during this operation is not possible. You could use this function and filter the data, but as soon as editing is needed you'll need to reconnect to the dataset.