{"id":138,"date":"2020-12-11T01:01:11","date_gmt":"2020-12-11T05:01:11","guid":{"rendered":"http:\/\/wdp.g-integrator.com\/docs\/?p=138"},"modified":"2023-11-13T11:30:42","modified_gmt":"2023-11-13T15:30:42","slug":"tutorial-sort-output-by-fields","status":"publish","type":"post","link":"https:\/\/wdp.g-integrator.com\/docs\/2020\/12\/11\/tutorial-sort-output-by-fields\/","title":{"rendered":"Tutorial: Sort Output by Field(s)"},"content":{"rendered":"\n<p>This process sorts the data by (a) specified field(s)<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><br>1.  Follow standard process to get module records (<a href=\"http:\/\/wdp.g-integrator.com\/docs\/2020\/11\/28\/tutorial-get-module-records\/\">See tutorial for step by step instructions<\/a>). DO NOT PRESS EXECUTE<\/p>\n\n\n\n<p><strong>THE FOLLOWING STEPS MUST BE TAKEN BEFORE PRESSING EXECUTE<\/strong><\/p>\n\n\n\n<p>2. After selecting desired fields, Select option 4 &#8220;Order Results by (optional)&#8221;<\/p>\n\n\n\n<p>3. Select field to sort by and whether to sort in ascending or descending order<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"366\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/031.png\" alt=\"\" class=\"wp-image-139\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/031.png 753w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/031-300x146.png 300w\" sizes=\"(max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>4. If you wish to further sort  by another field (after the first level of sorting) press the &#8220;<strong>+<\/strong>&#8221; (plus) and repeat step 3. To remove  a field press the &#8220;<strong>&#8211;<\/strong>&#8221; (minus)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"764\" height=\"373\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/032.png\" alt=\"\" class=\"wp-image-140\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/032.png 764w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/032-300x146.png 300w\" sizes=\"(max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/figure>\n\n\n\n<p><strong>Sample result (sorted by Account Type and Billing City):<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"444\" height=\"692\" src=\"http:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/033.png\" alt=\"\" class=\"wp-image-141\" srcset=\"https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/033.png 444w, https:\/\/wdp.g-integrator.com\/docs\/wp-content\/uploads\/2020\/12\/033-192x300.png 192w\" sizes=\"(max-width: 444px) 100vw, 444px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This process sorts the data by (a) specified field(s) 1. Follow standard process to get module records (See tutorial for step by step instructions). DO NOT PRESS EXECUTE THE FOLLOWING STEPS MUST BE TAKEN BEFORE PRESSING EXECUTE 2. After selecting desired fields, Select option 4 &#8220;Order Results by (optional)&#8221; 3. Select field to sort by &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/wdp.g-integrator.com\/docs\/2020\/12\/11\/tutorial-sort-output-by-fields\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Tutorial: Sort Output by Field(s)&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,6,5],"tags":[11],"_links":{"self":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/138"}],"collection":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/comments?post=138"}],"version-history":[{"count":1,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/138\/revisions"}],"predecessor-version":[{"id":142,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/posts\/138\/revisions\/142"}],"wp:attachment":[{"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/media?parent=138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/categories?post=138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wdp.g-integrator.com\/docs\/wp-json\/wp\/v2\/tags?post=138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}