Concerning a Query Builder statement, mixing addPk() in addition to other columns (even from joined tables) should work ok, is it?
- Code: Select all
var query = datasources.db.hades.profile_definitions.createSelect();
var pd = query.columns;
query.result
.addPk()
.add(pd.assessment_code_exam_mark)
.add(a.discriminator);
/** @type {QBJoin<db:/hades/assessments>} */
var join = query.joins.add('db:/hades/assessments', JSRelation.LEFT_OUTER_JOIN);
var a = join.columns;
join.on
.add(pd.assessment_code_exam_mark.eq(a.code));
query.where
.add(pd.level_number.eq(datasetExamSubjects.getValue(j, 4)))
Regards,