.png?version=1&modificationDate=1662627367996&cacheVersion=1&api=v2&width=226&height=72)
Combine queries from multiple databases - 10.x
- Saumya Sunder (Inactive) (Deactivated)
- Nisha Shantilal
- Smita Nair
- Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)
Description
The SQL macros make it possible to combine queries from multiple databases and data sources by using embedded SQL macros. This is a very powerful technique to integrate diverse data into a single view for data consumers. This makes for limitless opportunities based on using crafty SQL. In some cases, it can be tricky, but the results are worth it.
The technique is exactly the same as with nested queries with the only difference being the data source you choose on each of the inner queries.
Related article
Log a request with our support team.
Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2024 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.