Perspective - Table

Description

The Table component provides a powerful and flexible means of displaying your database data in tabular form. Properties enable you to customize the data content, style, navigation, and user interaction of your table.

Properties

Most Properties have binding options. For more information on Bindings, see Types of Bindings in Perspective.
This section only documents the Props Category of properties. The other Categories are described on the Perspective Component Properties page.

Name

Description

Property Type

data

Can be a dataset, an array of arrays, or an array of objects. The preferred (recommended) data is either a dataset or an array of objects. Individual data items can be a string, a number, or an object with reserved keys.

Click to see Object data item specifics

Object data items must have a value property. Optionally they can also have properties to indicate the style for the object and whether it is editable.

city: {
  value: 'Folsom',
  editable: true,
  style: {
    backgroundColor: 'grey',
    classes: [] | ''
  }
}

array

virtualized

Enables virtualization of table rows. Meaning only the rows needed at any given time are displayed on the screen.

value: boolean

selection

When Selection is configured, a user will be able to select table data based upon the table's selection configuration. Similar to Vision module, you can select single, single interval, and multiple interval selection modes. The current selection and selection data is written back to the table components property tree. With the exception of the selection data property, the selection properties are bidirectional, meaning that if you were to change the value of the selected column property, it should be reflected in the table component.

Click to see the selection properties

Name	Description	Property Type
mode	This option determines if only one row, cell, or column can be selected at once. Options are single, single interval, and multiple interval.	value: string dropdown
enableRowSelection	This option is used in conjunction with the Column Selection allowed flag in order to determine whether whole rows, whole columns, or both (single cells) are selectable. Can be set to true or false. Default is true.	value: boolean
enableColumnSelection	This option is used in conjunction with the Row Selection allowed flag in order to determine whether whole rows, whole columns, or both (single cells) are selectable . Can be set to true or false. Default is false.	value: boolean
selectedColumn	The index of the first selected column, or null if none.	value: numeric
selectedRow	The index of the first selected row, or null if none.	value: numeric
data	An array of objects representing the current selection.	array

object

enableFiltering

This feature was removed from Ignition in version 8.0.2

When enabled, a filtering component will be displayed above the table heading. As a user enters text into the filter, the table will update dynamically to display only rows that contain the search text. Replaced by the filter property.

value: boolean

filter

This feature is new in Ignition version 8.0.2
Click here to check out the other new features

Where Table filtering is configured, as well as the filtered data.

Click to see the filter properties

Name

Description

Property Type

enabled

Enables filtering. Default is false.

value: boolean

text

Contains the text you want to filter on.

value: string

results

The filtered data.

Click to see the results properties

Name	Description	Property Type
enabled	Enables the filter results to be written back to the props. Doing so may cause performance decline. Default is false.	value: boolean
data	An array of objects representing the current filtered data if filtering is enabled. Each object represents a row of the table.	array

object

enableHeader

When enabled, the table header is displayed including the main table header along with the Header Groups. Default is true.

value: boolean

enableFooter

When selected, this enables the table footer, including the main table footer along with the Footer Groups. Default is false.

value: boolean

enableHeaderGroups

Enable table header groups if available. Default is false.

value: boolean

enableFooterGroups

Enable table footer groups if available. Default is false.

value: boolean

headerGroups

Header Groups are additional headers that are displayed above the main table header. Each header group equates to a single row with individual cells containing title text.

Click to see the headerGroups properties

Name	Description	Property Type
title	Text displayed in the header.	value: string
span	You can use the span property to instruct individual cells to span multiple columns of the table. However, header group cells cannot span more than the available columns. If you specify more columns in the span property than are actually available in the table, the cell will only span the remaining space.	value: numeric
justify	Justify content horizontally. Options are left, right, and center.	value: string dropdown
align	Aligns the content vertically. Options are top, center, or bottom.	value: string dropdown
style	Sets a style that applies to header. Full menu of style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.	object

object

footerGroups

Footer Groups are additional footers that display above the main table footer. Each footer group equates to a single row which consists of individual cells containing title text.

Click to see the footerGroups properties

Name	Description	Property Type
title	Text displayed in the footer group.	value: string
span	You can use the span property to instruct individual cells to span multiple columns of the table. However, footer group cells cannot span more than the available columns. If you specify more columns in the span property than are actually available in the table, the cell will only span the remaining space.	value: numeric
justify	Justify content horizontally. Options are left, right, and center.	value: string dropdown
align	Aligns the content vertically. Options are top, center, or bottom.	value: string
style	Sets a style that applies to footer. Full menu of style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.	object

object

columns

The Columns property allows for granular column-by-column configurations, indicating how each column should be displayed in the table. When a Column Config option is present, the table reflects that custom configuration. When empty, the table component displays all available columns.

Column configs enable the you to customize the table component's display and how users will be able to interact with the table in the runtime.

A single cell of a Table component can be a whole view instead of just a simple value (like a string).

Click to see the columns properties

Name

Description

Property Type

field

A string that matches this column config with a table column. This string must correspond to the default column name of the column.

value: string

visible

This feature is new in Ignition version 8.0.5
Click here to check out the other new features

Toggles column visibility. Allows table columns to be invisible to users, but data will be available to view params and selection.

value: boolean

editable

Enables editing of all cells within this column. This can be overridden if the Editable property is set to false on an individual cell.

value: boolean

render

The default render setting is auto. Can be auto, number, date, boolean, string, or view.

value: string dropdown

justify

Sets the justification for the content of the column. Options are left, center, right, or auto. The default setting is auto.

value: string dropdown

align

Sets the alignment for the content of the column. Options are top, center, or bottom. The default alignment is center.

value: string dropdown

resizable

Enables columns to be resized. When enabled, users can resize columns in the runtime by hovering over the edge of the column header then dragging the

cursor.

value: boolean

sortable

Enables the column to be sorted. When enabled, users can double click on the column header in the run time to sort by ascending or descending order.

value: boolean

viewPath

When render mode is set to View, the table will display the view found at the view path within each cell of this column.

value: string dropdown

viewParams

Parameters to feed the configured view. Will be added to implicit parameters as follows: {row:number;rowIndex:number;value:PlainObject;...viewParams}

object

boolean

When render mode is set to Boolean, you can then specify how the boolean is represented in the runtime, for example, as a checkbox, toggle switch, value, and so forth. See Toggle Switch below.

value: string dropdown

number

Type of component to render for boolean. Options are number or progress. When render mode is set to Number, you can then specify whether the number is represented in the runtime as value or as progress.

value: string dropdown

progressBar

A progress bar configuration that is used when Number property is set to progress bar. You can specify the maximum value of the progress bar, as well as configure the following:

Name

Description

Property Type

max

Progress bar maximum value.

value: numeric

bar

Settings for the bar.

Name	Description	Property Type
color	Color of the bar and the track. See Color Selector.	color
width	Width of the bar and the track.	value: numeric
linecap	Linecap shape of the bar and the track (round, square, or butt).	value: string dropdown

object

track

Settings for the track.

Name	Description	Property Type
color	Color of the bar and the track. See Color Selector.	color
width	Width of the bar and the track.	value: numeric
linecap	Linecap shape of the bar and the track (round, square, or butt).	value: string dropdown

object

value

Settings for the value.

Name	Description	Property Type
show	Whether or not to show the value.	value: boolean
color	Color of the bar and the track. See Color Selector.	color

object

toggleSwitch

Toggle switch configuration used when boolean is set to display as a toggle switch. Can specify selected and unselected color.

Name	Description	Property Type
color.selected	Color when the toggle switch is selected. See Color Selector.	color
color.unselected	Color when the toggle switch is not selected. See Color Selector.	color

value: boolean

numberFormat

A number format string when render mode is set to number. Options are none, number [1,000.12], integer [1,200], four decimal precision [1.1200], percent [10.12%], scientific [1.01E+03], accounting [$(1,000.12)], financial [(1,000.12)], currency [$1,000.12], currency (rounded) [$1,012], duration [24:01:00], abbreviation [1.2k], or ordinal [100th].

value: string dropdown

dateFormat

Date format string used when render mode is set to date. Options are none, date [10/15/1018], time [3:59:00 PM], or date time [10/15/2018 15:59:00]

value: string dropdown

width

The width of this column. If resize is enabled, specifies the column width on initial load. User can override this in the runtime if the Resizable option is enabled.

value: numeric

strictWidth

If enabled, the width of the column becomes fixed.

value: boolean

style

Sets a style for this individual column. Full menu Iof style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.

object

header

Header cell configuration.

Name	Description	Property Type
title	Text for title of the column.	value: string
justify	Setting for justification of the title. Options are right, left, and center.	value: string dropdown
align	Setting for alignment of the title. Options are top, center, and bottom.	value: string dropdown
style	Sets a style for this header. Full menu of style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.	object

value: object

footer

Footer cell configuration.

Name	Description	Property Type
title	Text for title of the footer.	value: string
justify	Setting for justification of the title. Options are right, left, and center.	value: string dropdown
align	Setting for alignment of the title. Options are top, center, and bottom.	value: string dropdown
style	Sets a style for this footer. Full menu of style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.	object

value: string

This feature is new in Ignition version 8.0.2
Click here to check out the other new features

Implicit Properties

rowData

Used to map parameters on a view cell to an entire row of data. The view must have a rowData object input parameter, with sub values that match the names of the columns. Then add the new view to the props.columns.0.viewPath property, and the input parameter as the props.columns.0.field property.

value: string

value: array

rows

Configures all rows in the table component.

Click to see the rows properties

Name

Description

Property Type

subviewExpansionMode

This feature is new in Ignition version 8.0.10
Click here to check out the other new features

Specifies how many subviews can be expanded at any given time. Options are multiple or single. Default is multiple.

value: dropdown list

subview

When enabled, each table row can be expanded into a subview. The Expandable Arrow opens the subview. Content of the subview is determined by the View Path property.

Name	Description	Property Type
enabled	Enable each row to allow toggling of the specified view.	value: boolean


viewPath	A viewpath used to display a view as an expanded row	value: string dropdown
viewParams	Parameters to feed the configured view. Will be added to implicit parameters as follows: {row:number;rowIndex:number;value:PlainObject;...viewParams}	object

object

striped

Settings for setting the striping (alternating background color) to the rows of the table.

Name

Description

Property Type

enabled

When enabled (true), the table will be displayed with alternating background color to the rows of the table.

value: boolean

color

Color settings

Name	Description	Property Type
even	Background color for the even rows. See Color Selector.	color
odd	Background color for the odd rows. See Color Selector.	color

object

highlight

Highlight settings.

Name	Description	Property Type
enabled	When enabled (true), this feature will highlight the row that is currently selected or moused over.	value: boolean
color	Highlight color for the row. See Color Selector.	color

object

style

Sets a style that applies to every row in the table. Full menu of style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.

object

cells

Configures all cells in the table component.

Click to see the cells properties.

Name	Description	Property Type
allowEditOn	Enables the table cells to be edited on a single click, double click, or long press.	value: string dropdown
style	Sets a style that applies to every cell in the table. Full menu of style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.	object

object

pager

Enables table pagination. Pagination improves performance and appearance on large tables, over 1000 rows.

Click to see the Pager properties.

Name	Description	Property Type
options	Rows to show per pager option.	array
initialOption	Initial option to use when the table first loads. Must exist as an available option.	value: numeric
top	Enables top pager. The pager is a menu that displays the current page and Previous and Next icons for navigation.	value: boolean
bottom	Enables bottom pager. The pager is a menu that displays the current page and Previous and Next icons for navigation.	value: boolean
activePage	Represents the current active page and corresponds to the value of the page jump input field.	value: numeric

resizeMode

Specifies whether the table resize mode is either Fill or Fixed. In Fill resized mode, the total width of all the columns cannot be less than the width of the table. In Fixed resized mode, the total width of all the columns can be less than the width of the table.

value: boolean

style

Sets a style that applies to the component. Full menu of style options is available for text, background, margin and padding, border, shape and miscellaneous. You can also specify a style class.

object

User Interaction

The Table component properties have impact on the way a user can interact with a table in the runtime.

