Dot walking on database view

[Dotychczas]

Hello experts,

I'm creating DB view connecting cmdb_ci_service and kb_knowledge. On cmdb_ci_service I can dot walk through parent to get to APM ID field:

user want to run report on DB view and use column Parent.APM ID. How this can be achieved? Do I need to add "Parent table" to DB view?

Thanks in advance.

[Saurav11]

Hello,

Can you show the configuration on how you joined cmdb service abd kb knowledge table then ti would be easier to assist you

[Dotychczas]

I'dont know how this helps as I just want to add one dotwalked field, but here you go.

db config:

service:

KB:

[Saurav11 · Accepted solution]

I see you have added the individual fields separately for both the tables, you need to add parent to the service field list then you will be able to dot walk the field.

Please mark answer correct/helpful based on Impact.