Default Project Symbols

Owned by Jose Porto
Last updated: Mar 20, 2023 by Leonardo Porto
3 min read

Usage guide for the symbols included in the default project

 

Symbols

Datagrid_Filter

It is a symbol that can be used on any screen that has a DataGrid window. It is used to insert quick date/time filters and optionally also by level of specific Tags and Tags.

Required settings

Filter by Date / Time

On a screen that has a DataGrid element, simply select from the 'Datagrid_Filter' symbol list and position it in the desired location.

 

 

Next you must open the DataGrid settings by double-clicking on the component, or selecting the 'settings' option on the left side of the screen, and placing the following in the filter field:

Tag.ZZ_System.Filter.SQL.FilterSQL.Value

 

 

Finally, simply open the 'Codes' screen, and put in the method 'DisplayOpening' the following Script:

@Script.Class.ZZS_Filter.StartUp(FILTRO_PADRÃO, DATE_FIELD, TAG_FIELD, LEVEL_FIELD, DB_PROVIDER); Onde: 'FILTRO_PADRÃO' é o valor padrão do filtro do DataGrid, caso ele possua um; 'DATE_FIELD' é o valor para o nome da coluna de Data / Hora do DataGrid a ser filtrado; 'TAG_FIELD' é o valor para o nome da coluna de Tags do DataGrid a ser filtrado; 'LEVEL_FIELD' é o valor para o nome da coluna de Levels do DataGrid a ser filtrado; 'DB_PROVIDER' é o valor do nome do provider do banco de dados, adquirido por '@Dataset.DB.DB_NAME.Provider' (Em que DB_NAME é o nome do banco de dados);

If the value 'string' is passed. Empty' in these arguments, their default values are:

'FILTRO_PADRÃO' - string. Empty;

'DATE_FIELD' - "ActiveTime_Ticks";

'TAG_FIELD' - "TagName";

'LEVEL_FIELD' - "Level";

'DB_PROVIDER' - "SQLITE";

Filter by Tags and Tag Level

On the same screen where the symbol was added, select the 'Assets' component on the side, and configure it by double-clicking the following Tag options:

 

 

SelectedAsset

Tag.ZZ_System.Filter.Assets.SelectedAsset

SelectedLevel

Tag.ZZ_System.Filter.Assets.SelectedLevel

Operation

When there is no active filter, the symbol will have its dates and times opaque and when active its preview will be normal, as seen below:

 

The symbol has two time entries, one date and one time, to filter the start time, and the same for the end time.

 

In addition, it has two buttons, one to apply the filter, which applies both the date/time filter and levels/Tags if being used, and another to clear all filters and keep only the default DataGrid filter value/ show all data if no default filter has been configured.

 

The use of the 'Assets' component has its behavior unchanged, and it is only necessary to select with a mouse click at the desired level or tag, then click the filter button of the symbol to apply the filter.

 

 

On this page: