How to use the Expand array option in SQL for Confluence to view values with line break

This article illustrates how to use the Expand array option in SQL for Confluence app.


  1. Create a sample table, test_address2, as shown in this example:

    CREATE TABLE test_address2 (id int default NULL, first char(20) default NULL, last char(20) default NULL, city char(50) default NULL, children text[] ); 
  2. Insert some values in the newly created test_address2 table as shown in the example:

    INSERT INTO test_address2 VALUES (1,'Joe','Smith','Rochester', '{"roma","ruhi"}');     
    INSERT INTO test_address2 VALUES (2,'Mary','Jones','Chicago','{"ryan","rubby"}');
  3. Edit the SQL macro and select Display settings > Advanced formatting tab.

  4. Set the Expand array fields option as true, and click Save settings.

  5. Click Save to apply the changes.

In the given example, if Expand array is enabled, values are displayed as:

If Expand array is disabled, values are displayed as:

The Expand array option works only when the rows are set to vertical under Data layout tab of the macro.

Find answers from the community.

Ask a question to the community.

Log a request with our support team.

Confluence®, Jira®, Atlassian Bamboo®, Bitbucket®, Fisheye®, and Atlassian Crucible® are registered trademarks of Atlassian®
Copyright © 2005 - 2022 Appfire | All rights reserved. Appfire™, the 'Apps for makers™' slogan and Bob Swift Atlassian Apps™ are all trademarks of Appfire Technologies, LLC.