Filter Term
|
Definition
|
| Null |
Checks if the field contains values that don't exist at all. Used to filter out records that don't have any data present. |
| Is Not Null |
Checks if the field contains has some value including an empty value. Used to filter where the value is not missing or the data is not 'Null'. |
| equal to |
Checks if a value is the same as another value. For example, reservation # = 1162241480445 will only show records for that reservation number. |
| is not equal to |
Chesks if a value is not the same as another value. For example, reservation # is not equal to 1162241480445 will only display records that do not exist for that reservation number. |
| greater than or equal to |
Checks if a value is larger than or the same as another value. For example, Check-In Date >= 2024-11-05 will show records with a check-in date of 2024-11-05 and all of those after. For dates there will be multiple options to select the date value you are checking against: custom date, start of today, start of tomorrow, start of yesterday, start of current week, start of last week, start of next week, start of current month, start of last month, start of current quarter, start of last quarter, start of next quarter, start of current year, start of last year, start of next year, x days prior, x days later, x months prior, x months later, x years prior, x years later. |
| greater than |
Checks if a value is larger than another value. For example, Check-In Date > 2024-11-05 will show records with a check-in date of 2024-11-06 and all of those after. For dates there will be multiple options to select the date value you are checking against: custom date, start of today, start of tomorrow, start of yesterday, start of current week, start of last week, start of next week, start of current month, start of last month, start of current quarter, start of last quarter, start of next quarter, start of current year, start of last year, start of next year, x days prior, x days later, x months prior, x months later, x years prior, x years later. |
| less than |
Checks if a value is smaller than another value. For example, Check-In Date < 2024-11-05 will show records with a check-in date of 2024-11-04 and all of those before. For dates there will be multiple options to select the date value you are checking against: custom date, start of today, start of tomorrow, start of yesterday, start of current week, start of last week, start of next week, start of current month, start of last month, start of current quarter, start of last quarter, start of next quarter, start of current year, start of last year, start of next year, x days prior, x days later, x months prior, x months later, x years prior, x years later. |
| less than or equal to |
Checks if a value is smaller than or equal to another value. For example, Check-In Date <= 2024-11-05 will show records with a check-in date of 2024-11-05 and all of those before. For dates there will be multiple options to select the date value you are checking against: custom date, start of today, start of tomorrow, start of yesterday, start of current week, start of last week, start of next week, start of current month, start of last month, start of current quarter, start of last quarter, start of next quarter, start of current year, start of last year, start of next year, x days prior, x days later, x months prior, x months later, x years prior, x years later. |
| in |
Checks if a value is part of a list to include records for. For example, Transaction Status in ('Pending', 'Posted') will return all records that have a transaction status of pending or posted but Transaction Status in ('Pending') will return all records that have a transaction status of posted only. This filter will have a checkbox list for selection. |
| is not in |
Checks if a value is part of a list to exclude records for. For example, Transaction Status is not in ('Pending') will return all records that have a transaction status of posted but no records that have a transaction status of pending. This filter will have a checkbox list for selection. |
| contains |
Checks if a value includes specific text. For example, a guest first name containing 'ro' will return all records where the guest first name contains 'ro' such as Rosie, Ronald, Deborah-Rose. This is not case sensitive. |
| does not contain |
Checks if a value does not include specific text. For example, a guest first name does not contain 'ver' will never show records with first name containing 'ver"' for Veronica, Oliver, Iver. This is not case sensitive. |
| begins with |
Checks if a value starts with specific text. For example a guest first name begins with 'Jo' will return records with guests such as John, Joanna, Johnson but not Jeremy or Juan. This is not case sensitive. |
| does not begin with |
Checks if a value does not start with specific text. For example a guest first name does not begin with 'Jo' will display records for guests such as Amber, Jeremy or Juan but not with John, Joanna, Johnson. This is not case sensitive. |
| ends with |
Checks if a value ends with specific text. For example, guest first name ends with 'th' display records for first name Elizabeth but not for first name Luz. This is not case sensitive. |
| does not end with |
Checks if a value ends with specific text. For example, guest first name does not end with 'th' display records for first name Emilio but not Lueth. This is not case sensitive. |
| is empty |
Checks if the field contains values that are empty or nothing with no usable data. |
| is not empty |
Checks if the field contains a value, including a non visible space. |
Comments
Please sign in to leave a comment.