{"id":199,"date":"2022-06-09T19:34:37","date_gmt":"2022-06-09T19:34:37","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=199"},"modified":"2022-06-14T18:04:39","modified_gmt":"2022-06-14T18:04:39","slug":"define-sorting","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/define-sorting\/","title":{"rendered":"Define Sorting"},"content":{"rendered":"<h2>Add Sort Order<\/h2>\n<ul>\n<li value=\"1\">Select the Sort Type column and assign the sort order either to <span class=\"DoIt\">Ascending <\/span>or <span class=\"DoIt\">Descending <\/span>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/26.png\" \/><\/p>\n<h2>Change the Sort Order<\/h2>\n<ul>\n<li value=\"1\">Change the Sort Order in the <span class=\"DoIt\">Sort Order<\/span> column.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/27.png\" \/><\/p>\n<p>Clear Sorting<\/p>\n<ul>\n<li value=\"1\">To clear a Sort order select the blank option on the Sort Type column.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":147,"menu_order":4,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/199"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/199\/revisions"}],"predecessor-version":[{"id":200,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/199\/revisions\/200"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Expression and Formulas","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/expression-and-formulas\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/203"}],"prev":[{"title":"Alias Names","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/alias-names\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/197"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=199"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}