Creating a sys_relationship between a table and a database view using OR condition
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2023 07:52 PM
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