Filter
Top Products
Chapter 6: User Interface Search in Comment or Title Field
Altiris Helpdesk Solution User Guide 69
Find Work Item Advanced Field Description
In addition to the Simple search field options, the Advanced search offers the following additional
search fields.
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
Page Items
Item Description
Contact Name Type the
Name of the new contact.
Contact E-mail Type the
E-mail address 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
range
Type the
date range to search, then select either the before or after
option.
Created by date
range
Type the
date range to search, then select either the before or after
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.