Diary fields
Diary fields capture the history of a request over time. Whenever users enter comments in the diary field, the new entry is appended to the previous diary entries. Every diary entry is stamped by the BMC Remedy AR System server with a time and a user name. After they are saved, diary entries cannot be modified.
By default, BMC Remedy AR System inserts a diary expand button to the right of each diary field. Users can click the button to open a Diary Editor dialog box. When the diary field contains entries, the icon changes from a blank book to an image of a book containing text.
A diary field displays whole words only. To see the text beyond the words displayed in the field, open the Diary Editor dialog box.
The default maximum size limit of data contained in diary fields varies per database:
- For Microsoft SQL Server databases, 2 GB
- For Oracle databases, 4 GB
To search a diary field when using Oracle, you must configure AR System Configuration Generic UI form to allow searching on CLOB data types.
Consider the effect of searching on system performance. You might want to use FTS to create a search index for diary fields. Note that you cannot search for the time stamp or the name of the user who submitted an entry.
You cannot use the Indexes form property to create an index for a diary field. However, if you are licensed for full text search, you can use the Index For FTS field property to create a search index for the field. For more information, see Enabling-and-disabling-full-text-search.