What is an Operator?
With MyWork, you can now use a variety of operators to enhance your search results. These new tools allow you to refine your searches, helping you quickly and accurately find what you need.
Equals Operator:
The Equals operator is used when the value entered needs to precisely match the value recorded in the View Entity field. Date, currency, attribute, and text fields can all use this operator.
Has Value and Has No Value Operators:
Has Value and Has No Value operators are available for all field types.
- Has Value retrieves all records where the defined field has a value recorded.
- Has No Value returns records that have no value at all.
Contains, Starts With and Ends With Operators (available for text fields):
- The Contains operator requires that the user-input search value be present somewhere in the value recorded against the View Entity field.
- The Starts With Operator allows users to find values that begin with the user's input search value.
- The Ends With Operator allow users to find values that end with the user's input search value.
Comparison Operators:
When working with date and currency fields, comparison operators such as:
- < (Less Than)
- <= (Less Than or Equal To)
- > (Greater Than)
- >= (Greater Than or Equal To)
help create filters for searching for data. For example, using < allows users to find records where the recorded value is less than the number entered.
Between
The Between operator facilitates searches where the recorded value must fall within two user-defined limits, inclusive of the specified values. This operator is applicable to both date and currency fields.
Range (Days), (Weeks), (Months), (Years)
For date fields, the Range operators allow users to define ranges according to time intervals, such as days, weeks, months, or years. Each of them will determine whether the value, both before and after the input date, is within the user-specified range.
Range (Percent) and Range (Value) operators:
For currency data, The Range operator allows searches to determine if values fall within a percentage or dollar range around a specified input value.