{"id":13272256,"date":"2020-08-18T04:07:25","date_gmt":"2020-08-18T04:07:25","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sort-by-integer-not-string\/"},"modified":"2020-08-18T04:07:25","modified_gmt":"2020-08-18T04:07:25","slug":"sort-by-integer-not-string","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sort-by-integer-not-string\/","title":{"rendered":"Sort by integer not string"},"content":{"rendered":"<p>Hi! You have a great plugin here that has so many options and uses for displaying data.<br \/>\nI am having a bit of an issue getting it to display scores correctly in order from greatest to least. Here is my site:<br \/>\nhttps:\/\/faucetgamers.com\/games\/frogger-high-scores<\/p>\n<p>Take notice of Diego who has the highest score is on the bottom.<\/p>\n<p>It seems to be recognizing the number as a &#8220;String&#8221; rather than an &#8220;Int&#8221; and so sorting it based on length. I am near 100% certain that the form has a number submission being taken in from contact form 7 submission form. The sort though is treating it as a string.<\/p>\n<p>Is there anything I can do to change this?<br \/>\nHere is my shortcode that I&#8217;m using to display this:<\/p>\n<p>[cfdb-datatable form=&#8221;High Score Frogger&#8221; class=&#8221;datatable&#8221; show=&#8221;User_Login,score,Submitted&#8221; filter=&#8221;_ctc_status=Done&#8221; limit=&#8221;20&#8243; orderby=&#8221;score DESC&#8221; headers=&#8221;score=Score,Submitted=Date Submitted,User_Login=Username&#8221;]<\/p>\n<p>Thank you!<\/p>\n","protected":false},"template":"","class_list":["post-13272256","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13272256","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\/13272256\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=13272256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}