Console Tables
This information applies to Console version 1.17.70.101.
The console tables are for internal use in the console program. Access to the tables is made directly from the console program. They contain all site & machine depended information needed for console, including configuration of the individual console pages.
Press this symbol to go to back to the index below.
The following database tables is used for the console program:
References:
SQL script for the console tables.
Console Views - a description on how the console page is build.
The tables and their relationships:
This table contains information on the parameters on each console page. This information is used when building the console page.
IdintegerUnique index
Namevarchar 20Unique short name.
Descriptionvarchar 80description string, all-round purpose
UserNamevarchar 50Name of the user who created the page, empty for system pages
ButtonintegerIndex of the toolbar button associated with the page in the
console resource. -1 if no button. See bitmap numbers below.
Param1..Param29 varchar 20Names of the parameters on this page. Can also include display
options.
DisplayGroupintegerThe display group in which the page belongs
GraphPageintegerIndex of graphic view associated with this page - if any.
Parameter definitions:
Syntax:
<Parameter name>[.<sur name>][;<Options>]
If a parameter is defined without surname, all sub items for the parameter is displayed in the console. If a surname is displayed only the device for that surname is displayed.
Options:
H: Highlight, display item in highlighted color
C: Header, the text before the semicolon specifies the header text to display
W<link number>: The text before the semicolon will work as and be displayed an web link. The web link is specified as an integer link number that must follow the W option. The link must be defined in the ‘WebLink’ table in the SQL database. (ConSysWeb=0 – use relative web path in the ConSys web. ConSysWeb=1: Use full web path).
Posibilities for selection of parameters in the list view - remark only one method alowed for each parameter selection:
List of surNames to include:
Syntax:
<ParameterName>.<SurName>[.<SurName>][.<SurName>]
(Number of surnames only limited by selection string name)
ex:
IFA901IPStst.Iw.Ir.SumFail
Console position range:
<ParameterName> < <position> > <position>
ex:
IFA902IPStst>51<56
Console position less than:
<ParameterName> < <position>
ex:
VPS110CTRast2<3
Console position greather than:
<ParameterName> > <position>
ex:
VPS110CTRast2>1000
SQL condition:
<ParameterName>&<Any SQL condition on the viewRequestSet>
ex:
IFASUPCTRtst&a8 = 1
The (otherwise unused general attribute for this parameter) a8 used as selection filter, Parameters to include in the listview is marked by setting a8 to 8 in the database in the example above.
Page selection button numbers:
0 - 9
10 - 19
20 - 29
30 - 39
40 - 49
50 - 59
60 - 69
70 - 79
80-89
90-98
Define the groups of console pages shown in the group select toolbar.
IdintegerUnique index
Namevarchar 20Unique short name.
Descriptionvarchar 80description string, all-round purpose
UserNamevarchar 50Name of the user who created the group, empty for system
groups
ButtonintegerIndex of the toolbar button associated with the group in the
console resource. -1 if no button. See bitmap numbers below.
Page1..Page30varchar 25Names of the console pages from ConsolePages in the group.
DisplayGroupintegerThe display group in which the page belongs
Group selection button numbers:
0 - 9
10 -19
20 - 29
30-36
Define the categories of console pages. (The name table name DisplayGroup is historical - should have been DisplayCategory.)
DisplayGroupIdintegerUnique category index
Namevarchar 255Unique short name.
TypeIdintegercategory type id
Category types:
0: System
category. General control system pages/groups.
1: Single
user category. Used for personal console pages/groups.
2: Group
category. Used for special console pages for a group of people.
3: Test
category. Used for test pages/groups.
Table defining the graphic view pages.
IdintegerUnique category index
Descriptionvarchar 255Description string
Bitmapvarchar 255Full path filename for the background bitmap
GraphControlIdinteger
This table is used to store the informations for the parameters on the graphic view. Each record in the table defines a parameter on a graphic console page. This table is updated from the console itself.
IdintegerUnique index
SelectionNamevarchar 50Parameter name
SelectionSurNamevarchar 10Parameter surname
PageintegerThe page number on which the parameter is defined - relates to the
GraphicPage|GraphControlId.
xPosintegerx position, upper left corner.
YPosintegery position, upper left corner.
Optionsintegerbit mask options - parameter dependent use
Headervarchar 30Optional text to be displayed with the parameter
I0-I5integerGeneral purpose fields - use dependent of parameter type.
BgColorintegerThe RGB color value for the background
TextColorintegerThe RGB color for the parameter text.
Last Modified 11 January 2019