Data queries¶

Definition of queries for grids of all tables and charts in agent/supervisor application.

Displayed name	AttributeName	Description
ID	DataQueryId	Primary Key
Name	DisplayName	Query display name for administration and selections
Description	Description	Description for administrator needs.
Used data source definition	DataQuerySourceId	Simplified designer mode: Link to data source definition (FROM, column scheme, possible parameters)
Query group	QueryGroup	Possibility to group queries (possibly only some)
Imaging interval	SnapshotInterval	The query validity interval [s] for which data can be processed from memory instead of querying the database. Assumes non-parametric queries.
Time series	TimeLine	Indication of the type of time series to be retrieved from the query. NULL - normal query. LastHour - last hour, LastDay - last day, FallBack Z1, Z2, Z3, … - zone diagram with data reduction.
Validity interval	CacheInterval	Query data validity interval [sec], for which is possible to deliver the data from the cache instead of the database. Used for specific parametric queries, for instance `DQ in the bar`
Sorting	QuerySortExpression	The default sorting section, which will be used after the ORDER BY whenever another sorting is not set.
Manual column filters	ManualFilter	Indication that no column filters should be created automatically.
Query	QueryText	Custom SQL text query. It should be in the form of, for example, SELECT InboundCallId, CallNumber, CallResult FROM CallBuild (CallNumber = CallNumber = CallResult = CallResult)
Log level	LogLevel	Logging detail

Queries columns¶

Table describing the definitions of query columns and their binding to the grid.

Displayed name	AttributeName	Description
ID	DataQueryColumnId	Primary Key.
Query definition	DataQueryId	To which query column definitions belong
Order	Rank	The default order, NULL, indicates that the column is not used by default.
Column width	Width	Default column width if you use it in the query. `NULL` means that the column does not have a predefined width and the global default width is used.
Name	DisplayName	The name of the column as it will be displayed in the grid.
Model	Model	Column and Filter Display Models: Text - only TargetColumn is used and filtering is textbox, @parameter is TargetColumn, .NET formatting by TargetFormat Select - TargetColumn is used, the filter is filtered by text converter named in Convertor, filtering is dwopdown, @parameter is custom value from TargetColumn HyperLink - TargetColumn is used for the displayed value, UrlColumn for reference, filtering is textbox, @parameter is TargetColumn, uppercase is formatted with .NET formatting by TargetFormat, url is compiled by .NET formatting by UrlFormat Image - TargetColumn is used as image name, TargetFormat to get the image URL, filtering is dropdown with images, @parameter is TargetColumn, if the image is to be clickable, UrlColumn and UrlFormat will be filled as in Hyperlink ForeignKey - TargetColumn will be used for the displayed value, GuidColumn for reference to another table, filtration is dropdown of existing dist inct values, @parameter is GuidColumn, if UrlColumn and UrlFormat are used, the link is clickable (as with Hyperlink) DateTimeFromTo - TargetColumn is used, TargetFormat is used as format string, FilterFrom, FilterTo is used as filter, in two @ WeekDay parameters - TargetColumn is used, TargetFormat is used in the format string, days in weeks are generated by the filter, which generates the weekday serial number in seven @TableTime parameters - TargetColumn is used, TargetFormat is the format string, filter is clock ticker from to 0..24, which generates two @parameters of Duration - the TargetColumn is used - this must be an integer type, the way of displaying the duration is governed by the value in Convertor; filter are two fields from-to that generate two @parameters Integer - TargetColumn is used, format string column TargetFormat, filter are two fields from-from which generate two @parameters Bool - use TargetColumn, display checkbox, filter three-state checkbox, generates @parameter according to TargetColumn Color - condition for color line - TargetColumn is column of type bool, if it is used, Color will be used for whole line; the rules apply according to Rank ranking. Convertor selects either the dark (Black) or the white (White) color of the line. Bold - condition for bold, - TargetColumn is a column of type bool, if line is met it will be drawn in bold font.
Target column name	TargetColumn	The name of the column as it is returned from the database. Use by Model.
Target column format	TargetFormat	The .NET formatting string for the value from TargetColumn.
Tooltip lenght	ToolTip	Length of text used for tooltip or tooltip type - interpretation depends on column type.
URL column name	UrlColumn	Column name as returned by a database query that is used, for example, by HyperLink.
URL column format	UrlFormat	The .NET formatting string for the UrlColumn column.
ID column name	GuidColumn	The name of the column as returned by a query from a database that is used, for example, by the ForeignKey model.
Glyf column name	GlyphColumn	The name of the column as it is returned from the database. Usage by Model eg for Bootstrap Glyphicon and FontAwesome
Glyf column format	GlyphFormat	The .NET formatting string for the value from GlyphColumn.
Converter	Convertor	Converter Name.
Literal group	LiteralGroup	For a LiteralLookup converter, a group to use for translation of values.
Sorting part (ASC)	SortExpression	Sorting part after ORDER BY, which will be appended to the query if the column is selected for ascending sorting. NULL means that you cannot sort by column.
Sorting part (DESC)	SortExpressionDesc	Sorting part after ORDER BY, which will be appended to the query if the column is selected for descending sorting. If NULL exists and ascending sorting exists, it is only used with the DESC extension.
Disable filter	NoFilter	An indication that the column should have a filter display.
Colour	Color	Color in # FF7722 format. For the Color model, it is used for highlighting lines, for graphs it is the default color of the series.
CSS	Css	A static style of the cell for the client application (React UI).
Command	SqlCmd	SQL statement for some column types
Sensitivity	GdprSensitivity	Category of personal data sensitivity (bit mask of individual sensitivities according to GdprSensitivity)

