I am facing problems trying to add to the universe the service contracts and related CI's. The problem is that the table that related contracts and ci's (sdsc_map) contains only the persid of the resource (like 'nr:KASJSDKSDKASJKD'), and the resource table (nr) only contains id ( in the form of uuid's) and I can not see the way to relate both fields. I have tryed complex joins (sdsc_map.map_persid = 'nr.' + upper (dbo.hex(nr.id)), derived tables, everything, but nothing works.
I have also opened several tickets with support, but without luck until the moment.
Any advice will be greatly appreciated.