Keyfax - Dataview Menu Table [dbm_sub_menuitems]
Database Management Table: [dbm_sub_menuitems]
The dbm_sub_menuitems table contains details on sub menu layouts, content and links. The sub menu will be displayed in the vertical navigation pane at the left of the Dataview page. Selecting a sub menu item will display a record directly into the display area.
The following list represents the table fields (columns) their data-type and brief usage instructions/description:
| Field Name | Data Type | Usage |
|---|---|---|
| SubMenuItemID | int | Unique ID used by the application internally. |
| SubMenuName | nvarchar(50) | Text to display in the sub menu tree. |
| SubMenuID | int | ID matching the dbm_search.SubMenuGroup field: used to specify a group of sub menu items to display when a search menu requests a sub menu to be displayed. |
| MenuCaption | nvarchar(50) | Caption to be displayed in tab header of display grid when sub menu item is selected. |
| MenuOrder | smallint | Order in which to display dbm_sub_menuitems.SubMenuName belonging to a common dbm_sub_menuitems.SubMenuID. |
| MenuIndent | nvarchar(2) | Allows items in a sub menu to be displayed in a grahical tree view structure. Using a combination of '-', 'T', 'I' and 'L' characters will allow these to be replaced with an 'Indent' image as follows:
|
| DisplayStyleID | int | ID of display type (reserved for later use - ignore). |
| DisplayTable | nvarchar(50) | The name of the table to be displayed for the selected action item. |
| DisplayTableID | nvarchar(50) | URL parameter name to assign the Primary Key field value of DisplayTable for using to display record. |
| ReplaceSession | nvarchar(50) | This field contains the name of the URL link parameter to be read by the application to use in search queries. If the menu item uses a DisplaySQL statement then this should be encased in square brackets ([PrimaryKeyField]). If no DisplaySQL statement is specified then the field should be encased in square brackets, then single quotes if the field is a text data type ('[PrimaryKeyField]'). |
| DisplaySQL | ntext | If only certain fields from large information tables are required to be displayed, then this field can be used to specify only those required. See the following example for a table with a Primary Key field with a string datatype: SELECT Field1Name, Field2Name, Field3Name, Field4Name FROM TableName WHERE PrimaryKeyFieldName='[PrimaryKeyFieldName]'; Note: Only fields from a single table (that specified in the DisplayTable field) can be included in this SQL statement. Joined tables cannot be displayed or edited correctly. |
| MacroInstructions | nvarchar(255) | Additional display instructions (reserved for later use - ignore). |
(Blank image)
(T image)
(I image)
(L image)