Column Pattern Formatting

You can configure the appearance of a column by either:

1. Defining a column pattern.
2. Setting column options within the component editor.
3. Adding an _SD_FORMATTER within the column name.

Below we detail how column pattern formatters allows configuring multiple columns at once.

Configuring Multiple Columns using Patterns

You may have many columns named similar or have dynamic columns which may only appear during a form change. You can create column name patterns to match these columns and apply formatting to them.

1. Within the component editor. Click Add Column Pattern
2. Type a javascript regex pattern into the new field that matches some set of columns.
3. In either the new Patterns compact editor or in the new coillapsible, set your configuraiton options and observe they are applied to all matching columns.

When you create a pattern, a new expandable menu appears for configuring those columns.

Configure Multiple Table Columns

Notice that the column specific option, overrides the pattern matched setting.

Example Code Used

Perform this query against DEMODB that comes built-in to Pulse to recreate the demo above.

SELECT TIME, BID,BID-10 AS BID1, BID-20 AS BID2, BID-30 AS BID3, ASk,ASk+10 AS ASk1, ASk+20 AS ASk2, ASk+30 AS ASk3 FROM quote WHERE NAME='NFLX' AND TIME>timestampadd(minute,-20,date_trunc('minute',CURRENT_TIMESTAMP())) ORDER BY TIME ASC;