rca_saved_search
Stores the saved searches for the user and part of their
preferences. User preferences are stored in the
rca_user_preference
table.
|
Field name
|
Field data type
|
Purpose
|
|
id (PRI)
|
varchar(255)
|
The review identifier.
|
|
name
|
varchar(255)
|
The name of the saved search.
|
|
umOid
|
varchar(255)
|
The object identifier of the user.
|
|
pageSize
|
int(11)
|
The page size for the search results.
|
|
role
|
varchar(255)
|
The value for the role filter attribute.
|
|
customAttrInternal
|
mediumtext
|
The single column where the custom attributes
(key-value) are stored. The field is used when reviews are searched
based on custom attributes.
|
|
statusFilterList
|
varchar(255)
|
The status filter list as comma-separated
values.
|
|
templateName
|
varchar(255)
|
The name of the review template.
|
|
startDate
|
datetime
|
The review start date filter value.
|
|
endDate
|
datetime
|
The review end date filter value.
|
|
keywords
|
varchar(255)
|
The keyword search filter value. Keywords
are searched in review title or review purpose.
|
|
userPreference
|
varchar(255)
|
The foreign key to the rca_user_preference
table.
|
|
filterNo
|
int(11)
|
The index of the filter number saved for
searches. The field is used for internal purposes.
|
