Forum GLPI-Project

floripes

Member

Registered: 2023-01-06

Posts: 2

help for query curl GLPI API

Hello.
I'm new to the API and I'm trying to make a curl query to get the tickets by status, but I'm having difficulties with the fields, could someone help me identify what the field IDs are?

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: help for query curl GLPI API

using endpoint listSearchOptions returns   ID of every fields you can search with API for an objects

for tickets use :

http://localhost/glpi/apirest.php/listSearchOptions/Ticket/

that returns :

{"common":{"name":"Caractéristiques"},
"1":{"name":"Titre","table":"glpi_tickets","field":"name","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.name"},
"21":{"name":"Description","table":"glpi_tickets","field":"content","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.content"},
"2":{"name":"ID","table":"glpi_tickets","field":"id","datatype":"number","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.id"},
"12":{"name":"Statut","table":"glpi_tickets","field":"status","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.status"},
"10":{"name":"Urgence","table":"glpi_tickets","field":"urgency","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.urgency"},
"11":{"name":"Impact","table":"glpi_tickets","field":"impact","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.impact"},
"3":{"name":"Priorité","table":"glpi_tickets","field":"priority","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.priority"},
"15":{"name":"Date d'ouverture","table":"glpi_tickets","field":"date","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.date"},
"16":{"name":"Date de clôture","table":"glpi_tickets","field":"closedate","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.closedate"},
"18":{"name":"TTR","table":"glpi_tickets","field":"time_to_resolve","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.time_to_resolve"},
"151":{"name":"TTR + rogression","table":"glpi_tickets","field":"time_to_resolve","datatype":"","nosearch":true,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.time_to_resolve"},
"82":{"name":"Temps de résolution dépassé","table":"glpi_tickets","field":"is_late","datatype":"bool","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","contains","notcontains"],"uid":"Ticket.is_late"},
"17":{"name":"Date de résolution","table":"glpi_tickets","field":"solvedate","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.solvedate"}
,"19":{"name":"Dernière modification","table":"glpi_tickets","field":"date_mod","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.date_mod"},
"7":{"name":"Catégorie","table":"glpi_itilcategories","field":"completename","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.ITILCategory.completename"},
"80":{"name":"Entité","table":"glpi_entities","field":"completename","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.Entity.completename"},
"45":{"name":"Durée totale","table":"glpi_tickets","field":"actiontime","datatype":"timestamp","nosearch":true,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.actiontime"},"64":{"name":"Dernière modification par","table":"glpi_users","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.users_id_lastupdater.User.name"},
"142":{"name":"Documents","table":"glpi_documents","field":"name","datatype":"dropdown","nosearch":true,"nodisplay":true,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.Document_Item.Document.name"},
"155":{"name":"TTO","table":"glpi_tickets","field":"time_to_own","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.time_to_own"},
"158":{"name":"TTO + progression","table":"glpi_tickets","field":"time_to_own","datatype":"","nosearch":true,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.time_to_own"},
"159":{"name":"TTO dépassé","table":"glpi_tickets","field":"is_late","datatype":"bool","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","contains","notcontains"],"uid":"Ticket.is_late"},
"180":{"name":"TTR interne","table":"glpi_tickets","field":"internal_time_to_resolve","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.internal_time_to_resolve"},
"181":{"name":"TTR interne + progression","table":"glpi_tickets","field":"internal_time_to_resolve","datatype":"","nosearch":true,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.internal_time_to_resolve"},
"182":{"name":"TTR interne dépassé","table":"glpi_tickets","field":"is_late","datatype":"bool","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","contains","notcontains"],"uid":"Ticket.is_late"},
"185":{"name":"TTO interne","table":"glpi_tickets","field":"internal_time_to_own","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.internal_time_to_own"},
"186":{"name":"TTO interne + progression","table":"glpi_tickets","field":"internal_time_to_own","datatype":"","nosearch":true,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.internal_time_to_own"},
"187":{"name":"TTO interne dépassé","table":"glpi_tickets","field":"is_late","datatype":"bool","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","contains","notcontains"],"uid":"Ticket.is_late"},
"188":{"name":"Prochain niveau d'escalade","table":"glpi_tickets","field":"next_escalation_level","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.next_escalation_level"},
"14":{"name":"Type","table":"glpi_tickets","field":"type","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.type"},"13":{"name":"Éléments associés","table":"glpi_items_tickets","field":"items_id","datatype":"specific","nosearch":true,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Item_Ticket.items_id"},"131":{"name":"Types d'élément associé","table":"glpi_items_tickets","field":"itemtype","datatype":"itemtypename","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals"],"uid":"Ticket.Item_Ticket.itemtype"},
"9":{"name":"Source de la demande","table":"glpi_requesttypes","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.RequestType.name"},"83":{"name":"Lieu","table":"glpi_locations","field":"completename","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.Location.completename"},"101":{"name":"Adresse","table":"glpi_locations","field":"address","datatype":"string","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.address"},"102":{"name":"Code postal","table":"glpi_locations","field":"postcode","datatype":"string","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.postcode"},
"103":{"name":"Ville","table":"glpi_locations","field":"town","datatype":"string","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.town"},"104":{"name":"État","table":"glpi_locations","field":"state","datatype":"string","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.state"},"105":{"name":"Pays","table":"glpi_locations","field":"country","datatype":"string","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.country"},
"84":{"name":"Numéro du bâtiment","table":"glpi_locations","field":"building","datatype":"string","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.building"},"85":{"name":"Numéro de la pièce","table":"glpi_locations","field":"room","datatype":"string","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.room"},"86":{"name":"Commentaires du lieu","table":"glpi_locations","field":"comment","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.comment"},
"998":{"name":"Latitude","table":"glpi_locations","field":"latitude","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.latitude"},"999":{"name":"Longitude","table":"glpi_locations","field":"longitude","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Location.longitude"},"requester":{"name":"Demandeur"},"4":{"name":"Demandeur","table":"glpi_users","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.Ticket_User.User.name"},"71":{"name":"Groupe demandeur","table":"glpi_groups","field":"completename","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.Group_Ticket.Group.completename"},"22":{"name":"Rédacteur","table":"glpi_users","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.users_id_recipient.User.name"},"observer":{"name":"Observateur"},"66":{"name":"Observateur","table":"glpi_users","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.Ticket_User.User.name"},"65":{"name":"Groupe observateur","table":"glpi_groups","field":"completename","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.Group_Ticket.Group.completename"},"assign":{"name":"Attribué à"},"5":{"name":"Technicien","table":"glpi_users","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.Ticket_User.User.name"},"6":{"name":"Assigné à un fournisseur","table":"glpi_suppliers","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.Supplier_Ticket.Supplier.name"},"8":{"name":"Groupe de techniciens","table":"glpi_groups","field":"completename","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.Group_Ticket.Group.completename"},"notification":{"name":"Notifications"},"35":{"name":"Suivi par courriel","table":"glpi_tickets_users","field":"use_notification","datatype":"bool","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","contains","notcontains"],"uid":"Ticket.Ticket_User.use_notification"},"34":{"name":"Courriel pour le suivi","table":"glpi_tickets_users","field":"alternative_email","datatype":"email","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Ticket_User.alternative_email"},"sla":{"name":"SLAs"},"37":{"name":"SLAs TTO","table":"glpi_slas","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.SLA.name"},
"30":{"name":"SLAs TTR","table":"glpi_slas","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.SLA.name"},
"32":{"name":"SLAs Niveau d'escalade","table":"glpi_slalevels","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.SlaLevel_Ticket.SlaLevel.name"},"ola":{"name":"OLA"},"190":{"name":"OLA TTO interne","table":"glpi_olas","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.OLA.name"},"191":{"name":"OLA TTR interne","table":"glpi_olas","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.OLA.name"},"192":{"name":"OLA Niveau d'escalade","table":"glpi_olalevels","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.OlaLevel_Ticket.OlaLevel.name"},"validation":{"name":"Validation"},"51":{"name":"Validation minimale nécessaire","table":"glpi_tickets","field":"validation_percent","datatype":"number","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.validation_percent"},"52":{"name":"Validation","table":"glpi_tickets","field":"global_validation","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.global_validation"},"53":{"name":"Commentaire de la demande","table":"glpi_ticketvalidations","field":"comment_submission","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketValidation.comment_submission"},"54":{"name":"Commentaire de la validation","table":"glpi_ticketvalidations","field":"comment_validation","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketValidation.comment_validation"},"55":{"name":"Statut de validation","table":"glpi_ticketvalidations","field":"status","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.TicketValidation.status"},"56":{"name":"Date de la demande","table":"glpi_ticketvalidations","field":"submission_date","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.TicketValidation.submission_date"},"57":{"name":"Date de la validation","table":"glpi_ticketvalidations","field":"validation_date","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.TicketValidation.validation_date"},"58":{"name":"Demandeur","table":"glpi_users","field":"name","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.TicketValidation.User.name"},
"59":{"name":"Valideur","table":"glpi_users","field":"name","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.users_id_validate.TicketValidation.User.name"},"satisfaction":{"name":"Enquête de satisfaction"},
"31":{"name":"Type","table":"glpi_ticketsatisfactions","field":"type","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals"],"uid":"Ticket.TicketSatisfaction.type"},"60":{"name":"Date de création","table":"glpi_ticketsatisfactions","field":"date_begin","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.TicketSatisfaction.date_begin"},"61":{"name":"Date de la réponse","table":"glpi_ticketsatisfactions","field":"date_answered","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.TicketSatisfaction.date_answered"},"62":{"name":"Satisfaction","table":"glpi_ticketsatisfactions","field":"satisfaction","datatype":"number","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketSatisfaction.satisfaction"},"63":{"name":"Commentaires","table":"glpi_ticketsatisfactions","field":"comment","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketSatisfaction.comment"},"followup":{"name":"Suivis"},"25":{"name":"Description","table":"glpi_itilfollowups","field":"content","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.ITILFollowup.content"},"36":{"name":"Date","table":"glpi_itilfollowups","field":"date","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.ITILFollowup.date"},"27":{"name":"Nombre de suivis","table":"glpi_itilfollowups","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.ITILFollowup.id"},"29":{"name":"Source de la demande","table":"glpi_requesttypes","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.ITILFollowup.RequestType.name"},"91":{"name":"Suivi privé","table":"glpi_itilfollowups","field":"is_private","datatype":"bool","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","contains","notcontains"],"uid":"Ticket.ITILFollowup.is_private"},"93":{"name":"Rédacteur","table":"glpi_users","field":"name","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.ITILFollowup.User.name"},"task":{"name":"Tâches"},"26":{"name":"Description","table":"glpi_tickettasks","field":"content","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketTask.content"},"28":{"name":"Nombre de tâches","table":"glpi_tickettasks","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketTask.id"},"20":{"name":"Catégorie","table":"glpi_taskcategories","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.TicketTask.TaskCategory.name"},"92":{"name":"Tâche privée","table":"glpi_tickettasks","field":"is_private","datatype":"bool","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","contains","notcontains"],"uid":"Ticket.TicketTask.is_private"},"94":{"name":"Rédacteur","table":"glpi_users","field":"name","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.TicketTask.User.name"},"95":{"name":"Technicien responsable","table":"glpi_users","field":"name","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.users_id_tech.TicketTask.User.name"},"112":{"name":"Groupe responsable","table":"glpi_groups","field":"completename","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.groups_id_tech.TicketTask.Group.completename"},"96":{"name":"Durée","table":"glpi_tickettasks","field":"actiontime","datatype":"timestamp","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketTask.actiontime"},"97":{"name":"Date","table":"glpi_tickettasks","field":"date","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.TicketTask.date"},"33":{"name":"Statut","table":"glpi_tickettasks","field":"state","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.TicketTask.state"},"173":{"name":"Date de début","table":"glpi_tickettasks","field":"begin","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.TicketTask.begin"},"174":{"name":"Date de fin","table":"glpi_tickettasks","field":"end","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.TicketTask.end"},"175":{"name":"Gabarit de tâche","table":"glpi_tasktemplates","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.TicketTask.TaskTemplate.name"},"stats":{"name":"Statistiques"},"154":{"name":"Délai de résolution","table":"glpi_tickets","field":"solve_delay_stat","datatype":"timestamp","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.solve_delay_stat"},"152":{"name":"Délai de clôture","table":"glpi_tickets","field":"close_delay_stat","datatype":"timestamp","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.close_delay_stat"},"153":{"name":"Délai d'attente","table":"glpi_tickets","field":"waiting_duration","datatype":"timestamp","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.waiting_duration"},"150":{"name":"Délai de prise en compte","table":"glpi_tickets","field":"takeintoaccount_delay_stat","datatype":"timestamp","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.takeintoaccount_delay_stat"},"linktickets":{"name":"Tickets liés"},"40":{"name":"Tous les tickets liés","table":"glpi_tickets_tickets","field":"tickets_id_1","datatype":"","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.Ticket_Ticket.tickets_id_1"},"47":{"name":"Tickets dupliqués","table":"glpi_tickets_tickets","field":"tickets_id_1","datatype":"","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.Ticket_Ticket.tickets_id_1"},"41":{"name":"Nombre de tickets liés","table":"glpi_tickets_tickets","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Ticket_Ticket.id"},"46":{"name":"Nombre de tickets dupliqués","table":"glpi_tickets_tickets","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Ticket_Ticket.id"},"50":{"name":"Tickets parents","table":"glpi_tickets","field":"id","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.tickets_id_2.Ticket_Ticket.Ticket.id"},"67":{"name":"Tickets enfants","table":"glpi_tickets","field":"id","datatype":"itemlink","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.tickets_id_1.Ticket_Ticket.Ticket.id"},"68":{"name":"Nombre de tickets enfants","table":"glpi_tickets_tickets","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Ticket_Ticket.id"},"69":{"name":"Nombre de tickets parents","table":"glpi_tickets_tickets","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Ticket_Ticket.id"},"solution":{"name":"Solution"},"23":{"name":"Type de solution","table":"glpi_solutiontypes","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.ITILSolution.SolutionType.name"},"24":{"name":"Solution","table":"glpi_itilsolutions","field":"content","datatype":"text","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.ITILSolution.content"},"38":{"name":"N'importe quel statut de solution","table":"glpi_itilsolutions","field":"status","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals"],"uid":"Ticket.ITILSolution.status"},"39":{"name":"Dernier statut de solution","table":"glpi_itilsolutions","field":"status","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals"],"uid":"Ticket.ITILSolution.status"},"cost":{"name":"Coût"},"48":{"name":"Coût total","table":"glpi_ticketcosts","field":"totalcost","datatype":"decimal","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketCost.totalcost"},"42":{"name":"Coût horaire","table":"glpi_ticketcosts","field":"cost_time","datatype":"decimal","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketCost.cost_time"},"49":{"name":"Coût - Durée","table":"glpi_ticketcosts","field":"actiontime","datatype":"timestamp","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketCost.actiontime"},"43":{"name":"Coût fixe","table":"glpi_ticketcosts","field":"cost_fixed","datatype":"decimal","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketCost.cost_fixed"},"44":{"name":"Coût matériel","table":"glpi_ticketcosts","field":"cost_material","datatype":"decimal","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.TicketCost.cost_material"},"problem":{"name":"Problèmes"},"200":{"name":"Nombre de problèmes","table":"glpi_problems_tickets","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Problem_Ticket.id"},"201":{"name":"Problème","table":"glpi_problems","field":"name","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals"],"uid":"Ticket.Problem_Ticket.Problem.name"},"202":{"name":"Statut","table":"glpi_problems","field":"status","datatype":"specific","nosearch":false,"nodisplay":false,"available_searchtypes":["equals"],"uid":"Ticket.Problem_Ticket.Problem.status"},"203":{"name":"Date de résolution","table":"glpi_problems","field":"solvedate","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.Problem_Ticket.Problem.solvedate"},"204":{"name":"Date d'ouverture","table":"glpi_problems","field":"date","datatype":"datetime","nosearch":false,"nodisplay":false,"available_searchtypes":["equals","notequals","lessthan","morethan","contains","notcontains"],"uid":"Ticket.Problem_Ticket.Problem.date"},"document":{"name":"Documents"},"119":{"name":"Nombre de documents","table":"glpi_documents_items","field":"id","datatype":"count","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains"],"uid":"Ticket.Document_Item.id"},"plugins":"Plugins","76665":{"name":"Statut - Motif attente","table":"glpi_plugin_fields_motifattentefielddropdowns","field":"completename","datatype":"dropdown","nosearch":false,"nodisplay":false,"available_searchtypes":["contains","notcontains","equals","notequals","under","notunder"],"uid":"Ticket.PluginFieldsTicketstatut.PluginFieldsMotifattentefieldDropdown.completename"}}

---

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

floripes

Member

Registered: 2023-01-06

Posts: 2

Re: help for query curl GLPI API

Thank, this will be very useful for me.