Database view and Dot walking

[JJ1]

Hi All,

I am trying to create a view between 2 tables - cmdb_ ci_computer and sc_task where the condition should be requested_for   (sc_task/Req) = cmdb_ci computer_u_user (custom field which refers to user form)

What should be the database view criteria ?

I created a view with view tables sc_task and cmdb_ci_computer

ci prefix for CI computer table

stsk prefix for sc_task table

Where clause on cmdb_ci_computer is     "   ci_u_user =     stsk_request_item.request.requested_for" but it looks like dot walking does not work ?

[telmo]

Hi Mathias,

If not all incidents have the location set, then set the "Left join" flag when you define the "cmn_location" within the Database View.

Telmo

[mathiasjohansso]

This worked great! Thank you!

[vidyasnpractice]

above solution worked. thank you

[JJ1]

Thanks Sergiu,

I will try this option.