SCCM integration and orm.xml file - using other than primary key defining attribute values
I am not able to get data from table, which has a different primary key than basic table.
The table v_R_System has the ResourceID as the primary-key and all secondary tables are linked with this key.
But now I should be able to fetch data from table v_R_User and the only way to link v_R_System and v_R_User is to use the User_Name0 field.
If I use sql query, it is like this: v_R_User.deparmentNumber0 from v_R_User join v_R_System on v_R_User.User_Name0=v_R_System.User_Name0
Can someone give me some advice how to configure this in orm.xml file.