Ir al contenido principal

What do I use in a query to retrieve the email address of ticket users? - Base de conocimiento / Developer & Reporting / DPQL Examples - Deskpro Support

What do I use in a query to retrieve the email address of ticket users?

Lista de autores

Question: 

I want to make a query that returns a table of tickets, including the email address of each ticket's owner. What do I use in my query to retrieve that?

Answer:

You can cross-reference from the tickets table to the person table using: 

tickets.person.primary_email.email

 

e.g.:

SELECT tickets.id, tickets.subject, tickets.date_created, tickets.person.primary_email.emailFROM ticketsWHERE tickets.date_created >= '2014-01-08'LIMIT 5000

 

which would give you a table like this: 

IDSubjectDate CreatedEmail
 526 Problem with tiger     Wed, 8th Jan 2014 12:21 am   user@example.com    
Útil Poco útil

70 de 125 personas considera que esta página es útil

Nuevo comentario

Por favor, ingresa o regístrate para enviar un comentario.

¿Necesitas que te recordemos la contraseña?