In DPQL  you can use the LIKE operator in the WHERE clause to check for certain patterns.

You would use it alongside wildcards:

%  represents any number of characters

_  represents one character

Examples

Tickets from a single email domain

An example of this you could use would be if you wanted to look at all tickets from users under a specific email domain.

The query below wouldn't work as the email address is incomplete:

SELECT Tickets.id, tickets.person.emails.email
FROM tickets
WHERE tickets.person.emails.email = 'deskpro.com'
 copy

However if rather than = we use Like and the % wildcard we can pull all emails that end in deskpro.com

SELECT Tickets.id, tickets.person.emails.email
FROM tickets
WHERE tickets.person.emails.email LIKE '%deskpro.com'
 copy

Tickets from similar email domains

Similarly if we wanted to pull all tickets submitted from Deskpro.com and Deskpro.co.uk we could use the following as the second % would bypass the characters specified after deskpro:

SELECT Tickets.id, tickets.person.emails.email
FROM tickets
WHERE tickets.person.emails.email LIKE '%deskpro%'
 copy

Wildcard Variations

You can play around with the way you use wildcards to return values in different scenarios.

Below are some wildcard variations that return support@deskpro.com :