You need to sign in to do that
Don't have an account?
ElcalvoMike
Query of object on before insert trigger
This seems like a layup but cant figure out the syntax.
Since I cant use a formula field to reference cross-objects on standard objects (we like the case to be related to the opportunity) I need to populate two fields that I will use in a simple mail template.
How do i reference the value that is in case field Order_Number__c?
trigger addOppFields on Case (before insert) { Case mycase=trigger.new[0]; Opportunity opp=[select ID,Webpartner__c from Opportunity where name = :mycase.Order_Number__c]; mycase.XMWebPartner__c=opp.Webpartner__c; mycase.Merge_OpportunityID__c=opp.ID;
Order_number__c is a lookup to opportunity? In that case the value in there is the opportunity ID so you just need to filter on ID instead of name.
All Answers
Use a colon when referencing variables in soql I.E.
Sorry that was a typo on my part. It does have the colon.
The issue is it is returning no records, if I hardcode a value it works.
Thanks,
Is order_number__c being filled out by a workflow rule? It will be null in a before insert trigger if that is the case. Try system.debugging the value of mycase.Order_number__c and check if it's null.
It is being typed in by the case creator prior to saving a new case.
it is returning null, but not because it is in workflow.
this field is a look up field and im trying to take the entered value, like AAA-1234, and find the opp ID for that opp name.
maybe this is not possible with kind of field?
Order_number__c is a lookup to opportunity? In that case the value in there is the opportunity ID so you just need to filter on ID instead of name.
Yep, I didnt realize the Lookup happend prior to before insert.
Thanks!