Finds all occurrences of the specified value without regard for uppercase/lowercase. Applies only to alphanumeric/text fields.

  Examples:
 ~French
 ~french
 ~French

Case insensitivity can also be combined with the wildcard symbols (*) and (?).

 Examples:
 ~1A4?3B
 ~customer*
 ~Fr*21?3
 

Finds all exact matches of the specified value.

  Examples:
 =quote (when entered in the 'Header Status' field in Product Inquiries-Orders/Quotes (IC45/I1), as an example, will search for ALL Quotes)
 =1423
 =tomato
 =Tomato
 =TOMATO
 =ToMaTo
 =2006-11 (during specific month, where QBE equivalent is 2006-11-01 00:00:00.0..2006-11-30 23:59.59.9)
 =      (to search for NULL)

Note: If a value you want to search for contains one of the reserved search symbols, then prefix the value with the equal operator. For example, if you want to search for 101A-208B<D,C,then enter =101A-208B<D,C to get an exact match. With the (=) in front, the (<), (-) and (,) will be treated as regular characters.
 

Finds all values, except for NULL values, which are not equal to the specified value.

  Examples:
 <>0 (when entered in the 'Quantity Back-ordered' field in Product Inquiries-Orders/Quotes (IC45/I1), as an example, will search for ALL Back Orders)
 <>9876
 <>ARM
 <>aRm
 <>    (to search for NOT NULL)

Finds all values, except for NULL values, which are GREATER THAN the specified value.

  Examples:
 >0 (when entered in the Quantity Back-ordered field in Product Inquiries-Orders/Quotes (IC45/I1), as an example, will search for ALL Back Orders)
 >1423
 >federal
 >2006-11-23 14:25:37 (after specific second, where QBE equivalent is >2006-11-23 14:25:37.9)
 

Finds all values, except for NULL values, which are GREATER THAN OR EQUAL TO the specified value.

  Examples:
 >=1423
 >=federal
 >=2006-11-23 14 (during or after specific hour, where QBE equivalent is >=2006-11-23 14:00:00.0)
 

Finds all values, except for NULL values, which are LESS THAN the specified value.

  Examples:
 <1423
 <case
 <2006-11-23 14:25 (before specific minute, where QBE equivalent is >=2006-11-23 14:25:00.0)
 

Finds all values, except for NULL values, which are LESS THAN OR EQUAL TO the specified value.

  Examples:
 <=1423
 <=case
 <=2006-11-23 14 (before specific hour, where QBE equivalent is >=2006-11-23 14:59:59.9)
 

In addition, returns the opposite value of the search symbol used. For example, "!10:20" returns any values not between 10 and 20.

  Examples:
 !order,01,dirbil,note (when entered in the 'Shipping Document Number' field in SU45/I1, as an example, will search for ALL Back Orders)
 !case,tare,pallet (not in list)
 !TAX* (not like)
 !a:b (not between)
 !a..b (not in range)

Theoretically, all existing operators can be negated; however, the following already have an equivalent:
a) If the operator is <=a (less than or equal to), then to negate it, we would enter !<=a (not less than or equal to) or its equivalent, >a (greater than).
b) If the operator is <> (is not null), then to negate it, we would enter !<> (not is not null) or its equivalent , = (is null).

Note: ! is not the same as <>. ! means "not", whereas <> means different than or not equal to. != is the same as <>.

Note: !a means not "a", which is the same as <>a; this only works when you have a single value.
 

Finds all exact matches of the specified value, and where * is zero or more arbitrary characters.

  Examples:
 14a*3B
 fr*d

Note: For a search expression like ABC:01*DEF-99, a wildcard operation would be performed because the (*) has higher precedence than the (:) and the (-).
 

Finds all exact matches of the specified value, and where ? is one arbitrary character.

  Examples:
 14a?3B
 customer?
 

Finds all occurrences of any of the specified values.

  Examples:
 423,1426,1533,1890
 Costco, Rona
 

This is the preferred method of separating multiple values in a search where the criteria contains a numeric value. This allows numbers to be formatted using using the comma as a decimal place or a thousand separator.

  Examples:
 Costco|Rona
 33.50|4,342.23|5,599.12
 

Finds all values between, and including, the two specified values. If multiple range symbols occur in your search expression, the first highest priority symbol encountered (according to the order in the list above) is treated as the range symbol for your search, and all other occurrences are treated as regular characters.

  Examples:
 1423:1429
 A..Z
 IM-1..IM-9
 2006-02-18 00.00.00..2006-02-19 00.00.00
 

Math Operator: (+|-). Add or subtract the quantifier.

Quantifier: (0-9). Numeric that will be used in conjunction with the math operator and the qualifier to add or subtract a certain amount of time.

Qualifier: (hour|day|week|month|year). Hour or day or week or month or year. Day is default.

Note: If no qualifier is specified, the default is taken.

Post Instruction: (hour, day, week, month, and year).

Math Operator: (+|-). Add or subtract the quantifier.

Quantifier: (0-9). Number of hours, days, weeks, months or years to add or subtract. When a post instruction is specified, it uses the post instruction as the qualifier.

Qualifier: (hour|day|week|month|year). Hour or day or week or month or year. Defaul is day. Not valid when a post instruction is specified. The system will take the post instruction and use that as the qualifier.

  Examples:

  {session.user}, tecsys: current user or user tecsys

  <>{session.user}: anyone but the current user