Filter
Top Products
Chapter 6: User Interface Using Queries
Altiris Helpdesk Solution User Guide 70
warning message, with a yellow background is displayed beneath the comment field that indicates
that full-text search is not enabled. When full-text search is not enabled, FREETEXT and
CONTAINS syntax may not be used.
Manual Configuration
If the Full-Text Search service, MSSearch, is not installed, full-text searches cannot be configured
and full-text searches will need to be configured manually. MSDN has a good article on
implementing full-text searches at http://msdn.microsoft.com/library/periodic/period01/
ntp0111.htm. This article includes information on installing the MSSearch service, creating a full-
text index and catalog, populating the full-text catalog, and scheduling catalog updates.
Syntax
When full-text search service is enabled, it recognizes whether the search being performed is a
FREETEXT or CONTAINS search.
IMPORTANT Do not include the FREETEXT or CONTAINS predicate in the search field, this will
be done for you.
FREETEXT is less precise than CONTAINS and matches values on meaning, not the exact word.
The following MSDN article discusses FREETEXT in detail: http://msdn.microsoft.com/library/
psdk/sql/ts_fa-fz_2juc.htm.
CONTAINS is more precise then FREETEXT and recognizes special syntax such as and, or, and
not, FORMSOF, NEAR, etc. The following MSDN article discusses CONTAINS in detail: http://
msdn.microsoft.com/library/psdk/sql/ts_ca-co_2y2h.htm.
If full-text searching is enabled, the user can override FREETEXT or CONTAINS searches by
checking
Disable full-text searching in the Find feature. This lets the user perform wildcard searches
as discussed in “Wildcard Searches” below.
Wildcard Searches
Wildcard searches are not nearly as powerful as FREETEXT and CONTAIN searches. If full-text
searches have been configured, the user is limited to this type of search. Any valid Transact SQL
wildcard character can be used (e.g. %, _, [] [^]). The following MSDN article discusses wildcard
searches: http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/
ts_tsqlcon_6lyk.htm
IMPORTANT Do not include the LIKE predicate in the search field, this will be done for you.
Using Queries
The Queries option lets workers access work item data by running a query, creating a new query or
deleting an existing query they previously created.
Queries provide workers a flexible way to access work item data. A number of useful queries are
included as shared queries, or queries common to all workers.
The query system includes a parameter replacement system so that input can be solicited whenever
the query is run. Note that the query system only works against the most recent version of all work
items; however, any valid Tansact-SQL WHERE clause (minus the word “WHERE”) can be entered
as the expression to be evaluated.
See Also
List Query (page 71)
New Query (page 71)
Modify New Query Search (page 72)
Query Data Types (page 73)
Query Parameter Replacement (page 76)