HaloITSM Guides
Documentation to assist with the setup and configuration of the HaloITSM platform
Guides > Database Lookup for Attaching the User's Role to a Ticket.
Database Lookup for Attaching the User's Role to a Ticket.
One of the great features within Halo is the ability to populate fields on i.e. a ticket with information found in the database. This data is found using SQL queries which will return the information you want to populate the field with. For populating a users first and last name using the email field, check out this guide: Lookups
In order to set this population of User Role's, we must create a custom field of entity type: Ticket
This custom field can be used in our db lookup as the field we are populating, begin by setting a trigger field, In this case the summary being updated will trigger the user role lookup:
The following guide will explain how to populate the user's role onto a ticket within Halo.
Popular Guides
- Asset Import - CSV/XLS/Spreadsheet Method
- Call Management in Halo
- Creating a New Application for API Connections
- Creating Agents and Editing Agent Details
- Departments, Teams and Roles
- Halo Integrator
- Importing Data
- Multiple New Portals with different branding for one customer [Hosted]
- NHServer Deprecation User Guide
- Organisation Basics
- Organising Teams of Agents
- Step-by-Step Configuration Walk Through
- Suppliers
