{"id":151,"date":"2022-06-09T18:31:04","date_gmt":"2022-06-09T18:31:04","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=151"},"modified":"2022-06-14T18:04:38","modified_gmt":"2022-06-14T18:04:38","slug":"add-tables-to-the-query","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/add-tables-to-the-query\/","title":{"rendered":"Add Tables to the Query"},"content":{"rendered":"<ul>\n<li value=\"1\">To add database tables \/ views \/ stored procedures select <span class=\"DoIt\">&gt;Add Data Objects&gt;Add Database Objects<\/span> on the menu bar.<\/li>\n<\/ul>\n<p class=\"note\">Note! Stored Procedures are only supported by Data Connections to MS SQL Server, Oracle and MySQL databases.<\/p>\n<ul>\n<li value=\"1\">To add XLReport Query objects select <span class=\"DoIt\">&gt;Add Data Objects&gt;Add Query Objects<\/span> on the menu bar.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/16.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select the Objects to add and drag and drop into the Diagram Pane.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/17.png\" \/><\/p>\n<ul>\n<li value=\"1\">When finished adding all required tables \/ views \/ Queryobjects click the <span class=\"DoIt\">Close <\/span>button.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":147,"menu_order":1,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/151"}],"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=151"}],"version-history":[{"count":2,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/151\/revisions"}],"predecessor-version":[{"id":360,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/151\/revisions\/360"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Add Fields to Query","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/add-fields-to-query\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/195"}],"prev":[{"title":"Visual Query Designer Interface","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/visual-query-designer-interface\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/149"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=151"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}