Rank 1
Iron
Iron
Dear Supprot Team,
I have a tricky task to do, and i cant figure out how to approach. On the below screenshot you can see two grids (marked with red arrow)
They have one common key, the 'ITEM CODE'. I have to keep these grids in sync from sorting and filtering and scrolling point of view, and in 2 of 3 i could solve. I can keep sync between scrollbars, i can also filter the rows based on any column of the both grid, but im in trouble iwth the sorting.
If i sort by ITEM CODE in any of the both grid, it sorts the other grid too perfectly, i achieved it with this simple line:
rgv_COVERAGE.SortDescriptors.Add(rgv_RAWMAT.SortDescriptors(0))
But the rest of the column names are different, and if i sort by any of them it doenst reflect on the other.
With other words, if i sort by 'STOCK' for example on the left grid (rgv_RAWMAT) then it will result a kinda random ordering in the
'ITEM CODE' column here, and it wont reflect the 'ITEM CODE' column and the others either of the right grid (rgv_COVERAGE).
Please help me how can i achieve that soring aplies on the opposite side to (by the key-column: ITEM CODE), independently of which columnheader i clicked to.
Million thanks
Peter
1 Answer, 1 is accepted
Hello Peter,
Thank you for the provided image.
If I have understood correctly your case, only the first column is equal for both grids. The result is kind of expected. If you sort the Stock column in the first grid, transferring the same SortDescriptor won't lead to the same result to the second grid. My suggestion here, if the user sorts a different column in the first grid, check which column is sorted and sort the second grid manually with the corresponding column. You could check the Setting Sorting Programmatically help article which I think will get in handy.
Can you give this article a try and let me know if this helps you?
Regards,
Dinko
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Rank 1
Iron
Iron
Dear Dinko,
How do you mean 'manually with corresponding column'? there is no 'STOCK' or any other of columns on the other side , except the common key column 'ITEM CODE'
If i sort with 'STOCK' it sorts the ITEM CODE of the first grid as well in a random way - from the other grid point of view, so i cant transfer this random ordering, because there is no descriptor like that, only ascending and descending. What would be the descriptor.propertyname to the right grid if i push STOCK header of the left grid?
The best would be if i could pass the list of item codes in the childrows of the left grid after sorting, pass them to the right grid's 'item code' as a descriptor. But there is no such a thing...