Column models¶

Model	Column display and filtering method
Text	only TargetColumn is used and filtering is textbox, @parameter is TargetColumn, .NET formatting by TargetFormat
Select	použije se TargetColumn, zobrazení je přefiltrováno přes konvertor textů s názvem Convertor, filtrace je dropdown, @parametrem je vlastní hodnota z TargetColumn
HyperLink	TargetColumn is used for the displayed value, UrlColumn for the link, filtering is textbox, @parameter is TargetColumn, value is formatted using .NET formatting by UrlFormat
Image	TargetColumn is used as image name, TargetFormat to get image URL, filtering is dropdown with images, @parameter is TargetColumn, if image is to be clickable, UrlColumn and UrlFormat are filled as HyperLink
ForeignKey	TargetColumn is used for displayed value, GuidColumn (ID column) is used for reference to another table, filtering is dropdown of existing DISTINCT values, @parameter of filter is GuidColumn, if UrlColumn and UrlFormat are used, the link is clickable (as in HyperLink)
DateTimeFromTo	TargetColumn is used, TargetFormat is used as format string, intrinsic global values FilterFrom, FilterTo are used as filter, in two @parameters
WeekDay	TargetColumn is used, TargetFormat is used as the format string, the filter is a days-of-week checkbox that generates the serial number of the day of the week in seven @parameters
DayTime	the TargetColumn is used, the format string is the TargetFormat column, the filter is the clock checkbox from .. to (0..24) that generates two @clock parameters
Duration	the TargetColumn is used - it must be of integer type, the way of displaying the duration is controlled by the value in the Convertor; the filter is two from-to fields that generate two @parameters
Integer	TargetColumn is used, TargetFormat column is used as format string, filter is two from-to fields that generate two @parameters
Bool	TargetColumn is used, display checkbox, filter is a three-state checkbox, generates @parameter by TargetColumn
Color	condition for row coloring - TargetColumn is a column of bool type, if it is met, the Color color is applied to the whole row, the rules are applied according to the Rank order; According to the Convertor either dark (Black) or light (White) color of the row font is selected
Bold	condition for bold font - TargetColumn is a column of bool type, if met, the row will be rendered in bold font