[SalesForce] SObject row was retrieved via SOQL without querying the requested field: Opportunity.Unsolicited_Bid__c:

I get the following error in my SalesForce app:

Error:Apex trigger UpdateOpportunity caused an unexpected exception, contact your administrator: UpdateOpportunity: execution of BeforeUpdate caused by: System.SObjectException: SObject row was retrieved via SOQL without querying the requested field: Opportunity.Unsolicited_Bid__c: Class.OpportunityMethods.updateOppCompetitor: line 11, column 1

I see there are a lot of similar questions, but I've tried their solutions and still can't get this query to work correctly.

Here is the trigger I have:

trigger UpdateOpportunity on Opportunity (before insert, before update){

    Opportunity[] oppQuery = [SELECT ID, RecordType.Name, StageName, Win_Reason__c FROM Opportunity WHERE ID IN :Trigger.new];  

    for(Opportunity opp : oppQuery){

        if(opp.RecordType.Name == 'SGI Opportunity' && opp.StageName != 'Lead 0%'){

            OpportunityMethods.updateOppCompetitor(opp);  
    }
}

And here's the class I use in the trigger that has Win_Reason__c, the field in question.

public Class OpportunityMethods {

public static void updateOppCompetitor(Opportunity opp){

    if(opp.Win_Reason__c == 'No Competition/Sole Source'){

    System.debug('THIS WORKED');

        opp.Competitor_s__c = 'No Competitor/Sole Source'; 
    }
    if(opp.Unsolicited_Bid__c == 'Yes'){


    System.debug('THIS WORKED');


        opp.Competitor_s__c = 'No Competitor/Sole Source';
    } 
}

}

Any clue what else I need to add to the SOQL query to make it run correctly?

Thanks in advance!

Best Answer

Please add the column Unsolicited_Bid__c to your oppQuery.

That is what the exception System.SObjectException: SObject row was retrieved via SOQL without querying the requested field: Opportunity.Unsolicited_Bid__ was trying to relay, that there was an attempt to get/set a field on an sobject from a query that originally did not query that field.

As an aside, do you have a specific reason for re-querying the opportunities inside the trigger? I believe you can reference and loop through Trigger.new and reference any of the opportunity fields and likely avoided this exception initially:

for(Opportunity opp : Trigger.new){
    if(opp.RecordType.Name == 'SGI Opportunity' && opp.StageName != 'Lead 0%'){
        OpportunityMethods.updateOppCompetitor(opp);  
    }
}

Related Solutions

[SalesForce] SObjectException “SObject row was retrieved via SOQL without querying the requested field” not being thrown

I cannot seem to reproduce what you've described, I get the sObject not retrieved error for Case 1 too!

The only caveat would be that since sObjects are passed by reference, hopefully there isn't a sneaky bit of assignment which is setting the value of CustomField1 somewhere in the foodchain.

If there is an assignment of value then it wouldn't throw the exception for any subsequent access. (Even though it wasn't initially retrieved as part of the soql)

As a simplified example, this will throw the SObjectException (assuming you have at least one Opportunity):

Opportunity opp = [select Id, StageName From Opportunity limit 1];
System.debug(opp.Probability);

And this will not (opp.Probablity will be null):

Opportunity opp = [select Id, StageName From Opportunity limit 1];
opp.StageName = 'foo';
System.debug(opp.Probability);

[SalesForce] SObject row was retrieved via SOQL without querying the requested field:

You need to add all fields that you want access to to your SOQL query, this includes relationship fields. Even if you query for

Agreement_CSH_to_be_completed_by__c

You need to add the fields that you want to access in your query such as

Agreement_CSH_to_be_completed_by__r.isActive

If you update your SOQL, this should work fine

EDIT in response to Comment

try this in execute anonymous. This should return an errror

Contract_Terms__c term = [Select Id, OwnerId, Owner.UserName, Account__c, RecordTypeId, Name, Agreement_Client_Status_History__c From Contract_Terms__c limit 1];
system.debug('User is active: ' + term.Agreement_CSH_to_be_completed_by__r.isActive);

If you then add it to your SOQL like below, and re run it, it should work fine

Contract_Terms__c term = [Select Id, OwnerId, Owner.UserName, Account__c, RecordTypeId, Name, Agreement_Client_Status_History__c, Agreement_CSH_to_be_completed_by__c, Agreement_CSH_to_be_completed_by__r.isActive From Contract_Terms__c limit 1];
    system.debug('User is active: ' + term.Agreement_CSH_to_be_completed_by__r.isActive);

Best Answer

Related Solutions

[SalesForce] SObjectException “SObject row was retrieved via SOQL without querying the requested field” not being thrown

[SalesForce] SObject row was retrieved via SOQL without querying the requested field:

Related Topic