Administrators are not able to delete Custom Profile Fields in Admin Console. For instance, in the example below, custom fields highlighted in yellow do not have the delete option.
This article shares the resolution of this issue.
Important Note: If you are unsure about securely performing the steps mentioned in this article, always make a backup before making any changes or reach out to support for more help.
On-premise, Hosted, and AWS Cloud.
- This change is immediate and does not require a restart. However, making a change in the database is always a risky operation, and we recommend taking the necessary precautions: testing the change in UAT and performing a database backup is the bare minimum.
- To perform the database update in AWS (Amazon Web Services) based Hosted and Cloud Jive environment, please contact us.
- On-premise customers should perform the change on their own
Follow these steps to resolve this issue:
- Check for the Application Database entries through Magic Query tool by checking
isdefaultcolumn in the table with a simple query like this:
SELECT * FROM jiveprofilefield;
- Make a note of field identifiers (
fieldid) in question.
- Run another query:
SELECT fieldid, name, isdefault FROM jiveprofilefield WHERE fieldid IN(<fieldid1>, <fieldid2>, <fieldid3>);For the fields above, an example is
SELECT fieldid, name, isdefault FROM jiveprofilefield WHERE fieldid IN(5031, 5030, 5040);
- It is noted that
isdefaultvalues are showing as '1' instead of '0' for custom entries. An example result set looks like the following:
5031 careermanager 1 5030 discipline 1 5040 regionalDisciplineLead 1
- Make the change in the application database to correct the entries by using
UPDATE jiveprofilefield SET isdefault=0 WHERE fieldid=<fieldid in question>;To update the values for all of the above custom fields in a single query, for example, use
UPDATE jiveprofilefield SET isdefault=0 WHERE fieldid IN(5031, 5030, 5040);
After applying these changes, you will notice the difference in the display of the profile field in UI, as indicated below: