Are operators like AND, OR, and the use of quotations allowed? This is the essentially the same question as What operators (if any) are available in the Self-Service Portal Search? | Community but for the Admin list view.
Question
What operators (if any) are available in the Advanced Search of the SysAid Classic Admin list view?
+4
+4Hi there,
SysAid Copilot is here with our AI Magic!
Here is the response we thought might assist you:
SysAid Copilot is here with our AI Magic!
Here is the response we thought might assist you:
## Advanced Search operators in Classic Admin list views
Short answer: Yes—AND/OR logic is supported via the Expression Builder, along with standard comparison operators. Quotation marks are supported for exact matches in text fields.
### Where to configure
- In any Classic list (e.g., Administrators, Service Records), click the filter icon and then Edit under “Advanced Filter” to open the Expression Builder.
### Supported logic and comparisons
The Expression Builder lets you build conditions with:
- Logical operators: AND, OR (you can nest groups)
- Comparators (vary by field type):
- Equals / Not equals (=, ≠)
- Contains / Not contains (for text fields)
- Starts with / Ends with (text)
- In / Not in (lists/enumerations, multi-select)
- Greater than / Less than / ≥ / ≤ (numbers, dates)
- Is empty / Is not empty (null/blank checks)
- Date shortcuts like Today, Yesterday, Next 7 days, Previous 30 days (for date fields)
### Quotation marks
- For text values with spaces or to force an exact phrase, wrap the value in quotes, e.g., "John Smith".
- Contains vs. Equals:
- Contains "Smith" finds partial matches
- Equals "John Smith" matches the full field exactly
### Examples
- Assigned group is “Service Desk” AND Responsibility equals “John Smith”
- Title contains "VPN" OR Description contains "AnyConnect"
- Status in (Open, Pending) AND Due date is in Next 7 days
### Tips
- For list fields, prefer In/Not in to check multiple values.
- Use grouped conditions to control precedence: (A AND B) OR C.
- If a field doesn’t appear, it may be excluded from the list’s filter menu; customize the view to include it.
If you need help crafting a specific filter, share the list type and the conditions you want, and I’ll translate it into an Expression Builder setup.
Short answer: Yes—AND/OR logic is supported via the Expression Builder, along with standard comparison operators. Quotation marks are supported for exact matches in text fields.
### Where to configure
- In any Classic list (e.g., Administrators, Service Records), click the filter icon and then Edit under “Advanced Filter” to open the Expression Builder.
### Supported logic and comparisons
The Expression Builder lets you build conditions with:
- Logical operators: AND, OR (you can nest groups)
- Comparators (vary by field type):
- Equals / Not equals (=, ≠)
- Contains / Not contains (for text fields)
- Starts with / Ends with (text)
- In / Not in (lists/enumerations, multi-select)
- Greater than / Less than / ≥ / ≤ (numbers, dates)
- Is empty / Is not empty (null/blank checks)
- Date shortcuts like Today, Yesterday, Next 7 days, Previous 30 days (for date fields)
### Quotation marks
- For text values with spaces or to force an exact phrase, wrap the value in quotes, e.g., "John Smith".
- Contains vs. Equals:
- Contains "Smith" finds partial matches
- Equals "John Smith" matches the full field exactly
### Examples
- Assigned group is “Service Desk” AND Responsibility equals “John Smith”
- Title contains "VPN" OR Description contains "AnyConnect"
- Status in (Open, Pending) AND Due date is in Next 7 days
### Tips
- For list fields, prefer In/Not in to check multiple values.
- Use grouped conditions to control precedence: (A AND B) OR C.
- If a field doesn’t appear, it may be excluded from the list’s filter menu; customize the view to include it.
If you need help crafting a specific filter, share the list type and the conditions you want, and I’ll translate it into an Expression Builder setup.
+4AI didn’t quite understand my ask. I am asking about the Advanced Search text box, not the expression builder.
+1Hi Colin,
Quotation marks are ignored, and operators like AND and OR are not supported in the Advanced Search box for any list view. Instead, you can use advanced filters, which do support these operators.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
