My Record Producer (Service Portal Form) has this drop-down "Please select your chancellor." Drop down contains a list of people.
- A script include pulls from the sys_user_grmember table, a list of people from a group "chancellor" and returns a json consisting of name and value pairs. The name includes the name of the cabinet member, and the sys_id contains the sys_id of the cabinet member's sys_id.
- Catalog Client Script uses GlideAjax to populate the menu, using the name and value pairing.
- On the back-end, that sys_id gets stored into a reference field. The reference is sys_user. To the business users who use the back-end record, they see the chancellor's name, but the table stores the sys_id.
- My workflow uses that sys_id for the approval.
The problem I'm trying to solve:
When the approver clicks on "My Approvals", he's taken to a summary of the ticket.
He sees a sys_id in place of the cabinet member.
For example:
We want the cabinet member's name to appear here instead of the sys_id.
Our goal is to remove this field from the "My Approvals Summary Page"...
WITHOUT
having to modify the sp_widget table.
We do not want to touch this. We do not want to modify the Body HTML template or the Server Script. No code updates here.
So far I have tried the following recommendations from CoPilot. None of these work.
- In the attributes field of the data dictionary, add attribute "portal_hide=true." This doesn't work.
- Setting up a display business rule.
(function executeRule(current, previous /*null when async*/ ) {
if (gs.isInteractive() && gs.getSession().isLoggedIn()) {
var isPortal = gs.getSession().getClientData('glide.ui.view') == 'sp';
if (isPortal && current.getTableName() == 'x_losls_ogac_pe_document_transfer_request') {
current.ogac_dcr_chancellor_cab_mem = '';
}
}
})(current, previous);I couldn't get this to work either.
