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