Forum GLPI-Project

Stephanie

Member

Registered: 2017-11-02

Posts: 26

Ticket Template ##problem.storestatus## Status Value in Database

Hello,

So I am editing Ticket Templates and I can see the "Show list of available tags", it is very helpfull for me but there is one row of it I dont understand:

Tag: ##problem.storestatus##Single Value

Label: Status Value in Database

Event: All

Type: Single Value

Possible Values: 1,7,2,3,4,5,8,6

I do understand what is it suppose to do, but I dont know the meaning of thoose numbers. I assume they are indicating state that the ticket is in (I believe 6 is for resolved tickets).

I would like to know what theese numbers mean so I can use them properly.

I am not a programmer, but I want to know as much as possible.

Thank you for your help.

donutsNL

Member

Registered: 2022-01-12

Posts: 7

Re: Ticket Template ##problem.storestatus## Status Value in Database

Its the integer value stored in the glpi database, glpi_tickets table describing the status of the ticket.

mysql> use glpi_version_10
mysql> select status, name from glpi_tickets;
+--------+-------------------------------------------------+
| status | name                                            |
+--------+-------------------------------------------------+
|      1 | Ticket New      |
|      2 | Ticket Processing (Assigned)           |
|      3 | Ticket Processing (Planned)                      |
|      4 | Ticket Pending   |
|      5 | Ticket Solved     |
|      6 | Ticket Closed     |
+--------+-------------------------------------------------+