PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/22/2008 5: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:544
Points:986


--
04/14/2008 4: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:544
    Points:986


    --
    06/26/2008 9: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:544
    Points:986


    --
    12/22/2008 5: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.


    December 2019 release now available by Rod Weir in Announcements with 0 replies A new release of HelpMaster is now available.  This release focusses mainly on stability, with an important fix for the Email Manager if using IM...

    Adjust the date range for displaying closed jobs in Explorer by Rod Weir in Using HelpMaster with 0 replies From tech support today... By default, the Explorer screen displays closed jobs that were closed in the previous month.  This interval can be ...

    October 2019 release now available by Rod Weir in Announcements with 0 replies A new release of HelpMaster is now available.  This release focusses on workflow stability, enhancements and other fixes. For a list of the ma...

    August 2019 release now available by Rod Weir in Announcements with 0 replies A new release of HelpMaster is now available.  This release has some great workflow improvements, new control set fields, a new manager feature, ...

    Allow staff to view all jobs, all skillgroups by Rod Weir in Installation, configuration and upgrading with 0 replies By default, staff members can only view and action jobs that are assigned to the skillgroup(s) that the staff member belong to.  Fine-level contr...

    December 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release focusses mainly on stability, with an important fix for the Email Manager if using IM...

    Adjust the date range for displaying closed jobs in Explorer by Rod Weir in Using HelpMaster From tech support today... By default, the Explorer screen displays closed jobs that were closed in the previous month.  This interval can be ...

    October 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release focusses on workflow stability, enhancements and other fixes. For a list of the ma...

    August 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release has some great workflow improvements, new control set fields, a new manager feature, ...

    Allow staff to view all jobs, all skillgroups by Rod Weir in Installation, configuration and upgrading By default, staff members can only view and action jobs that are assigned to the skillgroup(s) that the staff member belong to.  Fine-level contr...

    June 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release builds upon features and stability, particularly in the workflow, and change manageme...

    Change Management by Rod Weir in Using HelpMaster Change Management in HelpMaster is a relatively new feature that is evolving rapidly.  Based off live-use in small and large departments, our &qu...

    April 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release builds upon features and stability, particularly in the workflow, change management a...

    February 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release builds upon features and stability, particularly in the workflow and web portal. F...

    RE: Job Templates get a new config option for web-based jobs by Rod Weir in Web Portal, client self-service and remote access Just further to this topic....if using workflow to log a new job from a job that already contains control sets, and you are using the option to transf...