How to change referenced tables on one reference field based on other dropdown values.

aastha3
Giga Contributor

I have a requirement where I have three variables   in service catalog

1. CI Type(select box) -> VM , Linux , ESX, JBOSS

2. CI Name (reference field)

3. Sys ID (single line text)

Now I want that whenever the CI type is changing the referenced table in CI Name   should change accordingly with their respective tables.

like for vm ->cmdb_ci_vm similarly for others as well.

My end result is to fetch selected ci name's sys id .

For changing reference field script include and onchange client script will be required .

for sysid fetch also onchange or onsubmit script will be required   . Not sure about this

Please help me with the correct code for my requirement .

Let me know if you need any further information.

1 ACCEPTED SOLUTION

Please replace-


var type=current.u_type;



with


var type=current.variables.u_type;



It should work now. Best of luck.


View solution in original post

25 REPLIES 25

Thats great worked I will include other also in if else code .


Please last favour provide the code to fetch sys id of the CI .



I will be really grateful to you.


Manoj Kumar16
Giga Guru

To provide the sys_id ?   where do you want to fetch the sys_id ? in script include ? or any client script ? what is the requirement ?


See like this in the screenshot



find_real_file.png



Once the ci name is selected by the user its sys id should come in the sys id variable present below .


Any thing would do be it client script or script include . They just want to have the end result the sys id population.



Please help me with the code.



find_real_file.png


Ok no problem I will help you with the code only if you mark one of my answers correct and the rest of them helpful.... is that fair ?


Anyways I would have done that. No need to mention You are really helpful