The dbm_display_properties table contains details on the display style for each of the information columns to be displayed in the right-hand pane of the Dataview page.
The following list represents the table fields (columns) their data-type and brief usage instructions/description:
Field Name
Data Type
Usage
Table_Name
nvarchar(50)
Name of table in database for which columns properties are specified.
Column_Name
nvarchar(50)
Name of column in Table_Name, for which formatting properties are held.
Description
nvarchar(255)
Formatting properties for data to be displayed/edited.
The properties are held in a text string, delimited by pipe characters ('|').
Most columns have 4 parameters, except Combo fileds, which have 8:
The visibility of the column:
Hidden
Visible
Confidential - Level 1 i.e. item is displayed to all users with a pink background denoting that data should not be disclosed to callers
Confidential - Level 2 i.e. items are displayed with a pink background to supervisors only
The Caption to display for the Column
The editing status of the colum:
H = Hidden
E = Editable
The type of HTML control to display:
LABEL - (will not be editable)
INPUT - (single line data)
TEXTAREA - (multiple line data)
IMAGE - (display image held in schemeimages sub folder)
RADIO - (Yes / No - will be displayed if 1 or 0 is used)
COMBO - (drop-down selection box populated with relational data - see 5 to 8)
URL - (hyperlink - do not prefix with "http://")
MAILTO - (hyperlink to email address)
SQL Query to populate drop-down list: [Only if HTML control type = 'COMBO'] i.e. 'SELECT OfficeID, Name FROM info_office'
Primary key of foreign table: [Only if HTML control type = 'COMBO'] i.e. 'OfficeID'
Data Type of Primary Key:
S - String (Datatype is varchar, nvarchrar, text or ntext)
N - Numeric (Datatype is int, smallint or tinyint)
Sort order for drop-down list: [Only if HTML control type = 'COMBO'] i.e. 'ORDER BY Name'
Examples:
Data in table info_eho, column Email to be displayed as an Email Mailto link:
Data in table info_eho, column LAID to be displayed with related data from table info_localauthority, column Name (the Primary Key is a string data type):
Table_Name: info_eho Column_Name: LAID Description: 1|Local Authority|R|Combo|SELECT LAID, Name FROM info_localauthority|LAID|S|ORDER BY Name
