Forum GLPI-Project

shku

Member

Registered: 2023-04-03

Posts: 2

How to calculate value for field uuid of table glpi_tickettasks?

Hi!

My version GLPi 9.5.12.
Database - MySQL.

I need to process about 100 tickets (for example), solution for all of them identical. There is no packet processing of tickets in GLPi as i know. So i trying to make sql for such kind of routine. In my investigate i found that for solve ticket i need to insert data in tables:
glpi_logs
glpi_tickettasks
glpi_itilsolutions
and update table glpi_tickets.

Anybody know or can give advice how to calculate value for field uuid of table glpi_tickettasks?

Thank you!

Last edited by shku (2023-07-06 16:41:46)

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: How to calculate value for field uuid of table glpi_tickettasks?

why don't you use REST API , just add solutions and that's it, glpi fills all related tables.
make a loop to process all the tickets

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

shku

Member

Registered: 2023-04-03

Posts: 2

Re: How to calculate value for field uuid of table glpi_tickettasks?

Because we use plugin moreticket and to solve ticket we use mandatory Duration field. I don't know what data in API request i have to use.