how to get association data in using database connector
0
Hi Team, I am using database connector to get data from an external database. In that database I have association with Account To Role-[ Reference Set] How can I get the user role data of a particular account using query? I am using the below query but it does seem to work. The user role association is coming as empty. select account.email as "Email", z.lastlogin as "LastLogin" , r.name as "Name" from (((Administration$Account account inner join System$user z on z.id=account.id) inner join System$userroles ur on z.id=ur.System$userid) inner join System$userrole r on ur.System$userroleid=r.id) where account.email is not null