PrevPrev Go to previous topic
NextNext 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
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Rod Weir
HelpMaster development team
Helpdesk Hall of Fame
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
    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
    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
    You are not authorized to post a reply.


    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

    RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

    New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...