Interaction	Description
Column Resizing	When configured through the designer via the corresponding column config, a column can be resized during runtime. The resize handle exists in a 36px swath centered on the end of the header cell. Hovering over this area will change the mouse cursor to column resizing. Dragging the resize handle will display a resize guide effectively providing a visual for the new column position as the user drags. These changes in width will not persist, and are merely for the convenience of the user.
Sorting	When sorting is enabled on a column and the table head is enabled, a sort indicator will display to the right of the header cell content. The sort indicator will display the sort direction. Single Sort - Enabled by double clicking on a header cell. Multi Sort - Enabled by holding down Shift then double-clicking on multiple header cells.
Selection	When selection is enabled, a user may select table data based upon the table's selection configuration. In the browser, selection is indicated by a light blue overlay rendered on cells. The root selection, or most recently selected cell has a light blue border. The root selection corresponds with the selected column and selected row propertiess of the table component's selection configuration. Single - Single mouse click enabled. Single Interval - Shift and single mouse click enabled. Multiple Interval - Command/Ctrl + shift and single mouse click enabled.
Editing	When editing is enabled on an individual cell, a user can edit a cell by performing the interaction specified by the 'allow edit on' property of the table component. When in edit mode, an editing cell with the corresponding cells content will be presented for edit. To commit this edit, the user must press the return or enter key. To exit the edit, the user may either press the escape key or select another table cell. When an edit is committed, the edited data is sent to the cell edit extension function of the table component
Paging	When paging is enabled, a user may use the provided buttons to navigate between available pages and also jump to a specific page within range.
Filtering	When filtering is enabled, a user may filter all of the data, not just the data being displayed when pagers are enabled, of the table component. If paging also happens to be enabled, the table will automatically page jump if it becomes necessary so that it does not display an empty page.
Freeze a Column	If the table head property is enabled, a user can freeze a column by holding down Alt and double clicking the column header. This action "freezes" the column within the bounds of the table so that the user may scroll to perform data comparisons. To unfreeze a column, hold down Alt and double click on the column header of the frozen column or of the source column. A frozen column can be dragged horizontally within the bounds of the table by selecting and dragging with the mouse. It is possible to freeze as many columns as a user may like. The user is not confined to freezing columns that are only visible when at scroll start position.
Freeze a Row	A user may freeze an individual row by holding down 'alt' and double clicking on the desired row within the table body. This will fix the table row within the bounds of the table. To unfreeze, perform the same operation on either the frozen row or the source row. A frozen row can be dragged vertically within the bounds of the table by selecting and dragging with the mouse. The user is not confined to freezing rows that are only visible when at scroll start position.

Perspective Component Events

The Perspective Event Types Reference page describes all the possible component event types for Perspective components. Not all component events support each Perspective component. The Perspective Events and Actions page shows how to configure events and actions on a Perspective component. Component scripting is handled separately and can be accessed from the Component menubar or by right clicking on the component.

Component Events

onEditCellCommit

This onEditCellCommit event is used with a runAction script on a table to take user entry and store it in the table or a database.

Provides a chance do something once a user has typed something into a cell. The user must commit the new value (generally achieved by pressing the Enter/Return key) before the event will trigger.

Additionally, the cell must first be editable (props.data.[rowNumber].[columnName].editable is set to true). The first cell in the default dataset on a newly created instance of the component demonstrates where the editable property must be positioned.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.column

Object Path

event.column

Type

String

Description

The name of the column under which the cell was edited.

event.row

Object Path

event.row

Type

Number

Description

The row index number (zero based) of the cell that was edited.

event.value

Object Path

event.value

Type

Any

Description

The value that was typed into the cell.

Example - Change the value in a cell

    # This example will set the value of a cell, based on what the user typed into it.
    
	# Get the value that was typed into the cell
	valueToSet = event.value
	
	# We need to set a value in a particular cell. The event object contains row and column properties
	#  that report the position of the cell that was edited.
	self.props.data[event.row][event.column] = valueToSet

This feature is new in Ignition version 8.0.3
Click here to check out the other new features

onSelectionChange

This onSelectionChange event will trigger when the selection in the chart changes.

The onSelectionChange event will fire on startup or mount if props do not equal the table components default selection config.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.selectedColumn

Object Path

event.selectedColumn

Type

String or null

Description

The name of the column that the selected cell is located under.

event.selectedRow

Object Path

event.selectedRow

Type

Number or null

Description

The row index of the selected row (zero based)

event.data

Object Path

event.data

Type

Array

Description

Represents the currently selected entries. The contents of the array is based on the enabledRowSelection and enableColumnSelection properties as represented on the table below. Note that the actual resulting value may include additional values if the selection mode on the table is set to "single interval" or "multiple interval".

