Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

How are the pull down lists populated in the Personnel Manager for fields such as Department, Hair Color etc? How to edit/remove entries from those lists.

Warning

Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support Services for assistance.


Issue

How is the department list populated and how to edit/delete a department from the list.

In the screen shot below the site has changed the name of a department from 'Technical Support' to 'Product Support', how to go about removing the old department name from the list.

Environment

Cyberstation

Cause

Documentation

Resolution

The 'Department List' is populated from the department column of the Personnel table, the Pernnel Manager walks the column and adds to the list any department name string that is not already present on the list.

Since the list is dynamically populated from tha database, to remove an entry from the list, all instances of personnel objects that have been assigned to that department must be changed until no personnel object remains with a department string equal to the string that we want removed from the list.

In cases where only a few personnel objects are assigned to the department string to be removed, we can manually edit those personnel objects and change the department.

In many cases the manual approach is not practical due to a large number of personnel objects that will need to be manually modified, in such cases the change can be made directly in the SQL database using the following query.

***** MAKE SURE TO HAVE A FRESH BACKUP OF THE DATABASE BEFORE MAKING ANY CHANGES DIRECTLY IN SQL ****

update personnel set department = 'Product Support' where department = 'Technical Support'--------------------------> To rename an entry on the list.

update personnel set department = NULL where department = 'ISIS'------------------------------------------------------------> To remove an entry on the list. Note the all personnel assined to ISIS department will now have a BLANK department

Tags (2)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-11 03:05 PM
Updated by: