‹/home/jenkins/.jenkins/workspace/Primary-End-To-End-Tests/lib-database/src/commonMain/kotlin/com/ustadmobile/core/db/dao/PersonDaoCommon.ktPersonDaoCommon_instanceSORT_FIRST_NAME_ASC_1SORT_FIRST_NAME_DESC_1SORT_LAST_NAME_ASC_1SORT_LAST_NAME_DESC_1!SQL_SELECT_LIST_WITH_PERMISSION_1: WITH CanViewPersonUidsViaCoursePermission(personUid) AS /* Select personUids that can be viewed based on CoursePermission given the active user for their enrolments */ (SELECT DISTINCT ClazzEnrolment_ForClazzMember.clazzEnrolmentPersonUid AS personUid FROM ClazzEnrolment ClazzEnrolment_ForActiveUser JOIN CoursePermission ON CoursePermission.cpClazzUid = ClazzEnrolment_ForActiveUser.clazzEnrolmentClazzUid AND CoursePermission.cpToEnrolmentRole = ClazzEnrolment_ForActiveUser.clazzEnrolmentRole AND (CoursePermission.cpPermissionsFlag & 8192) > 0 JOIN ClazzEnrolment ClazzEnrolment_ForClazzMember ON ClazzEnrolment_ForClazzMember.clazzEnrolmentClazzUid = CoursePermission.cpClazzUid WHERE :accountPersonUid != 0 AND ClazzEnrolment_ForActiveUser.clazzEnrolmentPersonUid = :accountPersonUid AND ClazzEnrolment_ForActiveUser.clazzEnrolmentActive UNION /* Select personUids that can be viewed based on CoursePermission for the active user where the CoursePermission is granted directly to them */ SELECT DISTINCT ClazzEnrolment_ForClazzMember.clazzEnrolmentPersonUid AS personUid FROM CoursePermission JOIN ClazzEnrolment ClazzEnrolment_ForClazzMember ON ClazzEnrolment_ForClazzMember.clazzEnrolmentClazzUid = CoursePermission.cpClazzUid WHERE :accountPersonUid != 0 AND CoursePermission.cpToPersonUid = :accountPersonUid) SELECT Person.*, PersonPicture.* FROM Person LEFT JOIN PersonPicture ON PersonPicture.personPictureUid = Person.personUid WHERE /* Begin permission check */ ( ( EXISTS(SELECT 1 FROM SystemPermission WHERE :accountPersonUid != 0 AND SystemPermission.spToPersonUid = :accountPersonUid AND (SystemPermission.spPermissionsFlag & 8192 ) > 0 AND NOT SystemPermission.spIsDeleted) ) OR (Person.personUid IN (SELECT CanViewPersonUidsViaCoursePermission.personUid FROM CanViewPersonUidsViaCoursePermission)) OR (Person.personUid = :accountPersonUid) ) /* End permission check */ AND (:excludeClazz = 0 OR :excludeClazz NOT IN (SELECT clazzEnrolmentClazzUid FROM ClazzEnrolment WHERE clazzEnrolmentPersonUid = Person.personUid AND :timestamp BETWEEN ClazzEnrolment.clazzEnrolmentDateJoined AND ClazzEnrolment.clazzEnrolmentDateLeft AND ClazzEnrolment.clazzEnrolmentActive)) AND Person.personType = 0 AND (Person.personUid NOT IN (:excludeSelected)) AND (:searchText = '%' OR Person.firstNames || ' ' || Person.lastName LIKE :searchText) GROUP BY Person.personUid, PersonPicture.personPictureUid ORDER BY CASE(:sortOrder) WHEN 1 THEN Person.firstNames WHEN 3 THEN Person.lastName ELSE '' END ASC, CASE(:sortOrder) WHEN 2 THEN Person.firstNames WHEN 4 THEN Person.lastName ELSE '' END DESC PersonDaoCommon!get_SORT_FIRST_NAME_ASC_uiz2kk_k$protoOf"get_SORT_FIRST_NAME_DESC_mxs51a_k$ get_SORT_LAST_NAME_ASC_qs7cum_k$!get_SORT_LAST_NAME_DESC_m2yybw_k$-get_SQL_SELECT_LIST_WITH_PERMISSION_6t03w0_k$PersonDaoCommon_getInstance3com.ustadmobile.core.db.dao/PersonDaoCommon|null[0];ic#94:com.ustadmobile.core.db.dao/PersonDaoCommon|null[0]-1(kotlin.js/protoOf|8514483458758599133[0]+kotlin.js/objectMeta|8329516420247412592[0] objectMeta0kotlin.js/setMetadataFor|-3190451995726208444[0]setMetadataFor;ic#94:com.ustadmobile.core.db.dao/PersonDaoCommon|null[0]-0kotlin/Any|null[0]Any     PersonDaoCommoncom.ustadmobile.core.db.dao   $  $ $ %  % % #  # #$ $$0 00