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
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.