{"id":155,"date":"2022-06-09T18:32:44","date_gmt":"2022-06-09T18:32:44","guid":{"rendered":"https:\/\/docs.xlreport.com\/?post_type=docs&#038;p=155"},"modified":"2022-06-09T18:32:44","modified_gmt":"2022-06-09T18:32:44","slug":"sub-queries","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/add-tables-to-the-query\/sub-queries\/","title":{"rendered":"Sub-Queries"},"content":{"rendered":"<p>When adding an existing XLReport Query Object to the Query, the Sub-Query will be displayed in another Query Builder tab.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/21.png\" \/><\/p>\n<h2>Linked \/ Unlinked Sub-Query<\/h2>\n<p>By default a Sub-Query is linked to the original Query Object&#8217;s underlying Query.<\/p>\n<p>That means if you edit the original Query, its changes will be reflected at all Queries which use it.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/22.png\" \/><\/p>\n<h2>Edit Sub-Query<\/h2>\n<ul>\n<li value=\"1\">If you change the structure of the Sub-Query it will become unlinked .<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":151,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/155"}],"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=155"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/155\/revisions"}],"predecessor-version":[{"id":156,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/155\/revisions\/156"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/151"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}