{"id":10913275,"date":"2018-11-24T19:14:55","date_gmt":"2018-11-24T19:14:55","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/row-sorting-based-on-defined-text-numbers\/"},"modified":"2018-11-24T19:14:55","modified_gmt":"2018-11-24T19:14:55","slug":"row-sorting-based-on-defined-text-numbers","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/row-sorting-based-on-defined-text-numbers\/","title":{"rendered":"Row Sorting Based on Defined Text\/Numbers"},"content":{"rendered":"<p>Hi,<\/p>\n<p>When a user first comes to my site, I want rows to be sorted automatically based on text included in columns 7 &amp; 8.<\/p>\n<p>I thought the best way here would be to include row sorting, however how can you do this based on setting a defined order.  For example, I want rows to be sorted in this order:<\/p>\n<p>Live<br \/>\nIn XX days<br \/>\nEnded<\/p>\n<p>Im aware of the other method in creating a hidden column and setting a number value to then sort this way, however the issue is that the text in columns 7 &amp; 8 are not fixed and include shortcode for a countdown timer.  So text will effectively change upon a certain date being met or expired, hence the live, days then ended words above.<\/p>\n<p>How can this be done?<\/p>\n<p>Site is www.stoblock.io<\/p>\n<p>Thanks<br \/>\nAnthony<\/p>\n","protected":false},"template":"","class_list":["post-10913275","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/10913275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/10913275\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=10913275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}