Overview
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.
Information
Environment
On-premise, Hosted, and AWS Cloud.
Important Information
- 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
Process
Follow these steps to resolve this issue:
- Check for the Application Database entries through Magic Query tool by checking
isdefault
column 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 isSELECT fieldid, name, isdefault FROM jiveprofilefield WHERE fieldid IN(5031, 5030, 5040);
- It is noted that
isdefault
values are showing as '1' instead of '0' for custom entries. An example result set looks like the following:
fieldid
name
isdefault
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, useUPDATE jiveprofilefield SET isdefault=0 WHERE fieldid IN(5031, 5030, 5040);
Confirmation
After applying these changes, you will notice the difference in the display of the profile field in UI, as indicated below:
- Before:
- After:
Comments
0 comments
Article is closed for comments.