enabledRowSelection

enableColumnSelection

Resulting return type

Example Output

True

False

An array containing a number of JSON objects that each represent a single row.

Each JSON object contains one key-value pair for each column on the table.

[{"city":"Folsom","country":"United States", "population":77271}]

False

True

An array of JSON objects, where each object represents a separate row in the selected column.

Each object contains a single key-value pair, where the key is the column name and the value is the value of the cell.

[{"city":"Folsom"}, {"city":"Helsinki"},
{"city":"Jakarta"},]

True

An array containing a single JSON object, which can be treated like a Python dictionary.

[{"city":"Folsom"}]

onEditCellStart

This onEditCellStart event fires when the user starts editing a cell.

For onEditCellStart , the value is the initial value before any edits.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.column

Object Path

event.column

Type

String or number

Description

The column the editing cell is positioned under.

event.row

Object Path

event.row

Type

Number

Description

The row index of the selected row (zero based).

event.rowIndex

Object Path

event.rowIndex

Type

Number

Description

The row index as it is represented in the current visible data. Useful in cases where some of the rows are hidden, such as when filtering.

event.value

Object Path

event.value

Type

Any

Description

The value of the cell before editing began.

onEditCellCancel

This onEditCellCancel event is fired when the user has canceled a cell edit and has exited editing mode by effectively pressing the escape key.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.column

Object Path

event.column

Type

String

Description

The column name of the cell being edited.

event.row

Object Path

event.row

Type

Number

Description

The row index of the selected row (zero based).

event.rowIndex

Object Path

event.rowIndex

Type

Number

Description

The row index as it is represented in the current visible data. Useful in cases where some of the rows are hidden, such as when filtering.

event.value

Object Path

event.value

Type

Any

Description

The value of the cell before editing began.

onRowClick

This onRowClick event is fired when a row in the table is clicked.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.row

Object Path

event.row

Type

Number

Description

The row index of the selected row (zero based).

event.rowIndex

Object Path

event.rowIndex

Type

Number

Description

The row index as it is represented in the current visible data. Useful in cases where some of the rows are hidden, such as when filtering.

event.value

Object Path

event.value

Type

PlainObject

Description

The rows value as a JSON object.

onRowDoubleClick

This onRowDoubleClick event is triggered when a row in the table is double clicked.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.row

Object Path

event.row

Type

Number

Description

The row index of the selected row (zero based).

event.rowIndex

Object Path

event.rowIndex

Type

Number

Description

The row index as it is represented in the current visible data. Useful in cases where some of the rows are hidden, such as when filtering.

event.value

Object Path

event.value

Type

PlainObject

Description

The rows value as a JSON object.

onSubviewExpand

This onSubviewExpand event is triggered when a row subview is expanded.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.row

Object Path

event.row

Type

Number

Description

The row index of the selected row (zero based).

event.rowIndex

Object Path

event.rowIndex

Type

Number

Description

The row index as it is represented in the current visible data. Useful in cases where some of the rows are hidden, such as when filtering.

event.value

Object Path

event.value

Type

PlainObject

Description

The rows value as a JSON object.

onSubviewCollapse

This onSubviewCollapse event is triggered when a row subview is collapsed.

This component event is designed to be used in tandem with a script runAction. Within the script action, special properties and methods are available on the event object, which is passed to the script action as a parameter.

event.row

Object Path

event.row

Type

Number

Description

The row index of the selected row (zero based).

event.rowIndex

Object Path

event.rowIndex

Type

Number

Description

The row index as it is represented in the current visible data. Useful in cases where some of the rows are hidden, such as when filtering.

event.value

Object Path

event.value

Type

PlainObject

Description

The rows value as a JSON object.

Examples

To see an example of nesting sub-views into a table, see Displaying a SubView in a Table.

Example

Property	Value	Style Category
props.enableFiltering	true	N/A
props.pager.initialOption	10	N/A
props.style.borderStyle	double	border
props.style.borderColor	#00ACAC	border
props.style.fontVariant	small-caps	text

User Manual

GETTING STARTED

MODULES AND PLATFORM

APPENDIX

TUTORIALS & HELPFUL TRICKS

GLOSSARY

STRATEGIC PARTNER LINKS

RESOURCES

ALL MANUAL VERSIONS