Sorting

[yotamgever]

As a viewer, I want to be able to sort the pivot columns by clicking their title, so I can control the Pivot display and present the data that interests me the most at the top/bottom.

• Available sort options:

  1. Ascending
  2. Descending
  3. No sort (data in its original order)

  Right clicking the Pivot column title should open the column menu items, including the 'Sort' menu, which will open the 3 sub-menu options.

Note: Sorting by multiple columns is described as a new requirement

[yotamgever]

Sql default sorting should be considered in order to prevent the streaming bug

[deanshub]

Sql default sorting should be considered in order to prevent the streaming bug

to elaborate currently when sorting the old pivot, the jaql receives a sort attribute,
once the translation proccess sees the sort in the jaql, it removes (doesn't put it in the first place) the default sorting (by rows).

we should take the sort provided by the user, remove it and send the jaql without it, then as the results are streamed back from the elasticube, we should sort them (with the user's sort) inside nodeJs and send them to the client

[orelse94]

time estimation 5 days