Deleting system codes, issues, problems etc that are linked to

Go to previous topic

Go to next topic

Last Post 12/22/2008 4:28 PM by Rod Weir

Deleting system codes, issues, problems etc that are linked to jobs, clients or other entities.

2 Replies

Author

Messages

Rod Weir
HelpMaster development team

Helpdesk Hall of Fame
Posts:555
Points:1017

4/14/2008 3:35 PM
The following was emailed to us by a HelpMaster Pro user If a user deletes an issue type from problem tree in Helpmaster Pro v7.5.184, do the jobs already closed with that issue type retain that issue? If not what does it change too? Yes, the jobs retain the issue. Whenever a job, client, asset, site or anything else in HelpMaster Pro links to a system code, and that system code is then deleted, the entity that was linking to it will still point to that system code. Behind the scenes, *the system code is only marked as deleted* - it isn't actually completely deleted from the database. This means that the system code will not appear in any of the drop-down boxes, or the problem hierarchy tree, so it can't be used again for new entities. However, any existing entities that are linked to it will display the code when they are viewed. There is an exception to this rule. If the system code has never been linked to anything, then it will be permanently deleted from the database. HelpMaster development team Check out the HelpMaster roadmap

Rod Weir
HelpMaster development team

Helpdesk Hall of Fame
Posts:555
Points:1017

6/26/2008 8:06 PM
Further to this information, The same principle applies also to other entities like clients, assets, site etc. If these things are linked to other entities, or to jobs, they won't actually be deleted outright from the database if you try to delete them - they will only marked as deleted. This means that if you open a job that was logged by or for a deleted client, you'll still the client as part of the job as normal. Deleted clients, assets, sites etc will not be displayed in any of the search screens. HelpMaster development team Check out the HelpMaster roadmap

Rod Weir
HelpMaster development team

Helpdesk Hall of Fame
Posts:555
Points:1017

12/22/2008 4:28 PM
Still further to this issue... "Deleted" system codes can be re-activated by changing the database field "IsDeleted" from a 1 to a 0. System codes are located in a table called "tblSystemCodes". Issues are located in "tblIssues", and other entities such as client, assets and sites can be found in "tblClient", "tblAssets" and "tblSite" respectively. Please note that direct manipulation of the HelpMaster Pro database should only be performed by an experience database administrator. Please make a backup of your database before performing any work of this type. HelpMaster development team Check out the HelpMaster roadmap