Query Data Types | HP Altris eXpress Helpdesk Solution 5.6 SP1

Chapter 6: User Interface

Using Queries

4Modify the parameters of the query.

5Click Run.

6If you would like to save this query, you must give the query a name in the Name box.

7Click Save.

8Once the browser page is refreshed, the new query will appear in the Based on drop-down list as

well as in the List query page.

New Query Page Field Description.

Page Items

Item	Description
Name	Type a Name for the new query search.

Based on:	Select a default query from the drop-down list.

Get Expression	Click the Get Expression to display the query parameters in the
	Expression box.

Expression	Modify the text of the query parameters.

Run	Click to perform the search.

Save	Click to save the New query search criteria.

Cancel	Click to abort function.

Items:	Displays the query search results.

Query Data Types

When creating queries the worker must be aware of the data types of the fields that are used in the query so that single quotes can be added or omitted appropriately. There are three basic data types for these fields: unit, string, and datetime. If the data type of the field is string or datetime the argument must be quoted.

String Examples

workitem_external_reference like ‘SMS%’ (wild card character for partial string matching)

assigned_to_worker_name = 'mdavis'

Datetime Examples

workitem_modified_on > '12/11/00 10:10:00 AM'

workitem_modified_on > '12/11/00 10:05:00' (interpreted as 24 hour clock) workitem_modified_on > '12/08/00 15:00:00'(interpreted as 24 hour clock) workitem_modified_on > '12/11/00' (interpreted as midnight between 10th and 11th) workitem_modified_on > 'Dec 09, 2000 10:00:00 AM' workitem_modified_on > '20001209'

Uint Examples

workitem_number > 150

workitem_minutes_spent > 3

workitem_status_lookup_id = 100

Altiris Helpdesk Solution User Guide

73

Image 73

HP Altris eXpress Helpdesk Solution 5.6 SP1 manual Query Data Types, New Query Page Field Description, String Examples

Contents

Helpdesk Solution 5.6 SP1 User Guide Altiris Helpdesk Solution User Guide Contents New Contact Delete Notify Rules 116 Document Conventions PrefaceWhat you see Training SupportBefore Contacting Support Support Contact Information Preface Altiris Helpdesk Solution User Guide Complete, Integrated System Introducing Helpdesk SolutionIntegrate with Microsoft SMS Scenario Helpdesk Solution Satellite Architecture Features Features and BenefitsCustomize with Ease Benefits Server System RequirementsWorker Console End User Console Installation Preview Installing and Setting Up eXpressSoftware Requirements Hardware Notification Server Computer RequirementsSoftware Install Prerequisite Software to Notification Server Installing and Setting Up eXpress Installing and Setting Up eXpress Install Notification Server Altiris eXpress .NET Configuration Wizard Install Helpdesk SolutionTo Install a Satellite Helpdesk Satellite Helpdesk Configure Helpdesk Command Architecture Helpdesk Overview Worker Consoles Helpdesk Solution Consoles User Consoles Workers and Worker QueuesSee Also Workers Contacts Assets Work Items Integration with Microsoft Systems Management Server SMS Prerequisites Installation Console to start the Web Administration Console Helpdesk Setup To configure the Helpdesk Configuration Wizard Altiris eXpress.NET Configuration Wizard Enter a domain\user and password Modifying Helpdesk Solution Installation Configuration Upgrading Releases Uninstalling Localization Configure Regional Option End User Console Web Administration Console Interface Elements ConfigurationPolicies Reports Console Security Workers Administrators End Users Setting Permissions Entry Points Console.configuration WorkerMode=workerwinUserguestuser Credential SelfEnrollmentCmd= Licensing User Interface Logoff Client Access Server AccessAltiris eXpress Helpdesk Consoles Default Page Description CommandsHelpdesk Worker Console Work Items Toolbar Description Common tasksAssets Recent Bulletins Item Count, Date and TimeWorker Report To Open a New Work Item New Work Item Description Work Item Page Description Add New Work Item To View or Edit Work Items View or Edit Work Items Additional Work Item Information To Attach a File to a Work Item Attachments Attach Page Field Description Link Work Items To Link a Work Item Link Page Field Description To Send E-Mail Messages Mail Messages Mail Page Field Description View Contact Properties New Work ItemTo View Contact Properties NT ID Contact Page Field Description Find Contact New Work Item Auto-Associating an Item’s Asset Using the ContactTo Find a Contact To Select a Contact Select Contact New Work Item To View Asset Properties View Asset Properties New Work Item Asset Page Field Description Find Asset New Work Item Select Asset New Work Item Auto-Associating an Item’s Contact Using the AssetTo Find an Asset To Select an Asset Find Work Items Find Work Items Simple Tab Find Work Item Simple Field Description Find Work Items Advanced Tab Find Work Item Advanced Field Description Search in Comment or Title FieldFull-text Freetext and Contains Searches Manual Configuration Syntax Using QueriesWildcard Searches New Query List QueryList Query Page Field Description To List Queries To Create a New Query Modify New Query SearchTo Modify a Query Search New Query Page Field Description Query Data TypesString Examples Datetime Examples Field Name Type Acceptable values Comments Be inactive virtual workgroups or $currentworkerid$ Query Parameter Replacement$promptnumberprompt$ $promptstringprompt$ $promptdateprompt$ $promptdatetimeprompt$ Are you sure you want to delete the following items? Delete Queries Last Query Results Contacts Contacts Home Retrieve Queued Item Find Contacts View Contacts Find Contacts Page Field Description New ContactTo Add a Contact New Contact Page Field Description View Assets Assets Assets HomeTo Use the Assets Home Find Assets New AssetTo View Assets To Add a New Asset New Asset Page Field Description To Use the Recents Recents To Use My Helpdesk Console My Helpdesk ConsoleMy Helpdesk toolbar description Sort Work Item List My Helpdesk New Work ItemTo Add a New Work Item To Edit My Info Edit My Info Logoff Work Item Request NT UserTo Logoff My Helpdesk Work Item Request Guest Work Item Request User Work Item History Create Custom URL to Access Helpdesk ConsolesTo create a custom URL Pocket PC Navigation Support for Pocket PC PPC Administration Administration Admin Helpdesk Admin Console Admin Report Run Admin Reports Admin Report Page Field Description List Categories Page Description Categories List Categories Edit Categories Add New Category Modify Category Move Category Copy Category Delete Category List Routing Rules Routing Rules Edit Routing Rule Process Order of Routing Rules To Create a New Routing Rule New Routing Rule Altiris Helpdesk Solution User Guide 110 To Delete a Routing Rule Delete Routing Rules Notify Rules Default RulesList Notify Rules New Notify Rule Altiris Helpdesk Solution User Guide 114 Edit Notify Rule Select the check box for the rule to be Default Delete Notify Rules List Templates Mail Templates New Template Edit E-mail Templates Default E-mail Templates Simple Macros Mail Template Macros Mail Macros Complex Macros List Bulletins Bulletins Delete Bulletin Add New Bulletin View Source SourcesList Sources New SMS Source New NS Source Edit Source Import from Source Configure Helpdesk Option 1 This database was last configured by Alert Manager Simple Tab Delete Work Items Delete Work Item Simple Field Description Advanced Tab Delete Work item Advanced Field Description Delete Contacts Delete Assets New Worker WorkersList Workers Edit Worker View Queue List Queue Edit Queue New Queue Reports Notification Policies Service Level Agreements Log Files Troubleshooting URL Index