Hi Stefan,

Thanks for the reply.

The sample project you created shows exactly the issue I'm having.

Even though you set e.Cancel = true for the Sorting event, after adding SortDescription you can see that grid gets sorted the first time you click any label. This means that adding SortDescription triggers sorting somehow and setting e.Cancel = true does not help here.

For filtering I'm using RecordFilterChanging event in analogic way as for sorting and I'm observing the same behavior: modifying RecordFilters collection on FieldLayout also triggers default filtering even though I set e.Cancel = true.

Thanks for the response.

Your solution solves the issue, but seems to be complicated for this particular task (as far as filtering is concerned). I guess there is simply no easy answer for this.

Currently I simply do sorting/filtering work twice: once by myself and second time - let the grid do it. Since my sorting and filtering uses the same principles for comparison, but does it on the SQL level, XamDataGrid default behavior does not break sort order or change filtered rows. This means user should not see the difference.

That's why for now I will stay with the current approach, but your response Stefan for sure is an answer for this issue and thanks for that.

Hello,

Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.

Thanks again.

Hi 

I am facing a similar issue. I am sorting the grid in the code, and binding the result to the grid. I have looked at your samples, and figured how to prevent the grid from executing the sort and also to show the sort indicator without adding sort descriptions to the grid in code.

But i am not able to figure out how to change the Sort Indicator to correspond to the Sort Direction. Right now when i make the Sort Indicator visible it always shows the Sort indicator as Descending. I was also relying on the Sort Status value changing in the xaml to change the color of the column header when it is sorted on.  

I want to show the right Sort Indicator based on the actual sort direction. I wont be able to add the Sort Description to the grid since i dont want the grid to sort on the clicked field. Back end code sorts on a different field when user clicks to sort the field. So adding Sort descriptions and letting the grid do the sorting will mess up the Sort order.

Any help is appreciated

Thanks

SR

Hello Shahin,

Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.

Thanks again.