Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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 Rodim Suarez on Mar 08, 2017

Views: 180 Votes: 0 Revisions: 4

 

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
21:54, 7 Mar 2017

Tags

Classifications

Public