Store Procedure Order by is correct, but when return back to Radzen the result is not order by

cllor · February 14, 2022, 6:46am

Hi,

In my radzen page, I created a DataGrid and calling a Store Procedure in LoadData. From my Store Procedure query have a order by condition and I do expected when return the result to Radzen it will follow but now seems like the result do not follow the order by.

mumfie · February 15, 2022, 3:10pm

@cllor If the usp returns an ordered result set you might find data grid/column properties eg. sorting, paging are overriding it.

cllor · February 21, 2022, 3:26am

Hi @mumfie ,

Are you referring to the data grid properties LoadData event sorting? As i already took off but still not sort follow by the usp.

mumfie · February 21, 2022, 9:00am

and with paging enabled (small dataset)

cllor · February 22, 2022, 8:51am

Hi @mumfie ,

I see, I tested out the [AllowPaging] will override the usp order result. After uncheck the [AllowPaging], the dataGrid return the result same as usp return result.

Thank you.