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 |
| UISelectedItems | NodeId | ||
| Allow deselection | AllowDeselection | Boolean | Allow deselecting elements from the list (no selected items) |
| AllowMultiSelection | 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 |
| 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