Common parameters
Parameters available to many table based macros that support Common Table Capabilities
...
Number of rows to be considered as heading rows. Heading rows do not participate in column sorting.
...
Number of rows to be considered as footing rows. Footing rows do not participate in column sorting.
...
Normally all columns are treated as strings for sorting purposes unless a more specific sort type is provided either by the macro logic (SQL Macro) or by this parameter. The parameter is a comma separated list of column type indicators to identify column types.
- S - string
- I - integer
- F - float (since 5.1.0 may contain comma numeric separator)
- FC - float with comma as decimal separator and period as numeric separator (since 5.1.0)
- C - currency or similar where it is a float value with pre or post characters
- CC - C with comma as decimal separator (since 5.1.0)
- D - date in the browser date format. See advanced date sorting for more information
- E - emotions or other HTML elements (since 5.0.0)
- X - exclude this column from user selectable sorting
- H - hide the column
- . or - or : or / - separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by one of the separators indicated by the type.
...
A comma separated list of styles. Each style is made up of one or more properties. The first is applied to all heading rows determined by the heading parameter. The remaining styles are applied to the remaining rows in order with repetition as necessary. Example: , background:lightyellow;, background:lightblue;
...