Data grid

Table that presents data obtained from project nodes or from one or more database tables.

BrowseName: DataGrid
SuperType: Element(Item)

Properties

Name	BrowseName	DataType	Description
Model	Model	NodeId	Reference to the information model or database from which to obtain the data.
Query	Query	String	Standard SQL query to filter the data of interest. You can use it to filter data from a database and to filter data obtained from a node-based model. In case of a node-based model, the SELECT * FROM Model part is mandatory, followed by the WHERE clause with which to indicate the search conditions - for example: SELECT * FROM Model WHERE Speed > 40
Auto refresh time	AutoRefreshTime	Duration	The Refresh method is invoked periodically with a waiting interval equal to the specified value (0 = auto refresh disabled).
Selected item	SelectedItem	NodeId	Element selected when the object is initialized at runtime (if empty, it is initialized without selections). After initialization, this property displays the node corresponding to the selected element (access to the property is both read and write when the data are obtained from project nodes, read-only when obtained from a database).
UI selected item	UISelectedItem	NodeId
Allow deselection	AllowDeselection	Boolean
Sort column	SortColumn	NodeId	Default sort column.
Sort order	SortOrder	Sorting	Default sort order, ascending or descending, of the elements.
Row color	RowBackgroundColor	Color	Row fill color.
Row text color	RowTextColor	Color	Color applied to the text elements contained in the row.
Columns	Columns	Data grid column	Column to display in a Data grid object.
ViewModels	ViewModels	Object
Visible	Visible	Boolean	(Inherited from Element)
Enabled	Enabled	Boolean	(Inherited from Element)
Opacity	Opacity	Float	(Inherited from Element)
Left margin	LeftMargin	Size	(Inherited from Element)
Top margin	TopMargin	Size	(Inherited from Element)
Right margin	RightMargin	Size	(Inherited from Element)
Bottom margin	BottomMargin	Size	(Inherited from Element)
Width	Width	Size	(Inherited from Element)
Height	Height	Size	(Inherited from Element)
Horizontal alignment	HorizontalAlignment	Horizontal alignment	(Inherited from Element)
Vertical alignment	VerticalAlignment	Vertical alignment	(Inherited from Element)
Rotation	Rotation	Size	(Inherited from Element)

Methods

Refresh

BrowseName: Refresh

Events

Selection changed

BrowseName: Selection changed

Object and variable references

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.