Contents x
- Release Notes
- Installation and Upgrade Instructions
- Guides
- Automate Joe Onboarding Guide
- Guide to the SysAid Remote Discovery Service (RDS)
- Network Discovery Guide
- Multi-Factor Authentication
- SysAid Cloud Migration
- SysAid Database Guide
- SysAid Getting Started Guide
- SysAid Mobile for On Premises Accounts
- SysAid Mobile Solution
- SysAid Self-Service Portal Admin Guide
- SysAid Agent Deployment Guide
- SysAid Patch Management Guide
- SysAid Remote Control Guide
- Guide to SysAid Change Management and Problem Management
- SysAid REST API Guide
- SysAid Copilot
- For Agents
- AI Chatbot for Agents
- Service Desk
- Spaces
- Spaces
- Spaces Hybrid Mode
- Queue
- Service Records
- Templates
- Workflows
- Settings
- Customization
- Administration
- Classic
- Spaces
- Advanced Configurations
- Analytics
- Tools
- Tasks and Projects Guide
- Project List
- Project Form
- Others
- Process Monitor
- SSO Connector
- OneLogin User Repository
- Automate Joe Processes
- Okta Repository
- ABots Guide
- ABots - Active Directory User Management - On\Offboarding
- ABots - Azure User Management -On/Offboarding
- ABots - Active Directory User Management - Groups and OU
- ABots - Azure AD User Management - Licensing
- ABots - Microsoft Exchange - User Management - Distribution Groups
- Automate Joe Setup Guide
- Task
- Tasks and Projects Activities
- Project List
- Password Services Guide
- My Calendar
- User Management
- Tasks and Projects Guide
- Articles
- Assets
- Integrations
- Text Messages
- Asset Warranty Integration
- LDAP Integration
- SysAid API
- Marketplace
- My Apps
- SysAid CTI (Computer Telephony Integration)
- Calendar Sync
- Settings
- Customization
- Templates & Fields
- Categories
- Automations
- SLA/SLM Guide
- Service Desk Settings
- Notifications
- Account
- Tasks & Projects
- Lists
- My Menu
- Self-Service Portal
- Customize Forms
- Administration
- Tracking
- Setup & Monitoring
- Customization
- For End Users
- Documentación en línea
- Mesa de ayuda todo
- Formulario del SR
- Guía de instalación de SysAid
- Guía de inicio de SysAid
- Guía de implementación del agente de SysAid
- Guía del administrador
- Configuración General
- Formulario de integración de correo electrónico
- Formulario de notificación personalizado
- Editar/crear nueva notificación
- Guía del portal de autoservicio
- Enviar un incidente
- Mi configuración
Article summary
Did you find this summary helpful?
Thank you for your feedback
The Expression Builder*, referred to in some places as the Query Builder, appears throughout SysAid in many different places. On the various list pages, you can open it using the filter icon . In other places, such as reports, it's accessible using the Expression Builder icon . The purpose of the Expression Builder is to filter results, such as list results and report results.
*When creating an escalation rule, the Expression Builder is referred to as the Action Builder, and has a different function. Please see escalation rules for further details.
SysAid Expression Builder
Components of the Expression Builder
A filter is composed of four parts:
- Statement: Can be "and" or "or."
- The field to filter: The fields that show up here will vary depending upon what page you're on when you access the Expression Builder.
- The expression : This is determined by the field to filter. A simple example could be "Location is not..." Certain fields have additional options for the expression, such as the Due Date field, which includes expression such as "Next seven days," and "Previous seven days."
- The desired value for the field : The field type will determine your options here. Lists will allow you to choose an entry from the drop-down list, date fields include the calendar icon , and integer and text fields are free-form entry.
Creating a filter
To create a filter using the Expression Builder :
- Decide how many filter lines you will need. If you only need one line, leave the first drop-down on "Statement" and go to step 5.
- To add another filter line, first choose a statement, either "and" or "or." This will automatically add another line connected by the chosen statement.
- If you need to add more lines connected by the same statement (i.e., this and that and the other thing), click Add new line. If you would like to delete a line, click Delete line.
- For each filter line, choose the field, expression, and desired value for the field (e.g. Location + is + HQ Building).
- When you have set up all of the filter lines you need, click Create Filter to apply your filter. This will automatically close the window.
- In the event that you have set up a filter and you would like to erase it, click Reset Filter.