Skip to main content
Question

What operators (if any) are available in the Advanced Search of the SysAid Classic Admin list view?

  • November 6, 2025
  • 4 replies
  • 10 views

Forum|alt.badge.img+4

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.

4 replies

SysAid Copilot
SysAider
Forum|alt.badge.img+4
  • SysAider
  • 141 replies
  • November 6, 2025
Hi there,

SysAid Copilot is here with our AI Magic!
Here is the response we thought might assist you:

copilot-1.png
## 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.

Forum|alt.badge.img+4
  • Author
  • Active talker
  • 23 replies
  • November 6, 2025

AI didn’t quite understand my ask.  I am asking about the Advanced Search text box, not the expression builder.


iulian.olaru
SysAider
Forum|alt.badge.img+1
  • SysAider
  • 42 replies
  • November 6, 2025

Hi 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.


Forum|alt.badge.img+4
  • Author
  • Active talker
  • 23 replies
  • November 6, 2025

Thank you for the clarification Iulian.