Operators

Use operators to help refine searches.

Related Topics:

  • Comparative Operators
    When you perform an Advanced lookup or a SQL Where Clause lookup, you can use a number of comparative operators, such as "equals," "less than," "greater than," and "starts with."
  • SQL Operators
    Use a number of operators, such as "LIKE," "IN," and multiple comparative operators when you perform a SQL Where Clause lookup.
  • Is Me and Is Not Me Operators
    Use the "Is Me" and "Is Not Me" operators to search for records that do or do not belong to you when you perform an Advanced lookup.
  • Is Mine and Is Not Mine Operators
    Use the "Is Mine" and "Is Not Mine" operators to search for records that do or do not belong to you when you perform an Advanced lookup.
  • Is Home Company and Is Not Home Company (Multicompany)
    If you have the Multicompany feature, use the Is Home Company and Is Not Home Company operators to search for records that are or are not the employee's home company when you perform an Advanced lookup.
Parent Topic: Searching for Records