Advanced Editor

The Advanced Editor lets you define more complex conditions when matching tickets. You can create custom criteria not possible with the Basic Editor using a SQL-like format. It is recommended that you use the Basic Editor to build your initial criteria, then switch to the Advanced Editor to fine-tune your query.

Note: Switching from the Advanced Editor back to the Basic Editor will clear all conditions. ChangeGear displays a confirmation dialog when you attempt to switch back to the Basic Editor.

The Advanced Editor provides a validate button which performs basic syntax checking on the query. If the query is valid, the editor displays "Validated without errors." If the query is not valid, the editor displays an error message with the nature and location of the problem.

The following table explains some of the more common operations used in the Advanced Editor:

Symbol

Description

Example

[ ]

Defines a field name.

[PriorityName]

' '

Defines a value to compare against.

[PriorityName] = '1 - Critical'

AND
OR

Compares two or more conditions.

[PriorityName] = '1 - Critical' AND [Approved] = 'true'

( )

Defines a set of conditions to compare before comparing it against other conditions.

([PriorityName] = '1 - Critical' AND [Approved] = true) OR [CategoryName = '1 - Major'