PK - code

// ================================================================================== // Trigger: After Update on TimeEntry_c // Purpose: When PPMTaskID_c is updated (null → value) by an end user (not integration), // check if all entries have PPMTaskID_c and uncheck flag on Timesheet if true. // ================================================================================== try { println "[1] Starting PPMTaskCheckTrigger (After Update on TimeEntry_c)" println "[1.1] Processing TimeEntry record ID: ${Id}" // 1️⃣ Quick check if (!(isAttributeChanged('PPMTaskID_c') && PPMTaskID_c != null)) { println "[2] PPMTaskID_c not changed or still null — exiting" return } // 2️⃣ Skip for integration users def oicUsers = [ 'OicPpmPrdUsr01@pike.com','OicCrmPrdUsr01@pike.com','OicHcmPrdUsr01@pike.com', 'OicCRMUat1Usr01@pike.com','OicPpmUat1Usr01@pike.com','OicHcmUat1Usr01@pike.com', 'OicPpmDev1User01','OicHcmDev1User01','OicCrmDev1User01' ] def currentUser = adf.context.getSecurityContext().getUserName() println "[3] Current user: ${currentUser}" if (oicUsers.contains(currentUser)) { println "[4] Integration user detected — skipping trigger logic" return } // 3️⃣ Get parent Timesheet ID def tsId = Timesheet_Id_c println "[5] Timesheet_Id_c = ${tsId}" if (tsId == null) { println "[6] No Timesheet_Id_c found — exiting" return } // 4️⃣ Check if ANY Equipment entries have null PPMTaskID_c println "[7] Checking EquipmentsTimeEntry_c for NULL PPMTaskID_c" def eqpEntries = newView('EquipmentsTimeEntry_c') eqpEntries.appendViewCriteria("TimeSheet_Id_c = ${tsId} and PPMTaskID_c is null") eqpEntries.executeQuery() def eqpHasNull = eqpEntries.hasNext() println "[8] Equipment null PPMTask found? ${eqpHasNull}" // 5️⃣ Check if ANY TimeEntry entries have null PPMTaskID_c println "[9] Checking TimeEntry_c for NULL PPMTaskID_c" def timeEntries = newView('TimeEntry_c') timeEntries.appendViewCriteria("Timesheet_Id_c = ${tsId} and PPMTaskID_c is null") timeEntries.executeQuery() def timeHasNull = timeEntries.hasNext() println "[10] TimeEntry null PPMTask found? ${timeHasNull}" // 6️⃣ Update parent if all tasks are filled if (!eqpHasNull && !timeHasNull) { println "[11] ✅ All entries have PPMTaskID_c — updating parent Timesheet" def tsView = newView('Timesheet_c') def rows = tsView.findByKey(key(tsId), 1) if (rows.size() == 1) { def ts = rows[0] ts.setAttribute('PPMTaskIDMissing_c', false) // Replace with actual field name println "[12] Flag unchecked on Timesheet_c ID: ${tsId}" } else { println "[13] Timesheet not found or duplicate key results" } } else { println "[14] Some entries still missing PPMTaskID_c — parent not updated" } println "[15] PPMTaskCheckTrigger completed successfully" } catch (Exception e) { println "[E] [PPMTaskCheckTrigger] Exception: ${e.getMessage()}" }

Comments

Popular posts from this blog

Child query new

child query latest -

final simple where