You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2023-05-24 18:48:07

Julio_Anthony
Member
Registered: 2022-06-22
Posts: 2

inner join ticket table

Good afternoon, I want to query the database, but I don't know which GLPI database table is related to "Assigned technician" and "Technician group" with the ticket table.

Could you help me in saying which tables to make the inner join.

Me, I'm using GLPI version 10.

Thanks in advance

Offline

#2 2023-06-02 00:16:37

cconard96
Moderator
Registered: 2018-07-31
Posts: 2,819
Website

Re: inner join ticket table

glpi_suppliers_tickets, glpi_groups_tickets and glpi_tickets_users depending on the actor type.


GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.

Offline

Board footer

Powered by FluxBB