Hello All,
1. I have created a ServiceNow Catalog(Please find the below screenshot)
In the Above attribute LO(core_business_capability_l0), L1(sub_business_capability_l1) and L2(sub_business_capability_l2), whenever are getting the value from cmdb_ci_business_capability table(find the screenshot)
L1 is taking the parent value of L0 and showing it in the L1 field(Advance reference qualifier is used) and again L2 taking the parent value of L1 and put it in the L2(Please find the screenshot)
2. Now taking the Parent value from cmdb_ci_business_capability table and put it in the cmdb_rel_ci table(find the below screenshot).
3. Now take the Child from cmdb_rel_ci table and In Catalog Item show the child name only in Business Application name(business_application_name)
Note: Business Application name(business_application_name) is taking the value from table cmdb_ci_business_app.
The relationship of cmdb_ci_business_capability and cmdb_rel_ci table is of Parent.
The relationship of cmdb_rel_ci and cmdb_ci_business_app table is of Child.
Question is:
1. Whenever L0 is not empty and L1 and L2 is empty then in Business Application name(business_application_name) Take the value of L0
2. Whenever L0 and L1 is not empty and L2 is empty then in Business Application name(business_application_name) Take the value of L1
3. Whenever L0, L1 and L2 is not empty then in Business Application name(business_application_name) Take the value of L2.
Please Help me to achieve the scenario
