Table Description
The Smart Navigator Search History records an item that the user clicked on in the Smart Navigator. This is persisted to the database.
Model Details
Location in Model: Logical View::MetaModel::Curam::SmartNavigator::SmartNavigator::Facade::SmartNavigatorSearchHistory
Controlling File: SmartNavigator\model\SmartNavigator.emx
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
targetDescriptiondetails  SN_SEARCH_TARGET_DESCRIPTION SVR_STRING<255>
targetTypedetails  SN_SEARCH_TARGET_TYPE SVR_STRING<255>
targetValuedetails  SN_SEARCH_TARGET_VALUE SVR_STRING<255>
idkeyno SN_SEARCH_HISTORY_ID SVR_INT64
searchConcernRoleIddetails  CONCERN_ROLE_ID SVR_INT64
searchDatedetails  SN_SEARCH_HISTORY_DATETIME SVR_DATETIME
urldetails  SN_SEARCH_MATCH_URL SVR_STRING<2000>
usernamedetails  SN_SEARCH_HISTORY_USERNAME SVR_STRING<64>
preferredTabsdetails  SN_SEARCH_MATCH_PREFERRED_TABS SVR_STRING<255>
isModaldetails  SN_SEARCH_IS_MODAL SVR_BOOLEAN
Indices (3)
Index NameAttributes
searchHistoryUsernameIdxusername
IND__1583372961targetValue
IND_1209672232searchConcernRoleId
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: id
AUTO_ID_KEY: SMARTNAV
Inserts a new user search into the history. 
searchByUsernamensmultiREADMULTI_INFORMATIONAL: no
READMULTI_LIM: 6
 		Search the user search historySQL
removeUserHistorynsremove   
removeremove Delete record identified by the generated key 
searchByTargetValuensreadmulti   
searchByConcernRoleIdnsreadmulti   
searchByConcernRoleIdAndTargetValuensreadmulti   
Related Pages (0)