What is the table when we define 'Depends on' relationship?

[srath]

Hi there,

I have created a 'Depends on' relationship for business services as shown in below figures.

I want to know the table where these relationship is getting stored.

I have a requirement like,we need to have a reference field 'Service' (which refers to business services) on incident form.

Another reference field 'Sub-service' should be present on the form. On clicking search icon for this field, list of all the services which are dependent on the selected service should be available.

[AnishSasidharan]

Relationships between CI's are stored in CI Relationship table.   However, you have a requirement to create a two reference fields 'Service' and 'Sub-service'.   Populate the two fields with all the ci's which you are expected to show.

Based on the selection of 'Service', populate the 'Sub-service' by creating a reference qualifier. I am not sure this is what you are expecting.

Thanks,

Anish

[srath]

Thanks Anish..for your response.

Would you help me on reference qualifier for 'sub-service'..what I need to do in reference qualifier make available only the dependent business services for 'sub-service' reference field??

[AnishSasidharan]

If you map the 'Service' and 'Sub Service' with CI Relationship table (cmdb_rel_ci), it will list out all the relationships which was created for all the CI's.

Hope the below link will help you to create the dynamic reference qualifier based on the selection of 'Service',

Dynamic Reference Qualifier for KB articles

so qualifier should be like this

parent=current.service;

Thanks,

Anish

[Kalaiarasan Pus]

it gets stored in cmdb_rel_ci