Keyfax - Dataview Menu Table [dbm_search]
Database Management Table: [dbm_search]
The dbm_search table contains details on search menu layouts, content and links. The Search menu will be displayed in the vertical navigation pane at the left of the Dataview page. During a search, selecting an item, will display one of the following: another search menu, a sub menu (tree view style) or records 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 |
|---|---|---|
| SearchTypeID | int | ID matching the dbm_top_menu.SearchType field: used to identify a search menu display when the top menu or precceeding search is selected. |
| SearchTypeName | nvarchar(50) | Description of search action for selecting in dbm_top_menu.SearchType lookup dropdown list. |
| DisplayTypeID | int | ID matching the dbm_display_types.DisplayType field: used to specify the type of list to display the matching search items (Table, Dropdown Listbox or Standard Listbox). |
| Caption | nvarchar(50) | Caption to be displayed over search menu list. |
| InfoText | ntext | Information instructions for search menu, displayed in body of page. This can contain HTML tags, to override default Cascading Style Sheet Attributes. (Note If the dbm_search.InfoFile is specified then the file contents will be displayed in place of this data. |
| InfoFile | nvarchar(255) | HTML file wih information instructions for search menu displayed in body of page. If this file is not present then the dbm_search.InfoText data will be displayed instead. |
| ListFill_SQL | ntext | Contains the SQL SELECT statement used to populate the Selection list. This statement should contain 2 fields, the Primary Key, and a description. The Primary Key will be used in a URL link parameter to use in displaying subsequent searches or data. |
| ReplaceSession | nvarchar(50) | This field contains the name of the URL link parameter to be read by the application to use in search queries. This field is only required if follow up search action is requred or a sub menu is being requested. |
| ListFill_ID | nvarchar(50) | Contains the URL link parameter name to use to pass the dbm_search.ListFill_SQL Primary Key value to following pages. This is not required if a sub menu is being requested. |
| SearchAction | int | Indicates that a follow up search action is required. This allows the application to perform another search, based on the passed dbm_search.ListFill_ID. This field must match a corresponding dbm_search.SearchTypeID |
| SubMenuGroup | int | Indicates that a sub menu group is to be dispalyed. The application uses the passed dbm_search.ReplaceSession to display a sub menu. This field must match at least one corresponding record in the dbm_sub_menuitems table with an associated SubMenuID. |
| DisplayAction | int | Indicates that the selected search should display a record in the display area of the Dataview page. The application uses the passed dbm_search.ListFill_ID to display the data. This field must match a corresponding record in the dbm_search_displayitems table with an associated DisplayActionID. |