te assignments eg if LEFT JOIN CourseGroupMember ON CourseGroupMember.cgmUid = (SELECT CourseGroupMember.cgmUid FROM CourseGroupMember WHERE CourseGroupMember.cgmPersonUid = EnrolledStudentPersonUids.enrolledPersonUid AND CourseGroupMember.cgmSetUid = :cgsUid ORDER BY CourseGroupMember.cgmLct DESC LIMIT 1) WHERE (:activeFilter = 0 OR :activeFilter = EnrolledStudentPersonUids.isActive) /* * Begin permission check - must have course view members permission, or active * user must be in the same group */ AND ( (( /* If the accountPersonUid is the owner of the course, all permissions are granted */ (COALESCE( (SELECT _Clazz_Permission.clazzOwnerPersonUid FROM Clazz _Clazz_Permission WHERE _Clazz_Permission.clazzUid = :clazzUid), 0) = :accountPersonUid) /* If there is a CoursePermission entity that is for the course as per the clazzUid parameter that is granted to the person directly or to the enrolmentRole that the person has in the course, then permission is granted. */ OR EXISTS(SELECT CoursePermission.cpUid FROM CoursePermission LEFT JOIN ClazzEnrolment ClazzEnrolment_ForAccountPerson ON CoursePermission.cpToEnrolmentRole != 0 AND ClazzEnrolment_ForAccountPerson.clazzEnrolmentUid = (SELECT COALESCE( (SELECT _ClazzEnrolment_AccountPersonInner.clazzEnrolmentUid FROM ClazzEnrolment _ClazzEnrolment_AccountPersonInner WHERE _ClazzEnrolment_AccountPersonInner.clazzEnrolmentClazzUid = CoursePermission.cpClazzUid AND _ClazzEnrolment_AccountPersonInner.clazzEnrolmentPersonUid = :accountPersonUid AND _ClazzEnrolment_AccountPersonInner.clazzEnrolmentActive ORDER BY _ClazzEnrolment_AccountPersonInner.clazzEnrolmentDateLeft DESC LIMIT 1), 0)) WHERE CoursePermission.cpClazzUid = :clazzUid AND (CoursePermission.cpToPersonUid = :accountPersonUid OR CoursePermission.cpToEnrolmentRole = ClazzEnrolment_ForAccountPerson.clazzEnrolmentRole) AND (CoursePermission.cpPermissionsFlag & 8192 ) > 0) OR EXISTS(SELECT SystemPermission.spUid FROM SystemPermission WHERE SystemPermission.spToPersonUid = :accountPersonUid AND (SystemPermission.spPermissionsFlag & 8192 ) > 0) ) ) OR EXISTS( SELECT 1 FROM CourseGroupMember _CourseGroupMemberForActivePerson WHERE _CourseGroupMemberForActivePerson.cgmPersonUid = :accountPersonUid AND _CourseGroupMemberForActivePerson.cgmGroupNumber = CourseGroupMember.cgmGroupNumber) ) ORDER BY Person.firstNames, Person.lastName ASC 8          "@ÆBRHX†Tê ( € R HX†Tê ( € ò 0 0ø à ê com.ustadmobile.core.db.daoò ç [ Ê com ustadmobile core db dao StudentResultDao_DoorWrapper StudentResultDao _db door room RoomDatabase _dao StudentResultDao_DoorWrapper.kt existsByUid kotlin Boolean srUid Long findByClazzAndStudent collections List lib composites $StudentResultAndCourseBlockSourcedId clazzUid studentPersonUid accountPersonUid findUidBySourcedId sourcedId String insertListAsync Unit list entities StudentResult upsertAsync studentResultš                             ! ""ÇB ( (J 2(8H–@à J2(2(2(8H–@à J2(8H–@à J2 ( 8H–@à J#2$(8H–@à R  HX‚€ R HX‚€ ò0 0 0 0 0 0 0 0 0 0 0ø à ê com.ustadmobile.core.db.daoò