Custom views - How to sort against dates and numbers without issues

Marcin_SzablowskiMarcin_Szablowski Customer IT Monkey ✭
edited October 8 in View Builder

Sorting by date doesn't work correctly for Ascending/Descending search under custom view. The data is not sorted as dates should be (it's just comparing digits in a row - that's why 6/2 is between 6/20 and 6/19).  

The same thing is happening to ticket numbers If I sort descending numbers that consist of seven digits (the first digit is 1) are after those consisting of 6 digits (the first digit is 9).

Do you have any idea on how can I fix that?




 

Answers

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    How are you building the custom view.
    Promoted views from the console or SQL table widgets?
  • Marcin_SzablowskiMarcin_Szablowski Customer IT Monkey ✭
    Hi Brian, Thanks for comming back to me. I used promoted views. 
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Might be the version of the portal you are using. There have been some bugs with promoted views and some of the portal updates.
  • Tom_HendricksTom_Hendricks Customer Super IT Monkey ✭✭✭✭✭
    It seems that all views other than My Work, Team Work, My Requests, Team Requests, and Active Work treat date columns as text.  This has affected not only promoted views but also dashboards since v8.0 IIRC.
  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    @Tom_Hendricks ; The release notes shows it was revolved with v8.5.0 fixing PR67851
    I am currently running v8.9.3 and ID and Dates are working properly on all tables. Both Promoted views and SQL widgets.

  • Tom_HendricksTom_Hendricks Customer Super IT Monkey ✭✭✭✭✭
    edited October 10
    It certainly does say that, but I have installed every version before and since and it has never functioned properly since v8 (the browser, device, cache all have no bearing on it).

    The columns sort as text.  As further evidence of the issue, one can look at the filters on the same column.

    This is portal v8.9.3:

    Which should look like (taken from My Work):

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
    Wonder if it has anything to do with the version of the MP for views when promoted. If you promote a new view does it show correctly? I think I may have had to go and republish some views at one point.
Sign In or Register to comment.