‰/home/jenkins/.jenkins/workspace/Release-Kaisipan/lib-database/src/commonMain/kotlin/com/ustadmobile/core/db/dao/ContentEntryDaoCommon.ktContentEntryDaoCommon_instanceSORT_TITLE_ASC_1SORT_TITLE_DESC_1(SELECT_STATUS_FIELDS_FOR_CONTENT_ENTRY_1 H (SELECT MAX(StatementEntity.extensionProgress) FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND CAST(StatementEntity.completionOrProgress AS INTEGER) = 1 ) AS sProgress, (SELECT CASE -- If a successful completion statement exists, then count as success WHEN (SELECT EXISTS( SELECT 1 FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND ( CAST(StatementEntity.completionOrProgress AS INTEGER) = 1 AND CAST(StatementEntity.resultCompletion AS INTEGER) = 1 AND CAST(StatementEntity.resultSuccess AS INTEGER) = 1 ))) THEN 1 -- Else if no success record exists, however a fail record exists, mark as failed WHEN (SELECT EXISTS( SELECT 1 FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND ( CAST(StatementEntity.completionOrProgress AS INTEGER) = 1 AND CAST(StatementEntity.resultCompletion AS INTEGER) = 1 AND CAST(StatementEntity.resultSuccess AS INTEGER) = 0 ))) THEN 0 ELSE NULL END ) AS sIsSuccess, (SELECT EXISTS( SELECT 1 FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND CAST(StatementEntity.resultCompletion AS INTEGER) = 1 AND CAST(StatementEntity.completionOrProgress AS INTEGER) = 1) ) AS sIsCompleted, (SELECT MAX(StatementEntity.resultScoreScaled) FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid ) AS sScoreScaled )SELECT_ACCOUNT_PERSON_AND_STATUS_FIELDS_1 © :accountPersonUid AS sPersonUid, 0 AS sCbUid, (SELECT MAX(StatementEntity.extensionProgress) FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND CAST(StatementEntity.completionOrProgress AS INTEGER) = 1 ) AS sProgress, (SELECT CASE -- If a successful completion statement exists, then count as success WHEN (SELECT EXISTS( SELECT 1 FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND ( CAST(StatementEntity.completionOrProgress AS INTEGER) = 1 AND CAST(StatementEntity.resultCompletion AS INTEGER) = 1 AND CAST(StatementEntity.resultSuccess AS INTEGER) = 1 ))) THEN 1 -- Else if no success record exists, however a fail record exists, mark as failed WHEN (SELECT EXISTS( SELECT 1 FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND ( CAST(StatementEntity.completionOrProgress AS INTEGER) = 1 AND CAST(StatementEntity.resultCompletion AS INTEGER) = 1 AND CAST(StatementEntity.resultSuccess AS INTEGER) = 0 ))) THEN 0 ELSE NULL END ) AS sIsSuccess, (SELECT EXISTS( SELECT 1 FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid AND CAST(StatementEntity.resultCompletion AS INTEGER) = 1 AND CAST(StatementEntity.completionOrProgress AS INTEGER) = 1) ) AS sIsCompleted, (SELECT MAX(StatementEntity.resultScoreScaled) FROM StatementEntity WHERE (SELECT includeResults FROM IncludeResults) = 1 AND StatementEntity.statementActorPersonUid = :accountPersonUid AND StatementEntity.statementContentEntryUid = ContentEntry.contentEntryUid ) AS sScoreScaled ContentEntryDaoCommonget_SORT_TITLE_ASC_uf63jm_k$protoOfget_SORT_TITLE_DESC_jntz80_k$4get_SELECT_STATUS_FIELDS_FOR_CONTENT_ENTRY_3f6vr7_k$5get_SELECT_ACCOUNT_PERSON_AND_STATUS_FIELDS_i23pgg_k$!ContentEntryDaoCommon_getInstance9com.ustadmobile.core.db.dao/ContentEntryDaoCommon|null[0]Aic#94:com.ustadmobile.core.db.dao/ContentEntryDaoCommon|null[0]-1(kotlin.js/protoOf|8514483458758599133[0]+kotlin.js/objectMeta|8329516420247412592[0] objectMeta0kotlin.js/setMetadataFor|-3190451995726208444[0]setMetadataForAic#94:com.ustadmobile.core.db.dao/ContentEntryDaoCommon|null[0]-0kotlin/Any|null[0]Any     ContentEntryDaoCommoncom.ustadmobile.core.db.dao      7 77>8 >8>8                     > > > >