Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > Change the Web Help Desk ticket numbering

Change the Web Help Desk ticket numbering

Table of contents
Created by Renato Quejas, last modified by Caroline Musindi on Jul 14, 2017

Views: 170 Votes: 0 Revisions: 5

 

Overview

This article will show you on how to change the ticket numbering or ticket starting number.

Environment

All WHD versions

Steps

For Embedded PostgreSQL:

  1. Run the pgAdmin3.exe (as admin) under ..\Program Files\WebHelpDesk\pgsql9\bin.
  2. Go to File > Open pg_hba.conf under ..\Program Files\WebHelpDesk\pgsql9\data.
  3. Double click the line host all all 127.0.0.1/32 password.
  4. Change the method from 'password' to 'trust' then save (do not close the pgAdmin3.exe). 
  5. Restart the Web Help Desk PostgreSQL Embedded Database service (start > run > services.msc).
  6. From pgAdmin3.exe, go to File > Add Server > add the following then click OK.
    • Name: whd
    • Host: 127.0.0.1
    • Port: 20293
    • Maintenance DB: choose 'template1'
    • Username: whd
    • Password: <leave as blank>
  7. Expand Databases and you should see the 'whd'.
  8. Expand the Schemas > Sequences > and look for job_ticket_seq.
  9. Right click job_ticket_seq > Properties.
  10. Under Definition tab, you will see the current value or last number of the ticket. 
    Change the current value or ticket number and this will be the starting ticket number. 
  11. Click OK.

 

MySQL/MSSQL

Select the [EO_PK_TABLE] table then run the SQL query below: 

UPDATE [dbo].[EO_PK_TABLE] SET PK='<ticket number>' where NAME='JOB_TICKET'

 

Last modified
14:42, 14 Jul 2017

Tags

Classifications

Public