HP Altris eXpress Helpdesk Solution 5.6 SP1 manual Using Queries, Manual Configuration Syntax

Chapter 6: User Interface Using Queries

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)

Altiris Helpdesk Solution User Guide 70