Column Sorting not working

  • Resolved GoodShark

    (@goodshark)


    6 years, 12 months ago

    I’m trying to get the columns that are measured in feet to be sorted properly, but it doesn’t work. It seems to work on the backend editing, but when it’s previewed, it doesn’t work.

    It seems to think that 9′ is bigger than 10′, I assume it has something to do with it being double digits.

    Height works fine, because none of the values go into double digits, but the block and spike touch both get screwed up when one of the values is under 10′.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 years, 12 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    The cause for this is that writing a cell value as e.g. 10’8″ technically turns that value into text string and not a number – and text strings are sorted differently than numbers. You’d be seeing the same with the weight, if someone were to have less than 100lbs.

    Your best chance to work around this is probably to use the approach from https://wordpress.org/support/topic/date-order-6/ which deals with a very similar scenario. In your case, the extra column with the data for sorting could be the feet and inches written like “1008” for 10’8″, and e.g. “911” for 9’11”.

    Regards,
    Tobias

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Column Sorting not working’ is closed to new replies.