For Cerner’s support and commitment to our clients regarding COVID-19, see the Cerner COVID-19 Response Center page on Cerner.com to access Cerner Recommendations, FAQs, and Lessons From the Field and visit the COVID-19 Client Collaboration Forum to ask questions and share experiences.
uCern is migrating to a new platform effective May 4, 2021 There will be no downtime. Cerner Wiki is not impacted by this migration.
uCern Help


Cerner Wiki Help

uCern Help

uCern System Requirements

Child pages
  • Table Plus Macro
Skip to end of metadata
Go to start of metadata
The version of this page that you are viewing is the most current, approved content.

 

Overview

 

The Table Plus macro adds advanced functions and formatting to Wiki tables, by:

  • Dynamically totaling numeric data.
  • Dynamically numbering each table row.
  • Defining the default sort order for the table.
  • Highlighting a row when the user hovers the pointer over it.

Basic Use

This macro can be deployed using one of the following methods:

Selected from the Macro BrowserTable Plus
Markup Shortcut{table-plus}

In the body of the macro, insert a Wiki table as you normally would and edit the row and columns as needed. On rendering or preview, the table-plus macro will process the table to add the advanced capabilities according to the parameters specified on the macro.

Screenshot

Parameters

(info) Click a column heading to toggle the sorting of that column.

 ParameterDefaultMacro Browser LabelDescription
1multipletrueMultiple table processing

All embedded tables are affected by the table properties specified. Set to false to only apply the table properties to the outer table.

Common Parameters

The following parameters are part of our common table capabilities that are available to many macros that produce or modify tables.

(info) Click a column heading to toggle the sorting of that column.

 ParameterDefaultMacro Browser LabelDescription
1

heading

1Heading rows

Number of rows to be considered as heading rows. Heading rows do not participate in column sorting.

2

footing

0Footing rows

Number of rows to be considered as footing rows. Footing rows do not participate in column sorting.

3

enableSorting

trueEnable column sortingSet to false to disable sorting.
4

enableHighlighting

trueEnable row highlighting on mouse overAs the mouse moves over a table row, the row will be highlighted by default. Set to false to stop this behavior.
5

sortColumn

 Auto sort columnThe table can be auto sorted before it is displayed by any valid column name or number provided by this parameter. No auto sorting will be done if this value is not provided or is invalid. A column number is a 1-based count of columns (excluding auto number column).
6

sortDescending

falseSort descendingIf sortColumn is used, this determines the order of the sort that is automatically done before display.
7

sortTip

 Sort tip on mouse overText displayed when mouse is over a sortable column. Normally, this value is Click to sort or equivalent translation.
8

sortIcon

falseShow sort iconUse true to include a sort icon in the first heading row for sortable columns. An icon will show for the last column sorted indicating the direction the column was sorted.
9

highlightColor

lightgoldenrodyellowHighlight colorColor of row when mouse is over a row element.
10

autoNumber

falseAuto number on each rowUse true to show an additional column that show row number for each data row.
11

autoNumberSort

falseAuto number sortUse true to enable the auto number column to be sortable. This will retain the original data row count even after row sorting.
12

autoTotal

falseAuto total rowUse true to append a row to the end of the table that will contain totals of all numeric columns.
13allowExportfalseAllow download and export

Enable user to download or export the table (as an attachment to the page) as a CSV file. Export is only available to users that have permission to add attachments to the page. When enabled, download and export icons will be available to the right of the table. This is a new option starting with Advanced Tables 7.2. It will be available later with SQL 8.3, and Excel 6.3.

14

columnTypes

 Column types
Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. Some macros, like the SQL and CSV macros, may automatically generate more precise types. When the default behavior is less than optimal for your situation, the columnTypes parameter can be set specifically. This describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry. 
TypeDescriptionSorting

Total Formatting

Data Formatting
SText string. This is a series of one or more alphanumeric characters, possibly including a letter, number, space, punctuation mark or other special characters.Alphabetic  
IInteger. This is a numeric field without a fractional component.Numeric(tick) 
FNumeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator.Numeric(tick) 
FFNumeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. Forced formatting of data columns.Numeric(tick)
FCNumeric or float value and may contain numeric separators including a comma for decimal separator and a period for thousands separator.Numeric(tick) 
CSimilar to F with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored.Numeric(tick) 
CCSimilar to FC with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored.Numeric(tick) 
M

Date format in many popular formats. This is the preferred date sorting type.

Date (tick)
DDate in the browser date format. The D type is available for compatibility with older releases - the M type is recommended.Date  
EEmotions or other HTML elements.Alphabetic on the inner HTML value  
XIndicates to exclude this column from user selectable sorting.Disabled  
.Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '.'.Numeric on each separated value  
:Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by ':'.Numeric on each separated value  
- Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '-'.Numeric on each separated value  
/Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '/'.Numeric on each separated value  
HIndicates to hide the column.   
 
  • Total formatting - option to format the total row in a user defined way.
  • Numeric data formatting - option to format the data rows in a user defined way for numeric columns.
  • Date data formatting - option to format the data rows in a user defined way for date columns.
15columnCalculations Column calculations
When an auto total row is selected, this parameter can be used to customize the calculation or text that is shown on the total row. By default, all numeric fields, as specified by column types, are totaled. By specifying a comma separated list of calculation requests, the behavior can be modified using special values for the corresponding column.
TypeResult
sumColumn entries are totaled. The column type must be numeric.
avgColumn entries are totaled and then divided by the number of data rows. The column type must be numeric.
<other text>Any other text including a blank field will be copied to the corresponding total row field. No calculations will be done.
16

rowStyles

 Table row styles

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. A style can be reused for subsequent rows by referring to it using a 1-based numeric reference. Row styles are applied to the table row and participate with other CSS properties to determine the look of an element. In particular, some properties may be overridden by table or element styles or classes.

Example: , background:lightyellow, background:lightblue

17

retainRowStyleOrder

trueRetain row style order after sorting

When selected, the row styles correspond to the order the rows are displayed on the screen. When not selected, the original style given to a row is retained not matter where the row lands after sorting.

18columnStyles Column styles

Comma separated list of styles. Each style is made up of one or more CSS properties (semi-colon separated). The styles are applied to columns in sequence. If a column is skipped, supply a comma before adding the next columns style. A style can be reused for subsequent columns by referring to it using a 1-based numeric reference. Column styles are applied to the table column and participate with other CSS properties to determine the look of an element. In particular, some properties may be overridden by table, row, or element styles or classes.

Example: background:lightyellow, background:lightblue,1,2,1,2

19

columnAttributes

 Column attributesA comma separated list of values used to modify cell attributes for all cells in a column. The position in the comma separated list corresponds to the column that the values apply to. Each value is a double semi-colon list of attributeName=value pairs that will be applied to the column cells.
20

enableHeadingAttributes

trueEnable heading attributesAny column attributes provided will be applied to the all column rows including heading rows. Use false to have the column attributes apply only to data rows.
21

id

auto generatedTable idTable id can be referenced for use in macros (like the chart macro) or javascript.
22

class

@defaultTable classSets the class of the table. Normally, it will be WikiTable. Use a blank (one or more spaces) value to not have any table class.
23

style

 Table styleStyle attributes can be set. For example: font-style:italic; background:lightblue;.
24

width

 Table widthIn pixels or %. Recommend using style settings instead.
25

border

 Table border widthIn pixels. Set class to blank also. Recommend using style settings instead.