Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > How to unmerge Web Help Desk tickets

How to unmerge Web Help Desk tickets

Table of contents

Overview

This article describes how to unmerge Web Help Desk tickets through the Web Help Desk database (including PosgreSQL, Microsoft® SQL Server®, and MySQL). 

Environment

  • All WHD versions
  • All Windows Server versions
  • All Linux versions
  • All OS X and macOS versions

Steps

  1. Run the following command to locate a merged ticket.
    SELECT MERGED_PARENT_TICKET_ID FROM JOB_TICKET WHERE JOB_TICKET_ID = <TICKETID>
  2. Run the following command to unmerge the tickets:
    UPDATE JOB_TICKET SET MERGED_PARENT_TICKET_ID = NULL WHERE JOB_TICKET_ID = <parentID>

 

 

Last modified

Tags

Classifications

Public