iConsole Search Definition Reference Guide › Reference Information › Content Search Result Columns

Content Search Result Columns

This is a list of predefined column names that can be used to define columns in the results of a Content Search; that is, where database="content". .

doc_id

Returns the document ID from the content database. For example:

<column name="doc_id" type="id" hidden="true" />

Required: No

relevance

Returns a confidence level (as a percentage). This indicates how closely the document fits the search criteria, with a higher score indicating a closer fit. For example:

name="relevance"

Required: No

event_uid

Returns the event UID. For example:

name="event_uid"

Required: No

attachment

Returns an icon indicating that the result is an attachment. For example:

name="attachment" 

Required: No

event_type

Returns an icon indicating the event type. For example:

name="event_type" 

Required: No

subject

Returns the event subject. For example:

name="subject"

Required: No

timestamp

Returns the event timestamp. For example:

name="timestamp" 

Required: No

retrieval_ts

Returns the timestamp to be used for event retrieval. Currently, this will be the same as timestamp for an Oracle CMS but zero for a SQL Server CMS as the timestamp resolution is different between the Content Database and SQL Server CMS. For example:

name="retrieval_ts" type="timestamp" hidden="true"

This column should be specified in the results ref attribute, for example:

ref="event_uid,retrieval_ts"

Required: No

participants

Returns a list of all event participants. For example:

name="participants" 

Required: No

sender

The person that sent the email/posted the IM/accessed the web site.

Required: No

recipients

The people who received the email/saw the IM/the URL of the web site.

Required: No