Forum GLPI-Project

PhillF

Member

Registered: 2020-05-18

Posts: 7

Adding Alphanumeric Characters to Ticket IDs [Behaviors Plugin?]

Hello All,

I am trying to add alphanumeric prefixes for CHG (CHG) and and Tickets. If I could do the for Incidents (INC) and Requests (REQ) separately that would be great. I want my techs to be able to look at a ticket ID an know what it is without even opening it. This is also useful for Outlook inbox sorting rules. The other reason is one of workflow. Emails will come in as REQs and depending on the situation get created as a linked CHG or INC where appropriate.

I have tried modifying the "tickets_id_format" and "changes_id_format" to have \I\N\C and \C\H\G respectively but that was a negative result nor does it solve the separate INC & REQ issue.

Thanks in advance for any assistance rendered.

Mysterehyde

Member

Registered: 2020-05-18

Posts: 24

Re: Adding Alphanumeric Characters to Ticket IDs [Behaviors Plugin?]

I am also interested in your solution if you find one ;-)

What was the result you had as "negative result" ?

PhillF

Member

Registered: 2020-05-18

Posts: 7

Re: Adding Alphanumeric Characters to Ticket IDs [Behaviors Plugin?]

What was the result you had as "negative result" ?

Either of the following depending on my approach:
1) Break the settings page of the Behaviors plugin to the point of inoperability.
2) Interface shows prefix (ie. "\C\H\G") but prefix isn't actually included.

makeijan

Member

From: Pontevedra, Galicia

Registered: 2008-01-29

Posts: 757

Website

Re: Adding Alphanumeric Characters to Ticket IDs [Behaviors Plugin?]

Hi,

Ticket_ID are integers. No chance for a text here.
You might create a plugin to add a "secondary ticket ID" you could name whatever way you want, but that will be
Maybe you have the influence of MsSQL solutions were an Alphanumeric Key may be used. This is not possible in MySQL

Regards,

---

Our GLPI developments
Gapp - A GLPI app
Prove your GLPI knowledge in this fun trivia quizz

PhillF

Member

Registered: 2020-05-18

Posts: 7

Re: Adding Alphanumeric Characters to Ticket IDs [Behaviors Plugin?]

You might create a plugin to add a "secondary ticket ID" you could name whatever way you want, but that will be

I like your idea. I may just tweak around with the behaviors plugin and get it to take what it generates and append the desired prefix and insert that into a new column in each of the tables. Not quite sure what that column should be called, maybe tickets_id_prefixed.

Thoughts?

Mysterehyde

Member

Registered: 2020-05-18

Posts: 24

Re: Adding Alphanumeric Characters to Ticket IDs [Behaviors Plugin?]

There is a pluggin that permit to add some personalized fields, maybe it can help you waiting for your own plugin? It's simply "fields" I guess.

but I think you already are in another way ^^