Search This Blog

Thursday, August 6, 2015

Converting Objects

We redid a simple process at work and I needed to create custom objects based on previous data. Here is the query:

List<Case> casesToCreateShipments = [SELECT id,AccountID, Date_Welcome_Packet_Received__c, Date_Welcome_Packet_Sent__c, Send_Welcome_Packet__c, Welcome_Packet_Received_By_Provider__c, Welcome_Packet_Sent__c, Welcome_Packet_Tracking__c, createddate from Case where AccountId != null and RecordTypeId = '012G000000137Jt' and Account.Can_go_Live__c = true and Account.Provider_Status__c != 'Prospect' and Account.Provider_Status__c != 'Inactive' and Send_Welcome_Packet__c = true and (CreatedDate = LAST_N_MONTHS:4 or CreatedDate = THIS_WEEK) order by CreatedDate];

List<Shipment__c> newShipments = new List<Shipment__c>();

for(Case oneCase: casesToCreateShipments){
    Shipment__c newShipment = new Shipment__c(Account__c = oneCase.AccountID, Date_Sent__c = oneCase.Date_Welcome_Packet_Sent__c, Type_of_Shipment__c = 'Welcome Packet', Shipment_Received_By_Provider__c = oneCase.Welcome_Packet_Received_By_Provider__c, Shipment_Tracking__c = oneCase.Welcome_Packet_Tracking__c);
    newShipments.add(newShipment);
}

insert newShipments;

It worked out well but it was quite difficult to narrow down.

No comments:

Post a Comment