[SalesForce] Match object from map and get its records

I have a logic issue with the next code which I cannot manage to solve.
I will receive a Map<String, List<Sobject>> recordsMap and I need to match the String which will be the object name and get the List and match it with the mapping fields

public List<SubsExtendedInfo> generateWrapperInfo (Map<String, List<Sobject>> recordsMap){
        //object Name >> records

        Map<String, SubscriberMapping__c> mappingFieldsMap = SubscriberMapping__c.getAll();

        // This mappingFieldsMap has the name of the object with the mapping fields
        // The obj name should match with the map string and then by its name get the equivalent mapping fields List<Sobject> - mappingFieldsMap

       // mappingFieldsMap.get(Key).SF_Object_API_Name__c
       // This is the object name field from the mappingFieldsMap
        return null;
}

I cannot figure out how to do it, could anyone help me?

SubscriberMapping__c Structure

Product Field Name || FieldName__c

Object API Name || SF_Object_API_Name__c

SF_Field_API_Name || SF_Field_API_Name__c

SubscriberMapping__c Values

Name || Product Field Name || Object API Name || SF_Field_API_Name

Contact-Email || Email || Contact || Email

Contact-First Name || First Name || Contact || FirstName

And the Map will the String for the obj name and List is the object with its fields and values, the fields are the same as SF_Field_API_Name in the custom setting.

So I should match the obj name and then the field names to get its values.

Best Answer

If I can understand your requirement correctly, here will be the code.

public List<SubsExtendedInfo> generateWrapperInfo (Map<String, List<Sobject>> recordsMap){

Map<String, SubscriberMapping__c> mappingFieldsMap = SubscriberMapping__c.getAll();

    for(String str:mappingFieldsMap.keyset())
    {
        SubscriberMapping__c mc = SubscriberMapping__c.getValues(str);

        //retrieve values based on key
        String objectAPIName = mc.get('Object API Name');
        String strSF_Field_API_Name = mc.get('SF_Field_API_Name');

        //compare with the values passed as argument in this method.
        if(recordsMap.containsKey(objectAPIName))
        {
            //get the list of SObject
            List<Sobject> lst = recordsMap.get(objectAPIName);

            //loop through the list
            for(Sobject sobj:lst)
            {
                //print the values from SObject where API name will from custom settings.
                System.debug('print the values=' + sobj.get(strSF_Field_API_Name))

            }
        }
    }
}

Related Solutions

[SalesForce] How to define a map with id and list of records of an object

Yes it seems alright to do it like you have, To add for the first time

mapProductEntity.put(et.Product__c, new List <Entitlement__c> { et });

Even where you're adding it above you don't need to reconstruct Entitlement__c as that is already your loop variable.

So even above you can use

if (mapProductEntity.containsKey(et.Product__c))
            {
mapProductEntity.get(et.Product__c). add(et);

[SalesForce] Salesforce creating field values as map keys and results as values

Have I understood your question correctly?

1: i need to add field name like 'id,name,fld3,fld4 etc,.. as map keys

String fieldNames = String.join(new List<String>{
    SObjectType.Opportunity.Fields.Id.Name, //"Id"
    SObjectType.Opportunity.Fields.Name.Name //"Name"
}, ',');

List<Opportunity> opportunities = Database.query('SELECT ' + fieldNames + ' FROM Opportunity');

2: and results of the fields as map values

You are looking for data structure like this?

{
    "Id": [
        "006d0000008WaWzAAK",
        "006d0000008WaWpAAK",
        "006d0000008WaXHAA0"
    ],
    "Name": [
        "Pyramid Emergency Generators",
        "Dickenson Mobile Generators",
        "Grand Hotels Emergency Generators"
    ]
}

You can use a Map<String,List<Object>> data structure to hold all the field values. Then convert the SObject into a Map itself to loop over its fields easily. Here's a code sample that yields the above:

//select any fields you want
List<Opportunity> opportunities = [SELECT Id, Name FROM Opportunity]; //or from above

//prepare the data structure to hold the list of values
Map<String,List<Object>> field2values = new Map<String,List<Object>>();

//every opportunity
for (Opportunity opportunity : opportunities) {
    //we can convert any SObject into a Map
    Map<String,Object> mapOpp = (Map<String,Object>)Json.deserializeUntyped(Json.serialize(opportunity));

    //every field
    for (String key : mapOpp.keySet()) {

        //leave out the metadata
        if (key == 'attributes') continue;

        //list of values needs to be initialized the first time around
        if (field2values.get(key) == null) field2values.put(key, new List<Object>());

        //populate each value
        field2values.get(key).add(oppMap.get(key));
    }

}

System.debug(Json.serializePretty(field2values));

Best Answer

Related Solutions

[SalesForce] How to define a map with id and list of records of an object

[SalesForce] Salesforce creating field values as map keys and results as values

Related Topic