GridGroupingSorting demo, MultiColumnSort not working?

[Kast2k]

Dear colleagues,

I received a request about addition of multi columns sorting in grid.

In demo GridGroupingSorting i found that it is possible.

But, as i see when you are clicking on any sortable column then Columns: TUniDBGridColumnArr and  Directions: TUniSortDirections always have length of 1, so generated SQL row will always produce sorting by single field.

Is it bug or feature or may be MultiColumnSort logic is other?

Grouping.Enabled was set to false;

 

[Sherzod]

1 hour ago, Kast2k said:

Columns: TUniDBGridColumnArr and  Directions: TUniSortDirections always have length of 1

Hello,

Are you sure?

[Kast2k]

Yes, take a look on video.

Sources attached.

GridGroupingSorting.zip

[Kast2k]

The target is to received something like "select * from [Customers] order by [ContactTitle] ASC, [Region] DESC" if i'm understanding right Multi Column sorting

[Sherzod]

Can you test with this config?:

procedure TMainForm.UniFormCreate(Sender: TObject);
begin
  UniDBGrid1.JSInterface.JSConfig('multiColumnSort', [True]);
  ...
end;

 

[Kast2k]

Thanks, Sherzod,

But sorting is not working OK, it's not following the click order.

Video:

 

[Sherzod]

OK,

We will check it.

[Farshad Mohajeri]

Problem here is that sort fields come in reversed order. This will be fixed in next build.