Forum GLPI-Project

Valmir

Member

Registered: 2023-04-03

Posts: 1

Ticket status in database

I'm trying to generate reports using metabase connected to the GLPI database, when i select from glpi_tickets table there is a row called status, it should be open, closed... instead it is numbers, 1,2...5,6.

The question is, is there a table or some sort of info that could help decode which status number is which status type?

pschivo

Member

Registered: 2023-12-19

Posts: 5

Re: Ticket status in database

Hi there, same thing happened to me and i realized it might be hardcoded. Status are correlative to the web console:

1 New
2 Processing (Assigned)
3 Processing (Planned)
4 Pending
5 Solved
6 Closed