Keyfax - Dataview Menu Table [dbm_search_header]
Database Management Table: [dbm_search_header]
The dbm_search_header table contains details on previous search results, and displays menu header to allow 'RE-SEARCH' navigation links. The menu header(s) will be displayed in the vertical navigation pane at the left of the Dataview page over follow up search or sub menus.
The following list represents the table fields (columns) their data-type and brief usage instructions/description:
| Field Name | Data Type | Usage |
|---|---|---|
| SearchHeaderID | int | Unique ID: is used internally and is not updatable from the application. |
| SearchTypeID | int | Displays search header information when current search actiotion = dbm_search.SearchTypeID. |
| HeaderCaption | nvarchar(50) | Text to display as caption over search header value |
| Header_SQL | nvarchar(255) | SQL statement to lookup search header value using WHERE clause passed on specified associated URL parameter value. |
| ReplaceSession | nvarchar(50) | URL parameter value to use in dbm_search_header.Header_SQL statement. This will return the search header value to display. |
| SearchUndo | int | Specifies the search menu to return to (associated to the dbm_search.SearchTypeID field) when the breadcrumb is selected. |
| ReplaceUndo | 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 a previous follow up search action is requred to be returned to. |