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,

Thank you! Changing the length of import field helped. But I'm unable to bring security roles field data on to catalog form.

I have 2 variables on catalog form Application and Security Roles. Application is referenced to cmdb_ci_appl table, please help how could I get Security roles mapped to particular application display when Application is selected.

[Ankur Bawiskar]

Hi,

Do you want to load data to field of cmdb_ci_appl table or for RITM records?

Regards
Ankur

[jyotsna1]

HI Ankur,

It is on end user catalog (sc_cat_item) form. I have 2 variables Application and Security Roles.

When end user selects Application Security roles variable should show relevant roles mapped for the application.

[Ankur Bawiskar]

Hi,

so for this you will require advanced ref qualifier for the 2nd variable

Ensure you give the name of the list field on cmdb_ci_appl here

javascript: 'sys_idIN' + current.variables.<list_field>

Regards
Ankur

[Ankur Bawiskar]

@jyotsna 

Hope you are doing good.

Let me know if I have answered your question.

If so, please mark appropriate answer as correct & helpful to close the thread.

If not, please let us know if you need some more assistance.

Regards
Ankur