lookup select box showing only sysid

[JagjeetSingh]

Hi,

I have a field "MSSQL Instance" which is referring table "cmdb_ci_db_mssql_instance" table.

And there is another field "database" where i need to populate all databases running on the particular instance name selected in "MSSQL instance" field as above.

to achieve this i am setting my second field "database" as lookup select box and referring the table "cmdb_rel_ci" and in lookup value field i am choosing "Child". The idea is to set the reference qualifier to match the parent with MSSQL instance field and then show relevant child values.

I am stuck at both the steps. In database fields i am not getting correct values. It is showing only sysIDs.

Also below is my reference qualifier which doesn't seems to work.

javascript:'parent=' + current.variables.mssql_instance

help!

[Ankur Bawiskar]

Hi,

Did you set the variable attributes for the lookup select box

ref_qual_elements=mssql_instance

Regards
Ankur

[Ankur Bawiskar]

@Jagjeet Singh 

please share your lookup select box variable configuration

Regards
Ankur

[JagjeetSingh]

This is my configuration Ankur. For now i am not even able to populate the child values in field. Getting SysID's there. I am using this in catalog item.

[Ankur Bawiskar]

Hi,

the table "cmdb_rel_ci" doesn't have display=true for any of the field

Can you try to set the Lookup label field as Child for that lookup select box variable

I could see it is empty

Regards
Ankur