The Query Editor displays the contents of one query. The query appears as a hierarchy, which you navigate using familiar expand/collapse controls. The hierarchical organization is a natural fit, because each query is, itself, a hierarchy of simple clauses and compound clauses:
When you click the
New Query button to create an empty query, AccuWork assigns it a placeholder name ("New Query
nnn"). You can edit the name now: click the name once to select it, then press function key
F2 (or click it a second time) to begin editing it. Don't double-click — that's equivalent to using the expand/collapse control.
Every query consists at least one simple clause . A simple clause has three parts:
First, you must select the <field-name> part of the clause from the list-box containing all the field-names. When you select a field-name, the query editor automatically adjusts the
<comparison-operator> and
<value> parts of the clause, based on the selected field. In the example below, the user has selected field-name
productType, whose value must be one of these names:
ColorStar,
Mixer,
Publisher.
The table below shows all the AccuWork data types, along with the corresponding choices for the <comparison-operator> and
<value> parts of a simple clause. As you "fill in the blanks" to create simple clauses, you'll notice that AccuWork allocates new "Click here to add ..." placeholders, so that one is always available at each level of the query.
|
|
|
|
containsmatches does not contain does not match equal to not equal to less than less than or equal to greater than greater than or equal to
|
The contains and does not contain operators perform a simple substring search (case-insensitive), with no pattern matching.
The matches and does not match operators perform pattern matching (case-insensitive), using these wildcards:
* matches 0 or more characters ? matches any 1 character [aekz] matches a, e, k, or z [a-e] matches a, b, c, d, or e ( Note: Don’t mix uppercase and lowercase; neither [E–k] nor [e–K] matches any character] {one,two,seven} matches one, two, or seven \ or / Matches any directory-separator character, even if it’s the "wrong one" for the client machine. For example, src/do_*.java matches src\do_something.java on a Windows client.
Rls 4* matches Rls 4 and Rls 4.01, but not Rls 4.2 or Rls 5
Rls [2-5]* matches Rls 2, Rls3.04, and Rls 5.3, but not Rls 1.02
the -? option matches the -X option and the -4 option, but not the -Op option
cop{y,ies} matches copy and copies, but not copy(s)
|
|
equal tonot equal to less than less than or equal to greater than greater than or equal to
|
|
|
|
|
|
|
|
|
isis not is member of is not member of
|
|
|
isis not is before is after is before or equal to is after or equal to
|
|
|
|
|
|
equal tonot equal to less than less than or equal to greater than greater than or equal to
|
|
A compound clause combines any number of subclauses together, using the same logical operator:
AND or
OR. (The
NOT operator is not supported.) The subclauses to be combined can, themselves, be either simple or compound.
Whether you're composing a new query or revising an existing one, you end by saving your work (
Ok button) or discarding it (
Cancel button). If you didn't cancel the Query Editor session, AccuWork automatically executes the query and displays the results in the Query Results pane.
Note: Closing the window using its title bar controls is equivalent to
Cancel.