Adding or modifying table parameters
Use the information in this section to add or modify table parameters. You can specify table parameters when you create or modify notifications.
When modifying a table's rendering options, note the following:
- Columns are numbered from left to right.
- You must separate the columns with an &.
- Separate multiple values within a single parameter with a |.
- You can leave out any and all parameters.
- Sorting works with a single sort column.
This table shows the standard parameters that you can apply to a table's individual columns, its valid values, and an example.
Parameter | Description and valid values | Example |
---|---|---|
Column | Column Number, for example, 2, 5 Use this value to specify which column you want to display. Values are:
|
colopt1=2&colopt2=1&colopt4=no This example swaps column one and two over and hides column four. The other columns are not affected. |
Filters | This parameter turns off the list of filters for a table. Filters usually appear between the title and the headers. | filters=NO |
Footer | This parameter turns off the conditional description that is inserted after the last row of data in a table. | footer=NO |
Headers | This parameter turns off the column headers. | headers=NO |
Horizontal Alignment |
|
|
Remainder Bucket | Row Name If you use sorting and limiting, all excluded rows are accumulated and put into a row with this name. |
colopt4=|D1|20|OtherCities This example sorts descending by column two, displays the top 20, and creates a row called Other Cities that aggregates the excluded rows. |
Sort Direction |
Sorting does not handle integer keys or dates. |
colopt4=|D1 This example sorts column four in descending order. colopt3=no|D5 This example sorts column three and then hides the column from the display. |
Title | This parameter turns off the title for the table. | title=NO |
Top x/x% | Integer | colopt3=|D1|80% This example shows the top 80% using column three. colopt5=|U1|10 This example shows the bottom 10 using column five. |