[SalesForce] Duplicates in Map

Is it possible to create a Map with duplicate Key

Key          Value
Product 1    100
product 1    200
product 2    200
product 2    300

Scenario : I have a trigger on quote and have to find the listprice of quotelineitems which have the same product name

I constructed a map with (productname,quotelineitem.listprice)

I have custom setting to check if the map has the key "product name" and then add up all the values

The problem is that I cannot form the above map because I am forgetting the fact that maps cannot have duplicate KEYS 🙁

IS there a better way to approach this

Best Answer

Map of lists maybe?

List<Account> fakeQuotes = new List<Account>{
    new Account(Name = 'Prod 1', AnnualRevenue = 100),
    new Account(Name = 'Prod 2', AnnualRevenue = 200),
    new Account(Name = 'Prod 1', AnnualRevenue = 300),
    new Account(Name = 'Prod 2', AnnualRevenue = 400),
    new Account(Name = 'Prod 1', AnnualRevenue = 500)
};

Map<String, List<Double>> listPrices = new Map<String, List<Double>>();
for(Account a : fakeQuotes){
    List<Double> temp = listPrices.get(a.Name);
    if(temp == null) {
        listPrices.put(a.Name, new List<Double>{a.AnnualRevenue});
    } else {
        temp.add(a.AnnualRevenue);
    }
}

System.debug(listPrices); // {Prod 1=(100.0, 300.0, 500.0), Prod 2=(200.0, 400.0)}

Related Solutions

[SalesForce] How to sort keys in MAP while grouping

Java has multiple map classes such as LinkedHashMap that preserve insertion order but Apex only has one map type which does not. So in Apex a work-around is to keep a separate list of the keys as lists preserve insertion order and get the keys to iterate through from the list:

private Map<string, groupingWrapClass> map_lineitems_Group
        = new Map<string, groupingWrapClass>();
private List<String> ordered_keys = new List<String>();

private void addToMap(String key, groupingWrapClass grouping) {
    map_lineitems_Group.put(key, grouping);
    ordered_keys.add(key);
}

private void xyz() {
    ...
    addToMap('XYZ', keyvalues);
    addToMap('ABC', keyvalues);
    ...
    // Run through the map keys in insertion order
    for (String key : ordered_keys) {
        groupingWrapClass grouping = map_lineitems_Group.get(key);
        ...
    }
}

On exposing this to Visualforce, make both ordered_keys and map_lineitems_Group visible (add getters or make properties) and then e.g.:

<apex:pageBlockTable value="{!ordered_keys}" var="ordered_key">
<apex:column headerValue="Year Name" value="{!map_lineitems_Group[ordered_key].yearname}"/>
...
</apex:pageBlockTable>

as expressions in Visualforce use [] for map access.

You could also add an apex:variable to factor out the common map_lineitems_Group[ordered_key] expression.

[SalesForce] Iterating inside a Map

To map them by Unique Id for later use:

Map<String, Account> existingAccounts = new Map<String, Account>();
for (Account existingAccount : [
    SELECT Unique__c FROM Account
    WHERE Unique__c IN :allUniqueIds
]){
    existingAccounts.put(existingAccount.Unique__c, existingAccount);
}

Then when iterating through you can retrieve them by that value.

String uniqueId = registration.account.Unique__c;
if (existingAccounts.containsKey(uniqueId))
    registration.account.Id = existingAccounts.get(uniqueId).Id;

Best Answer

Related Solutions

[SalesForce] How to sort keys in MAP while grouping

[SalesForce] Iterating inside a Map

Related Topic