HP Altris eXpress Helpdesk Solution 5.6 SP1 manual Search in Comment or Title Field

Chapter 6: User Interface Search in Comment or Title Field

Find Work Item Advanced Field Description

In addition to the Simple search field options, the Advanced search offers the following additional search fields.

Page Items

Item	Description
Contact Name	Type the Name of the new contact.
Contact E-mail	Type the E-mailaddress of the new contact.
Asset	Type a description of the asset.
Asset type	Select the Asset type from the drop-down list.
Modified by	Type a worker name who modified the asset.
Created by	Type a worker name who created the asset
Modified by date	Type the date range to search, then select either the before or after
range	option.
Created by date	Type the date range to search, then select either the before or after
range	option.
Start by date range	Type the date range to search, then select either the before or after
	option.
Due by date range	Type the date range to search, then select either the before or after
	option.
Find	Click to begin search.
Reset	Click to clear form.

Search in Comment or Title Field

You can search within the comment field of a work item. Unlike searching in other fields, which search only the current state of the work item, searching in comments- works against the current state of the work item as well as historical work item data. This is very beneficial as workers search work items for helpful solutions to similar problems.

Full-text searching using FREETEXT and CONTAINS (Transact SQL) syntax is supported, but may require configuration. Full-text searching provides very powerful searching within the comment field.

If MS SQL 7 or 2000 has not been configured for full-text searching, searches can still be done using Transact SQL wildcard character searches (see “Wildcard Searches” below). These searches are more limited than full-text and can be less efficient than full-text searching, especially as your database grows larger.

Full-text (FREETEXT and CONTAINS) Searches

Note Full-text searching is only supported with MS SQL 7/2000, not MSDE.

During initial configuration, full-text search configuration is attempted. In order to do this, the Full- Text Search service, MSSearch, must be installed using an advanced options available during the MS SQL installation. Additionally, this service can be activated post install. If successful, a full-text index is created on the comment column of the workitem table, and a new catalog, HD_workitem_comment, is created to store the full-text index.

When full-text searches have been correctly configured, a message is displayed beneath the comment field that indicates that FREETEXT and CONTAINS syntax may be used. Additionally, the message contains the date and time that the index in the catalog HD_workitem_comment was last updated. Comment data modified after this date will not be found using a full-text search until the catalog has been updated (repopulated). If full-text search has not been correctly configured, a

Altiris Helpdesk Solution User Guide 69