Open topic with navigation

USERSETTINGSSEARCHLISTTASKHISTORY (4.0SP15)

no changes

Top
Primary Key
Foreign Key Fields
Fields
Indexes

Contains information about a user's search list task history per user.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
SEARCHLISTCATALOGID	uniqueidentifier	false	SEARCHLISTCATALOG.ID	The ID of the search list.
TASKCATALOGID	uniqueidentifier	false	TASKCATALOG.ID	The ID of the task that invoked the search list.
APPUSERID	uniqueidentifier	false	APPUSER.ID	The ID of the app user to which the settings belong.

Fields
Field	Field Type	Null	Notes	Description
PARAMETERS	xml	true		The data list's parameters from the user's last session.
DATECHANGED	datetime	false		The date the search list task parameters were last updated.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
PK_USERSETTINGSSEARCHLISTTASKHISTORY	ID	True	True	True
UIX_USERSETTINGSSEARCHLISTTASKHISTORY_APPUSERID_SEARCHLISTCATALOGID_TASKCATALOGID	APPUSERID SEARCHLISTCATALOGID TASKCATALOGID	True	False	False