Allowed Comparisons and Values

The following table shows all the AccuWork data types, along with the corresponding choices for the <comparison-operator> and <value> parts of a simple clause.

Field Type Comparison Operators Allowed Values
Text
  • contains
  • matches
  • 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

Any character string. (Do not enclose it in quotes.) The value is always interpreted as a string literal; there is no way to specify the value of some other field here.

The comparison is always a case-insensitive string comparison, never a numeric comparison. For example, the value 3 is greater than the value 25.

The contains and does not contain operators perform a simple case-insensitive substring search, with no pattern matching.

The matches and does not match operators perform case-insensitive pattern matching, using these wild cards:

*
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 (do not mix uppercase and lowercase here).
{one,two,seven}
Matches one, two, or seven.
\ or /
Matches any directory-separator character, even if it is the "wrong one" for the client machine. For example: src/do_*.java matches src\do_something.java on a Microsoft Windows client.

Examples:

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).

Timespan
  • equal to
  • not equal to
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to

A numeric value, representing an amount of time.

Choose List
  • is
  • is not
  • is in
  • is not in

One of the strings specified as valid values for the field in the Schema Editor.

User
  • is
  • is not
  • is in
  • is not in
  • is member of
  • is not member of

One of the principal-names in the user registry maintained by the AccuRev Server. Alternatively, a user-group defined in the registry.

Timestamp
  • is
  • is not
  • is before
  • is after
  • is before or equal to
  • is after or equal to

An AccuRev timestamp.

Attachments
  • contains

Any character string. This string is compared to the Names of an issue record's attachments.

internal
  • equal to
  • not equal to
  • less than
  • less than or equal to
  • greater than
  • greater than or equal to

An integer, identifying a particular AccuWork issue record (Issue field) or a particular AccuRev transaction (Transaction field).