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
Files Modified :
Jar Compatibility :
11120 - SDP Build Version
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 ...
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Change Requester", ownaaa.first_name "Change Owner", ...