{"id":222,"date":"2022-06-09T19:47:19","date_gmt":"2022-06-09T19:47:19","guid":{"rendered":"https:\/\/docs.xlreport.com\/docs\/admin-user\/union-queries\/"},"modified":"2022-06-14T18:04:39","modified_gmt":"2022-06-14T18:04:39","slug":"union-queries","status":"publish","type":"docs","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/union-queries\/","title":{"rendered":"Union Queries"},"content":{"rendered":"<p>Create a Union Query<\/p>\n<ul>\n<li value=\"1\">To create a union Query <span class=\"DoIt\">right click<\/span> on the Diagram Pane and select <span class=\"DoIt\">Union<\/span>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/51.png\" \/><\/p>\n<ul>\n<li value=\"1\">Select <span class=\"DoIt\">New union sub-query<\/span> .<\/li>\n<\/ul>\n<ul>\n<li value=\"1\">Select the <span class=\"DoIt\">left Q<\/span> .<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/52.png\" \/><\/p>\n<ul>\n<li value=\"1\">Drop the table \/ view or Report Object to the Diagram pane.<\/li>\n<li value=\"2\">Select fields to be queried.<\/li>\n<li value=\"3\">Select the <span class=\"DoIt\">right Q<\/span> .<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"https:\/\/docs.xlreport.com\/wp-content\/uploads\/docs-images\/52.png\" \/><\/p>\n<ul>\n<li value=\"1\">Drop the table \/ view or Report Object to the Diagram pane.<\/li>\n<li value=\"2\">Select fields to be queried.<\/li>\n<li value=\"3\">Click on the Union symbol and select the union type.<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":147,"menu_order":10,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/222"}],"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=222"}],"version-history":[{"count":1,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/222\/revisions"}],"predecessor-version":[{"id":223,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/222\/revisions\/223"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Save Your Query","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/save-your-query\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/395"}],"prev":[{"title":"Query Properties","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/query-properties\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/220"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}