[SalesForce] Retrieving value using dynamic SOQL

This is my query…

List<Opportunity> opportunities = Database.query('SELECT OwnerId, Amount, Probability, ExpectedRevenue ' +  mycustomatt + ' FROM OPPORTUNITY ' + ' where isClosed = false');

mycustomatt is a String that is determine at runtime.

If I iterate over the opportunities, how can I get the value for mycustomatt?

for (Opportunity opportunity: opportunities) {
    // can get amount by doing
    System.debug('amount=' + opportunity.Amount);
    // ??? But how do I get the values for my customatt
    // ???

Thanks

Best Answer

Since the other question relates technically to updating and not retrieving I'll give an answer here as well, as well as a security nod. Though in general its pretty much the same principle and area of Apex you need to understand. That being Dynamic Apex and also the methods described on the SObject class, specifically in your case the 'get' methods. In short the following will give you what you want.

opportunity.get(mycustomatt);

If your custom attribute was of type String, you would cast it as follows...

String mycustomattValue = (String) opportunity.get(mycustomatt);

NOTE: You also need to keep in mind SOQL Injection considerations, as described here. Even if your code is providing the additional SOQL query information (as apposed to some end user prompt or config), its usually good practice to follow the recommendations here, just in case the situation changes in your code in the future.

Related Solutions

Apex – How to Get and Compare Children Values on Map in Apex

The children records will be contained within standard List collections under the parent object record.

Enhancing your much-too-genericized code sample:

Map<Id, Account> AcctOppCustomObjectMap = new Map<Id, Account>([SELECT Id
                                                                    ,(SELECT xxx 
                                                                        FROM xxx__r)
                                                                    ,(SELECT yyy 
                                                                        FROM yyy__r) 
                                                                FROM Account
                                                                WHERE Id IN :idSet]);

List<yyy__c> yThingsToUpdate = new List<yyy__c>();

for (Id accountId : AcctOppCustomObjectMap.keyset()) {
    Account acct = AcctOppCustomObjectMap.get(accountId);

    // the acct reference will have child lists for your subqueries
    // they will not be null, but they could be empty lists
    List<xxx__c> xxxList = acct.xxx__r;
    List<yyy__c> yyyList = acct.yyy__r;

    // iteration of the child records possible now using these two lists
    for (xxx__c xThing : xxxList) {
        for (yyy__c yThing : yyyList) {
            if (xThing.value == yThing.value) {
                // create your relationship and 
                // add to a list for bulk update / insert
                yThingsToUpdate.add(new yyy__c(Id = yThing.Id
                                                   , xxx__c = xThing.Id));

                break; // exit the for loop on the first match if desired
            }
        }
    }
}


if (!yThingsToUpdate.isEmpty()) {
    update yThingsToUpdate;
}

I would probably iterate each child list just once each to create maps of the contents by a desired key so that I could perform a Map.get() instead of repeatedly iterating lists to find the other child record to compare against. Your code sample needs more specific information in it.

Repeated iteration of the yyy list within the xxx list will limit your ability to process records since these will use script statements to iterate and match the records.

Apex – Dynamic Batch Apex with SObject Iteration Guide

You'd use the "get" method to get the field value, like this:

opp.Opportunity_Id__c = (Id)sobjet.get(opportunity);

Note: opportunity refers not to Schema.Opportunity in this context, but simply the String variable called opportunity that was set in the start method.

Best Answer

Related Solutions

Apex – How to Get and Compare Children Values on Map in Apex

Apex – Dynamic Batch Apex with SObject Iteration Guide

Related Topic