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!

[Ankur Bawiskar]

Hi,

Do you have records in that custom table which store the values?

Also the App which you have selected has which roles?

Is the 2nd variable of type reference or list collector

Regards
Ankur

[jyotsna1]

Hi Ankur,

Yes, I have values in my custom table. Also application which I have selected also has roles added to it.

2nd variable type is reference and referenced to my custom table.

1st variable type is reference and referenced to cmdb_ci_appl table.

[Ankur Bawiskar]

Hi Jyotsna,

then it should work.

Did you check the user you are using for testing has READ access to that custom table?

Did you check with admin user?

Regards
Ankur

[jyotsna1]

Hi Ankur,

I have been checking with admin access, still it shows no matches found on Security Roles variable on catalog form.

My concern is 2nd variable(Security roles) is dependent on 1st variable (application) and both are referenced to different tables but the relationship between these 2 variables holds only on Application(cmdb_ci_appl) table.

As custom table will just hold Security roles values, these is no mapping here for applications.

[Ankur Bawiskar]

Hi,

since your 1st variable refers to cmdb_ci_appl and it has the list field which stores the roles sys_id

the 2nd variable should show only those roles which are present on the appl record

can you help if this is in your PDI and you are ok to share url and some admin credentials to check

Regards
Ankur