{"id":149,"date":"2022-06-09T18:30:17","date_gmt":"2022-06-09T18:30:17","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=149"},"modified":"2022-06-14T18:04:38","modified_gmt":"2022-06-14T18:04:38","slug":"visual-query-designer-interface","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/visual-query-designer-interface\/","title":{"rendered":"Visual Query Designer Interface"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/15.png\" \/><\/p>\n<h2>Query Builder Panes<\/h2>\n<h3>Object Path<\/h3>\n<p>The Object path shows the bread-crumb structure of the Report Object location.<\/p>\n<h2>Connection<\/h2>\n<p>Shows the Data Connection of the Query Object.<\/p>\n<h3>Diagram Pane<\/h3>\n<p>The Diagram Pane allows to visually select tables \/ views and its fields to be included in the Query.<\/p>\n<h3>Grid Pane<\/h3>\n<p>The Grid Pane allows to select fields, assign expressions, sort orders, aggregate functions and apply criteria and parameters.<\/p>\n<h3>SQL Pane<\/h3>\n<p>The SQL Pane allows to edit the SQL syntax manually.<\/p>\n<h2>Query Synchronization<\/h2>\n<p>XLReport allows full synchronization between Diagram, Grid and SQL Panes.<\/p>\n<p>Once you change any setting in any pane all other panes will synchronize automatically.<\/p>\n<p class=\"note\">Important! When working with complex queries and sub-queries, synchronization between panes might slow down your work . Therefore it is recommended to turn the SQL pane off.<\/p>\n<ul>\n<li value=\"1\">To turn the SQL pane off, unselect View and SQL Pane on the menu bar.<\/li>\n<\/ul>\n<p class=\"note\">Tip! You can also write an SQL syntax manually or paste an existing SQL code and the Diagram and the Grid pane will synchronize.<\/p>\n<p class=\"SeeAlso\">\n","protected":false},"featured_media":0,"parent":147,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/149"}],"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=149"}],"version-history":[{"count":2,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/149\/revisions"}],"predecessor-version":[{"id":359,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/149\/revisions\/359"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Add Tables to the Query","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/add-tables-to-the-query\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/151"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=149"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}