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) > Restore deleted Request Type or Problem Type

Restore deleted Request Type or Problem Type

Table of contents
Created by Renato Quejas, last modified by Rodim Suarez on Mar 08, 2017

Views: 19 Votes: 0 Revisions: 4

Overview

This article will show how to restore the deleted Request Type (Problem Type) from the database. 

Environment

All WHD versions

Steps

If you are using the embedded PostgreSQL database, you can follow the steps below to connect and run the sql command:

  1. Go to ..\WebHelpDesk\pgsql9\bin > run pgAdmin3 > File > Add Server.
  2. Add the following then click OK.
    • Name: whd
    • Host: localhost (or the IP Address)
    • Port: 20293
    • Maintenance DB: postgres
    • Username: whd
    • Password: whd
  3. Expand Databases and highlight the whd database.
  4. Click the SQL magnifying lens icon open the Query Tool or SQL Editor.
  5. Type the scripts or commands that you want to run then click the play icon or Execute button.
  6. To view all deleted Request Types, run the command below:
    SELECT problem_type_name, problem_type_id FROM whd WHERE Deleted='1' 
    To restore the deleted Request Type, run the command below: 
    UPDATE problem_type SET Deleted='0' WHERE problem_type_id='<problem type id>' 
    For example, The Request Type (Problem Type) ID that you want to restore is 12. 
    UPDATE problem_type SET Deleted='0' WHERE problem_type_id='12' 

 

Last modified
19:39, 7 Mar 2017

Tags

Classifications

Public