How do I reference the Subsidiary on a customer record
d
Dmitry Masanov
08/04/2025, 1:51 PM
Using customersubsidiaryrelationship table, for example:
select BUILTIN.DF(C.companyname) as "companyname", BUILTIN.DF(S.subsidiary) as subsidiary from customer C join customersubsidiaryrelationship S on (C.id = S.entity and S.isprimarysub = 'T')