Cross-product entitySelection

Qodly Qodly Studio
1

this is obvious in 4d, but not in qodly:
in a 1:N:1, how do i get the N entity selection if i have the two 1’s?
something like
student : studentClassroom : classroom
i have the student and the classroom

i guess i can do it indirectly, by using the ID attribute in each dataclass, instead of the related attribute in the studentClassroom dataclass, something like
n = ds.studentClassroom.query("student.ID=:1 AND classroom.ID=:2", studentID, classroomID)

2

Hi,

I you have a student entity and a classroom entity,

you can make an AND between the two studentClassroom entity selections ?

Like:

result = student.studentClassrooms.and(classroom.studentClassrooms)

2 Likes
3

i hadn’t thought about doing it like that. that would be another way.