Documentation

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

Portal Search History

Details

Table ID: h_sm_portal_search_history

Contains details of search terms used in the various portals, the data drives the autocomplete, honours Service subscriptions and can be reported on to determine common search terms to help better improve your Service offering

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Language
h_language
The Language that the search term was performed in
Type VARCHAR
Size 25
Nullable true
Search Term
h_search_term
The search term
Type VARCHAR
Size 255
Nullable true
Search term ID
h_id
The unique ID for the search term
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
Service ID
h_service_id
The first service that was chosen after performing the search
Type INTEGER
Nullable true
Indexed true
In This Document