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	Returns the element of the list that is selected at runtime
Allow deselection	AllowDeselection	Boolean	Allow deselecting elements from the list (no selected items)
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
Input box style	InputBoxStyle	String	Style for input controls
DataList style	DataListStyle	String	Style for data lists
ScrollBar style	ScrollBarStyle	String	Style for scrollbars
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

Refresh the displayed data

Events

User selection changed

BrowseName: User selection changed

Event that is triggered when the user changes the current value or status of the control

Object and variable references

Provide Feedback

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