Skip to end of banner
Go to start of banner

How to combine queries from multiple databases

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

  • No labels

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.

Error formatting macro: appfire-confluence-analytics: java.lang.NullPointerException: Cannot invoke "com.atlassian.confluence.xhtml.api.MacroDefinition.getMacroId()" because "macroDefinition" is null