Looking for a solution. We have large grids with multiple date fields (formatted to short dates) If the sort is enabled for the multiple date columns it stops working. The sort works fine with any other column. It will usually work for the dirst date column but after the second date column is clicked for sorting none of the columns will sort until you refresh the page. Is there a work around that will make this work as I prefer being able to sort the column with having to use the query filter that reloads the data.
I will need some additional information to assist you with this issue.
Also please provide more information on how you want to format the date. If a recording of what you are seeing is possible that would also be great.
1. It is a gridadvanced that was migrated from 9.0 to 9.3
2. The Build is ThingWorx 9.3.5-b1258.
3. Date formatted as ShortDate using column renderer
4.. I can not provide an export of data source here.
5. When I click on the sort Icon for the second or third date column nothing happens, the icon does not register as ascending or descending. Columns before that work fine and after clicking then none of the columns no longer register clicks.
RBA Submitted and CRP submitted are both date columns and there are more date columns to the right.
The grid doesn't support nested sorting. I have provided a possible work around for you to consider that may provide you with a solution.
Please let me know if this is an acceptable solution for your issue.
I am not referring to a nested sort. If there are multiple date columns with sort enabled, sorting doesn't work on the later column even if that is the only column being sorted. Before upgrading to 9.3 we used query filter search JSON you reference but it requires reloading the grid which is not desirable for large data sets. It is what we have to revert to but what we are seeing is a bug when there are multiple date columns in the data set with sorting enabled.