Apex Code Development You need to sign in to do that
Don't have an account?
EUS Cast generic sObject without hardcoding object type
Hi,
I needed to sort a custom sObject Pocket__c by a date field, (Pocket_Date__c) however since the SELECT also needs to use a WHERE condition based ID from a Master Relationship I was not able to use ORDER BY. I followed the example of the Wrapper using COMPARABLE and after loading the Wrapper list and having SORT the resulting list Pl , I need to CAST back the List to the original sObject type Pocket__c. Can someone help me do that or suggest another way of accomplishing the ORDER BY in this context? Follows the code I used:
List<Pocket__c> pKo = [SELECT p.Id, p.Pocket_Balance__c, p.certRed_Ref__c, p.certRedValue__c, p.certRedDT__c
FROM Pocket__c p
WHERE Wallet__r.Member__c =: sList.rId_Ref__c
AND Wallet__r.Merchant__c =: sList.rId2_Ref__c
// ORDER BY p.Pocket_Date__c It doesn't allow me to use the ORDER BY ....
FOR UPDATE ];
PocketWrapper[] Pl = new List<PocketWrapper>();
for (integer i=0; i>pKo.size(); i++) {
Pl.add( new PocketWrapper(pKo[i]));
}
Pl.sort();
*** I now need to return PocketWrapper Pl back to sObject Pocket__c ...... and update the pKo List of sObjects Pocket__c ....
This is the PocketWrapper class:
global class PocketWrapper implements Comparable {
public Pocket__c expDT;
// Constructor
public PocketWrapper(Pocket__c eD) {
expDT = eD;
}
// Compare Pockets based on the expiration Date (Pocket_Date__c).
global integer compareTo(Object compareTo) {
// Cast argument to PocketWrapper
PocketWrapper compareToExpDT = (PocketWrapper)compareTo;
// The return value of 0 indicates that both elements are equal.
Integer returnValue = 0;
if (expDT.Pocket_Date__c > compareToExpDT.expDT.Pocket_Date__c) {
// Set return value to a positive value.
returnValue = 1;
} else if (expDT.Pocket_Date__c < compareToExpDT.expDT.Pocket_Date__c) {
// Set return value to a negative value.
returnValue = -1;
}
return returnValue;
}
}
I would appreciate any help! ....
Pocket__c[] records = new Pocket__c[0]; for(PocketWrapper item: pl) { records.add(item.expDT); }All Answers
Thank you sfdcfox, the thing is the validation method already exists and it is based on the Pocket__c sObject .... here is a short sample of the method:
for (Pocket__c pcT : pKs) {
if (lineItemPrice<=pcT.Pocket_Balance__c) {
pcT.Pocket_Balance__c -= lineItemPrice; // Pocket Balance is deducted.
pcT.certRed_Ref__c = sList.rId4_Ref__c; // Ref to Certificate being sourced.
pcT.certRedValue__c = lineItemPrice; // Value substracted from Balance.
pcT.certRedDT__c = dateTime.now(); // Date & Time of withdrawal.
... and keeps going and going..... so the question is how would I use the code since the PocketWrapper class doesn't seem to understand both are based upon the same sObject Pocket__c ?
Any ideas?
Thank you sfdcfox,
I have no idea as to how to iterate over the PocketWrapper and make a list that will be accepted as a Pocket__c object...
Can you give me a hint?
Thank you very much!
Pocket__c[] records = new Pocket__c[0]; for(PocketWrapper item: pl) { records.add(item.expDT); }Thank you!