Need help regarding a requirement. On Applications(cmdb_ci_appl) table we want to have a field called Security role as a drop down(not unique for all applications) with different values.Each Application will have different security roles and we want

[jyotsna1]

Hi All,

Need urgent help regarding a requirement.  On Applications (cmdb_ci_appl) table we want to have a field called Security role as a drop down(drop down values will not be unique for all applications) with different values. Each Application will have different security roles and we want to display these security roles on a catalog item form when an application (referenced to Application field on cmdb_ci_appl table) is selected.

Example application and their respective security roles as below. When Application is selected as 'Active Directory' on catalog form relevant security roles to be displayed under 'Security Role' field.

My question is how to populate 'Security Roles' for applications on cmdb_ci_appl table, once this data is sorted I can easily bring them on catalog form by referencing fields to cmdb_ci_appl table. Sicne the security roles are not unique for the applications, how do I populate them? Do I need to have another table to maintain these Security roles, if yes how can I populate them on cmdb_ci_appl table.

Anyone please through some light on this requirement.

Thank you!

[jyotsna1]

Hi Ankur,

I tired below reference qualifier, it did not work. It shows no matches found on catalog form

javascript: 'sys_idIN' + current.variables.security_roles.u_security_roles; // security_roles is variable name    and u_security roles is list field name on cmdb_ci_appl table

[Ankur Bawiskar]

Hi,

if this setup is in your PDI and you are ok to share url and some admin credentials please share.

if not then try to replicate it on your PDI and share the details.

if not then please check the 2nd variable is referring to that custom table only

Regards
Ankur

[jyotsna1]

Hi Ankur,

Second Variable (security_roles) is not referring to custom table, its referred to cmdb_ci_appl. As I need it to be dependent on Application variable (refers to cmdb_ci_appl table). Based on application selected, security roles form list fiedl which is on cmdb_ci_appl should populate.

[Ankur Bawiskar]

Hi,

This is how it should work.

So 1st variable refers to cmdb_ci_appl table.

2nd variable of type reference should refer to the custom table as that holds the roles values.

So when user selects 1 Appl then for the 2nd variable it would only show those roles from the custom table which are present on the "u_security_roles" field of cmdb_ci_appl table

If you want 2nd variable as list collector then add this in the variable attributes

ref_qual_elements=security_roles

Regards
Ankur

[jyotsna1]

Hi Ankur,

I changed the reference of 2nd variable to custom field and used below reference qualifier, still it shows no matches on catalog form

javascript: 'sys_idIN' + current.variables.security_roles.u_security_roles;