{"id":2242,"date":"2024-01-03T16:45:07","date_gmt":"2024-01-03T14:45:07","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=2242"},"modified":"2024-01-03T16:45:07","modified_gmt":"2024-01-03T14:45:07","slug":"redaguvannya-stovpcziv-tablyczi","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/3-storinky-v-zvitah\/sposib-vyboru-danyh-query\/redaguvannya-stovpcziv-tablyczi\/","title":{"rendered":"Edit Column Settings"},"content":{"rendered":"<p>After you have added the tables and selected the required columns, you can change settings for each column in the\u00a0\u201cGrid\u201d\u00a0pane:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_1_14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2253\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_1_14.png\" alt=\"\" width=\"960\" height=\"184\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_1_14.png 960w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_1_14-450x86.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_1_14-300x58.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_1_14-768x147.png 768w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/p>\n<p>The following settings are available for each column:<\/p>\n<ul>\n<li>Column \u2013 the possibility to select the required column from the combo box or add a new column. If necessary, you can customize the column expression. To do this, click the elision marks button for the respective column and specify an expression in the \u201cExpression Editor\u201d pop-up window;<\/li>\n<li>Table \u2013 the corresponding table names are displayed;<\/li>\n<li>Alias \u2013 the possibility to specify the column alias;<\/li>\n<li>Output &#8211; whether or not to display the columns in the query;<\/li>\n<li>Sorting Type \u2013 the possibility to specify the sort order for column values;<\/li>\n<li>Sort Order \u2013 the possibility to specify the order in which several columns are sorted;<\/li>\n<li>Group By &#8211; used in conjunction with the aggregate functions to group the result-set by one or more columns;<\/li>\n<li>Aggregate &#8211; allows to specify the aggregated function used to aggregate column values.<\/li>\n<\/ul>\n<p><\/p>","protected":false},"featured_media":0,"parent":2230,"menu_order":9,"template":"","manuals":[16],"class_list":["post-2242","manual","type-manual","status-publish","hentry","manuals-bat-admin"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/2242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/2230"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=2242"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=2242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}