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) > Restore a deleted Request Type or Problem Type from an embedded PostgreSQL database

Restore a deleted Request Type or Problem Type from an embedded PostgreSQL database

Table of contents

Overview

This article describes how to restore a deleted Request Type (Problem Type) from an embedded PostgreSQL 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. Open your WebHelpDesk home directory.
    Apple® OS X®: /Library/WebHelpDesk    
    Microsoft Windows®: \Program Files\WebHelpDesk    
    Linux: /usr/local/webhelpdesk
  2. Navigate to pgsql9\bin.
  3. Double-click pgadmin3.
  4. Click File > Add Server.
  5. Complete the fields in the New Server Registration window, and then click OK. 
    • Name: whd
    • Host: localhost (or the IP Address)
    • Port: 20293
    • Maintenance DB: postgres
    • Username: whd
    • Password: whd
  6. Expand Databases and highlight the whd database.
  7. Click the SQL magnifying lens icon open the Query Tool or SQL Editor.
  8. Type the scripts or commands that you want to run.
  9. Click Play or Execute.
  10. To view all deleted Request Types, execute:
    SELECT problem_type_name, problem_type_id FROM whd WHERE Deleted='1' 
    To restore the deleted Request Type, execute: 
    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
11:04, 27 Sep 2017

Tags

Classifications

Public