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.

Instructions

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: