Notes

<?xml version="1.0"?>
<import>
<DataChange public-id="bc:AssociateTicketsViaJoin">
<ExternalReference>Associate_TroubleTickets_Through_Join_Table</ExternalReference>
<Description>Associate trouble tickets with policies using TroubleTicketJoinEntity</Description>
<Status>OPEN</Status>
<Script><![CDATA[
uses gw.api.database.Query
uses gw.api.database.Relop
uses gw.transaction.Transaction
uses entity.PolicyPeriod
uses entity.TroubleTicket
uses entity.TroubleTicketJoinEntity

var resultWriter = DataChange.util.ResultWriter
resultWriter.append("== Trouble Ticket Association Started ==n")

// ===== TICKET-TO-POLICY MAPPING =====
// Add your specific ticket number -> policy number mappings here
var ticketPolicyMappings = {
"TT000001" -> "H0MN0000022385", // Format: "TroubleTicketNumber" -> "PolicyNumber"
"TT000002" -> "H0MN0000022390",
"TT000003" -> "H0MN0000022400"
// Add all your mappings in this format
}
// ====================================

try {
var processed = 0
var succeeded = 0
var failed = 0

// Process each ticket-policy mapping
ticketPolicyMappings.eachKeyAndValue( ticketNumber, policyNumber -> {
processed++
resultWriter.append("nProcessing Ticket ${ticketNumber} -> Policy ${policyNumber}n")

// 1. Find Trouble Ticket by TroubleTicketNumber
var troubleTicket = Query.make(TroubleTicket)
.compare(TroubleTicket#TroubleTicketNumber, Relop.Equals, ticketNumber)
.select()
.AtMostOneRow

if (troubleTicket == null) {
resultWriter.append("!! ERROR: TroubleTicket ${ticketNumber} not foundn")
failed++
return
}

// 2. Find PolicyPeriod by PolicyNumber
var policyPeriod = Query.make(PolicyPeriod)
.compare(PolicyPeriod#PolicyNumber, Relop.Equals, policyNumber)
.select()
.AtMostOneRow

if (policyPeriod == null) {
resultWriter.append("!! ERROR: PolicyPeriod ${policyNumber} not foundn")
failed++
return
}

// 3. Check if association already exists in TroubleTicketJoinEntity
var existingJoin = Query.make(TroubleTicketJoinEntity)
.compare("TroubleTicket", Relop.Equals, troubleTicket)
.compare("PolicyPeriod", Relop.Equals, policyPeriod)
.select()
.AtMostOneRow

if (existingJoin != null) {
resultWriter.append("✓ Association already exists in TroubleTicketJoinEntityn")
resultWriter.append(" - Join Entity ID: ${existingJoin.PublicID}n")
succeeded++
return
}

// 4. Create new association in TroubleTicketJoinEntity
try {
Transaction.runWithNewBundle( bundle -> {
// Create new TroubleTicketJoinEntity
var newJoin = new TroubleTicketJoinEntity(bundle)

// Set the required fields directly (bypassing private setters)
newJoin.TroubleTicket = troubleTicket
newJoin.PolicyPeriod = policyPeriod

// Set other required fields if needed (based on your entity definition)
// newJoin.Account = policyPeriod.Account
// newJoin.Policy = policyPeriod.Policy

resultWriter.append("✓ Created new TroubleTicketJoinEntity associationn")
resultWriter.append(" - TroubleTicket: ${troubleTicket.TroubleTicketNumber}n")
resultWriter.append(" - PolicyPeriod: ${policyPeriod.PolicyNumber}n")
resultWriter.append(" - Policy: ${policyPeriod.Policy.PolicyNumber}n")
resultWriter.append(" - Account: ${policyPeriod.Account.AccountNumber}n")
}, "su") // Run as super user to bypass permissions

succeeded++
} catch (e: Exception) {
resultWriter.append("!! ERROR creating association: ${e.Message}n")
resultWriter.append("!! ERROR Details: ${e.StackTraceAsString}n")
failed++
}
})

// 5. Summary Report
resultWriter.append("n" + "="*50 + "n")
resultWriter.append("ASSOCIATION SUMMARY:n")
resultWriter.append("Processed: ${processed}n")
resultWriter.append("Succeeded: ${succeeded}n")
resultWriter.append("Failed: ${failed}n")

if (failed > 0) {
resultWriter.append("n!! SOME ASSOCIATIONS FAILED - CHECK ERRORS ABOVE !!n")
} else {
resultWriter.append("n✓ ALL ASSOCIATIONS COMPLETED SUCCESSFULLYn")
}

resultWriter.append("="*50 + "n")

} catch (e: Exception) {
resultWriter.append("!! GLOBAL ERROR: ${e.Message}n")
resultWriter.append("!! StackTrace: ${e.StackTraceAsString}n")
}

resultWriter.append("== Ticket Association Completed ==n")
]]></Script>
</DataChange>
</import>