CSO_QUERY

This table contains the stored queries that have been configured in the IM management console for a channel.

Details

Name	Columns
CSO_QUERY_PK	RECORD_ID

Name	Datatype	Length	Not-null	Comments
CONTENT_CHANNEL_ID	VARCHAR2	32	Yes	This is the Reference to content channel record.
DATE_ADDED	TIMESTAMP		Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP		Yes	This is the date that the record was modified.
MATCH_TYPE_ID	VARCHAR2	32		This is the GUID reference to LOOKUP_CODE table that indicates the type of query matching (AND, OR)
QUERY_TYPE_ID	VARCHAR2	32	Yes	This is the GUID reference to LOOKUP_CODE table indicating the type of query. Either document based query, category based or general query.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
SITE_ID	VARCHAR2	32	Yes	This is the GUID reference to the repository that owns the query.
XML	CLOB		Yes	XML formatted data containing the conditions of the query.
REFERENCE_KEY	VARCHAR2	100	Yes	Locale independent name for the record. Translated localized versions of the reference key are stored in property files and in table with names ending in RESOURCe.