persons - persons_access_right_groups - access_right_groups. The cardinality between them is 1:m and m:1.
Is it possible to travel via the 2 relations from table persons to table access_right_groups in a QB statement?
What definition needs {QBJoin <...}?
My query looks (simplified) like
- Code: Select all
var query = datasources.db.hades.persons.createSelect();
var p = query.columns;
/** @type {QBJoin<db:/hades/persons_access_right_groups>} */
var join = query.joins.add('persons_to_persons_access_right_groups.persons_access_right_groups_to_access_right_groups', 'arg');
var arg = join.columns;
query.result
.add(p.id)
.add(arg.id);
query.where
.add(p.usr.eq(username))
.add(p.pwd.eq(password));
The error is:
- Code: Select all
Cannot find relation 'persons_to_persons_access_right_groups.persons_access_right_groups_to_access_right_groups'
Regards,