Changing lookup tables, help desk ticket statuses

Open discussion about our Alloy Navigator Express 5 application

Changing lookup tables, help desk ticket statuses

Postby MikaelJuul on Mon Nov 30, 2009 3:17 am

Hello,

I was wondering why i can't make changes to lookup tables, help desk ticket statuses ? - Some og them are marked as "System" and i'm not able to rename og delete them. The reason for changing these is that we are translating alle these fields to our local language, Danish.

For the Ticket Priorities the values also are marked as "System" but these i can change without any problems ?

Thanks in advance
Mikael Juul
MikaelJuul
Junior
 
Posts: 3
Joined: Mon Sep 14, 2009 7:41 am

Re: Changing lookup tables, help desk ticket statuses

Postby tallyho on Fri Dec 18, 2009 2:44 pm

You can't change it from the front-end but I was able to workaround it by updating the database directly.

The status codes for tickets are stored in the HD_TICKET_STATUS table if I recall.

I added my new status codes first, then replaced the old with new statuses in tickets using a SQL Update query, and finally zero'd the system flag so I could delete the one's I no longer needed.

Probably could have dropped the references first and updated everything but I know better now. :)


Cheers!
tallyho
Member
 
Posts: 11
Joined: Fri Aug 07, 2009 2:39 pm


Return to Alloy Navigator Express 5 Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron