Skip to end of banner
Go to start of banner

How to show all table rows when using a query within a query

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 11 Current »

This article explains how to show all table rows when using a query within a query by using SQL for Confluence app.

Instructions

  1.  The following query is an example that uses a join and provides data to an outer query. Write the below code in a SQL Query macro and select Output format as Wiki as shown below:

  2. The output of the above query is as shown below:


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