1

I'm receiving the following error:

Illegal assignment from List<OpportunityContactRole> to List<String>

When I try to query from OpportunityContactRole and store it into a new list. I'm pretty new to apex, so I'm kind of confused where I'm going wrong. Here's my code:

public class testOCR {

    public static void testOCRmethod(){

        // Create a list that stores the query data        
        List<string> ContactList = [SELECT OpportunityId,Contact.Referral_ID__c FROM OpportunityContactRole WHERE ContactId IN (SELECT Id FROM Contact WHERE Referral_ID__c != null) AND OpportunityId IN (SELECT Id FROM Opportunity WHERE Referral_ID__c = null) AND CreatedDate <= TODAY];

        Integer ListSize = ContactList.size();

        if( ListSize < 1 ) {

            system.debug('List is too small');

        } else {

            // list is a proper size
            system.debug('List is big enough');

            for(string x : ContactList) {

                system.debug(x);

            }

        }

    }

}

Originally I had it set as List<OpportunityContactRole> which worked, sort of. The problem was that when I would check my debug log, it wasn't saving the Referral_ID__c value, which is why I was trying to change it to a string instead.

Any ideas where I'm going wrong?

3

You should be able to iterate the list and add the field to a separate collection:

List<String> referralIds = new List<String>();
for (OpportunityContactRole ocr : [/*query*/])
    referralIds.add(ocr.Contact.Referral_Id__c);
| improve this answer | |
2

I'd like to post this as a comment, but I think it became too big for it.

I think that your real question might be Why can't I see some fields (Referral_ID__c) with system.debug(...).

The reason why you don't see Referral_ID__c in your logs it's because your query is getting this field from a parent relationship (Right Outer Join). If you directly debug your record results:

for(OpportunityContactRole x : ContactList) {
    system.debug(x);
}

the debug log will only display your sObject's own fields, not the ones that come from relationships (Contact.Referral_ID__c), but that doesn't mean that such field was not retrieved inside your records results, therefore if you do something like:

for(OpportunityContactRole x : ContactList) {
    system.debug(x.Contact.Referral_ID__c);
}

then you'll see the value that you're looking for.

Going back to original question's title, @Adrian 's answer is the fix for it.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.