How to adjust MRVS grid display on a catalog item?

[EstherJ]

I'm a new catalog manager and am trying to build an access request form. We've got a little under 30 tools, with just under 200 different levels of permission. Some of these permissions have restrictions based on the team to which the user belongs. I built a custom table that contains among other things, the fields u_tool, u_permission, u_restriction (which is a reference lookup to the Services table), and u_notes. All permissions are associated with a tool, but only some of them are restricted to specific teams. The others should be selectable by anyone.

I have a catalog item where the requester identifies to which team they belong (u_team). My goal is to use an MRVS to present them only with the valid options (global or team-restricted) from which they can select the access they want/need. They select the tool and permission, and there is a look up to see if there are any notes associated asking for additional information. 

Based on a bunch of googling and Community reading, I seemed to need a Script Include to pass the variable (u_team) from the catalog item to the MRVS and a Catalog Client Script to populate a single-line text field (u_lookup) in the MRVS with the sys ID of the restriction. The other fields in the MRVS are lookups to my backend table: u_tool, u_permission, and u_notes. I added a Reference qualifier on my u_permission field in the MRVS of javascript:'u_tool=' + current.variables.tool + '^u_restriction=' + current.variables.lookup + '^ORu_restrictionISEMPTY';  

I did get the above to work, though do not like how it displays the MRVS grid in the catalog item. The documentation I'm finding all seems out-dated, so I'm hoping there's something new available. Can I 1/ hide the team from the MRVS grid (it's already hidden in the modal), and 2/ if it can't be hidden, is there a way to change it from the Sys ID to an acronym field on the Service that is being looked up?

Also, is there a way to make the Notes field wider in the grid? Right now, everything is squished due to the Sys ID. TYA!

#catalog #request #mvrs

[Ankur Bawiskar]

@EstherJ 

you can't hide variable in this place in MRVS

You can't shrink/expand the columns here

Why it shows Sys ID-> on the table being referred you should mark Display=True for the Acronym field

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@EstherJ 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[EstherJ]

Hi, Ankur. Apologies for not getting back to you. Where would I "mark Display=True for the Acronym field"? My u_backend table has a reference to the cmdb_ci_service table for the item I am matching against. (The sys_id is the Service's sys_id, and u_acronym is a field on the cmdb_ci_service table.)

[UdaraW]

You might find the "Hide on grid" field handy for this. If you select it, the variable doesn’t appear on the MRVS grid. However, this is a new field introduced in the Australia release.

More info:
Create a service catalog variable • Australia ServiceNow AI Platform Capabilities • Docs | ServiceNo...