Creating a sys_relationship between a table and a database view using OR condition

Camila Godoy
Tera Expert

Hello - I am trying to create a relationship between the business application and a database view table containing the left join.
I am trying to reproduce this situation: ba_sys_id=[sys_id]^ORba2_sys_id=[sys_id]

So I have a relationship entry where:

Applies to table: cmdb_ci_business_application

Query from table: u_database_view_with_left_join

Then I have the Query with:

(function refineQuery(current, parent) {
	
    var qc1 = current.addQuery('sys_id', parent.ba2_sys_id);
    qc1.addOrCondition('sys_id', parent.ba_sys_id);

})(current, parent);

 

This is not working. Any tips on what I could modify?
Thank you!

0 REPLIES 0