{"id":147,"date":"2022-06-09T18:28:15","date_gmt":"2022-06-09T18:28:15","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=147"},"modified":"2022-06-14T17:59:40","modified_gmt":"2022-06-14T17:59:40","slug":"query-your-data","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/","title":{"rendered":"Query Your Data"},"content":{"rendered":"<p>The visual XLReport Query builder allows to create SQL queries without SQL or code knowledge.<\/p>\n<p>You can create queries from your database objects like tables, views and stored procedures and also from existing XLReport queries.<\/p>\n<p>You can even combine database objects and XLReport queries.<\/p>\n<h2><a name=\"Create\"><\/a>Create a new Query Object<\/h2>\n<ul>\n<li value=\"1\">Click <span class=\"DoIt\">&gt;Query&gt;New<\/span> on the menu bar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/33.png\" \/><\/p>\n<p>The Visual Query Builder will open.<\/p>\n<h2><a name=\"Edit\"><\/a>Edit a Query Objet<\/h2>\n<ul>\n<li value=\"1\">Select the Query Object in the <span class=\"DoIt\">Project Explorer <\/span>, select <span class=\"DoIt\">Edit XLReport Query<\/span>.<\/li>\n<li value=\"2\">Click <span class=\"DoIt\">&gt;Query&gt;Edit<\/span> on the menu bar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/34.png\" \/><\/p>\n<p>The Visual Query Builder will open.<\/p>\n<h2><a name=\"Save\"><\/a>Save Query<\/h2>\n<ul>\n<li value=\"1\">Inside the Visual Query Builder click <span class=\"DoIt\">&gt;Query Object&gt;Save<\/span> to save the Query.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/80.png\" \/><\/p>\n<h2><a name=\"SaveAs\"><\/a>Save Query As<\/h2>\n<ul>\n<li value=\"1\">To save the Query as a new one click As<span class=\"DoIt\">&gt;Query Object&gt;Save<\/span> to save the Query.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/81.png\" \/><\/p>\n<h2><a name=\"Delete\"><\/a>Delete a Query Object<\/h2>\n<ul>\n<li value=\"1\">Select the Query Object in the <span class=\"DoIt\">Project Explorer <\/span>, select <span class=\"DoIt\">Delete XLReport Query<\/span>.<\/li>\n<\/ul>\n<p class=\"SeeAlso\">\n","protected":false},"featured_media":0,"parent":106,"menu_order":4,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"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=147"}],"version-history":[{"count":3,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147\/revisions\/358"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/106"}],"next":[{"title":"Insert Data into Excel","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/insert-query-data-into-excel\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/224"}],"prev":[{"title":"Data Connections","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/data-connections\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/144"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=147"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}