Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to aggregate values in a list by specific elements

Posted on 2014-02-07
3
Medium Priority
?
175 Views
Last Modified: 2016-02-17
I'm using the salesforce (apex) language, so I'm posting in the java group since apex is a derivative of the java language.  I hope someone can help.

I have a batch program I'm working on that contains a list of sobjects that haven't been inserted and I need to loop over the list and find the elements in the list that have the same fund and contact and aggregate several fields. Once I have the new list, then I do the insert.

I've been struggling on how to correctly loop over my list to find the same elements by fund and contact and then do the aggregation of the currency fields? The first issue is that the list isn't sorted so how do I find the correct elements to aggregate the values?

This is the pattern I was tyring, but it doesn't work.

List<My_SObject__c> listToInsert = new List<My_SObject__c>();
String fundName = '';
Id contactId = null;
for(My_SObject__c obj : tempList) {
    if(obj.FundName__c = fundName && obj.Contact__c == contactId) {
        obj.MyCurrencyFieldToAggregate__c += obj.MyCurrencyFieldToAggregate__c;
        listToInsert.add(obj);
    }
 fundName = obj.FundName__c;
 contactId = obj.Contact__c;
}

Open in new window


Any help is appreciated.
Thanks.
0
Comment
Question by:-Dman100-
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 39842901
You could aggregate by using Set operations with a wrapper class. Better to demonstrate: run the following and note the aggregation by 'fund' and 'contact'
Sales.java
SalesWrapper.java
0
 

Author Comment

by:-Dman100-
ID: 39843154
Hi CEHJ,

Thanks for the example, I'm looking at the code and trying to decipher what it is doing.  Can you explain the aggregation portion?  Is the aggregation occurring in the SalesWrapper class in the two overridden methods?

Thanks for your help!  I very much appreciate it!
Regards.
0
 
LVL 86

Accepted Solution

by:
CEHJ earned 2000 total points
ID: 39843201
The aggregation is occurring as a result of the wrapper class implementing equals using the key criteria of fund and contact. It ignores any other attributes. Equality is met by fund and contact matching
0

Featured Post

Cyber Threats to Small Businesses (Part 2)

The evolving cybersecurity landscape presents SMBs with a host of new threats to their clients, their data, and their bottom line. In part 2 of this blog series, learn three quick processes Webroot’s CISO, Gary Hayslip, recommends to help small businesses beat modern threats.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
In the wake of AWS' S3 outage, we want to discuss the importance of storage and data diversification in the event of a hack, crash, or system disruption. We spoke with Experts Exchange’s COO Gene Richardson for a deeper understanding.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
Suggested Courses

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question