Fix jar to avoid orphan entries in APPROVALSTAGE Table during change deletion

Fix jar to avoid orphan entries in APPROVALSTAGE Table during change deletion

The fix jar is given to delete the orphan entries in APPROVALSTAGE table during the deletion of change

Ticket:

Files Modified :
<SDP>\helpdesk\src\library\com\manageengine\servicedesk\change\db\CMQueryUtil.java
    
Jar Compatibility :
    11120 - SDP Build Version

          • Related Articles

          • Change approval

            SELECT chdt.changeid                           AS "Change ID",         chdt.title                              AS "Title",         orgaaa.first_name                       AS "Change Requester",  ...
          • Fix for SD-89148 (11126)

            The jar has a fix for SD-89148 which is already released in 11129. NOTE: Please ask the cx to upgrade which is the first most preferable option, if not go for this temporary patch Files Modified : ...
          • How to change the Change ID sequence

            In ServiceDesk Plus by default, the Change ID starts from 1. Let us take an example to change the Change ID to start from 5001. We need to execute a query in the database to create a dummy Change with ChangeID 5000 and then restart the application ...
          • How to change the Problem ID sequence

            In ServiceDesk Plus by default, the Problem ID starts from 1. Let us take an example of how do I change the Problem ID to start from 5001 We need to execute a query in the database to create a dummy Problem with ProblemID 5000 and then restart the ...
          • Change roles

            SELECT chdt.changeid               "Change ID",         chdt.title                  "Title",         orgaaa.first_name           "Change Requester",         ownaaa.first_name           "Change Owner",  ...