{"id":23828,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/sorting-report-result-columns-1\/"},"modified":"2025-02-06T19:18:45","modified_gmt":"2025-02-07T03:18:45","slug":"sorting-report-result-columns-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/","title":{"rendered":"Sorting Report Result Columns"},"content":{"rendered":"<p>You can resort the output from a Quicklist or other report by pressing the title at the head of the column.<\/p>\n<p><img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/resorting_report_columns.png\" width=\"90%\" \/><\/p>\n<p><span class=\"imageCaption\">Resorting Report Columns<\/span><\/p>\n<p>The current sort is shown with an arrow. When you first click on the title, it will resort by that column, in ascending order. If you press the same column label again, the column will be sorted in descending order.<\/p>\n<p>Each time you press a label to resort the report output, the previous sort order is remembered, and becomes a secondary sort within the report.<\/p>\n<p>Not all fields can be sorted, and the ExtraView administrator has the ability to make decisions about which fields can be used for sorting. If you cannot sort a column, there will be no icon besides the column heading, and the heading appears in a different color.<\/p>\n<p>Sorting multi-valued list fields can have results that at first glance do not give the results you expect. First, when you click on a field to sort the results, and then click on a second field to sort by that new field, the original sort order is retained as a secondary sort to the second sort. Now, with multi-valued fields, you will get duplicated rows with sorted values appearing at all the positions where they belong, according to the sort. This is true whether the sort field is the primary sort field or not. A further complication is that when duplicated rows appear adjacently in the report, the second is elided, i.e. you will never see the same row twice together in the report. This can change the number of rows rendered, depending on the sort.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can resort the output from a Quicklist or other report by pressing the title at the head of the column. Resorting Report Columns The current sort is shown with an arrow. When you first click on the title, it will resort by that column, in ascending order. If you press the same column label&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23769,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-23828","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sorting Report Result Columns - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sorting Report Result Columns - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"You can resort the output from a Quicklist or other report by pressing the title at the head of the column. Resorting Report Columns The current sort is shown with an arrow. When you first click on the title, it will resort by that column, in ascending order. If you press the same column label...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-07T03:18:45+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/\",\"name\":\"Sorting Report Result Columns - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-07T03:18:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"End User Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Reporting\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Sorting Report Result Columns\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sorting Report Result Columns - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/","og_locale":"en_US","og_type":"article","og_title":"Sorting Report Result Columns - Product Documentation","og_description":"You can resort the output from a Quicklist or other report by pressing the title at the head of the column. Resorting Report Columns The current sort is shown with an arrow. When you first click on the title, it will resort by that column, in ascending order. If you press the same column label...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-07T03:18:45+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/","name":"Sorting Report Result Columns - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-07T03:18:45+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/sorting-report-result-columns-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"End User Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/"},{"@type":"ListItem","position":4,"name":"Reporting","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/"},{"@type":"ListItem","position":5,"name":"Sorting Report Result Columns"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23828","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=23828"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23828\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23769"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}