You need to sign in to do that
Don't have an account?
Jefferson Escobar
Formula Fields or Relationships in the Queries ?
Hi All,
What is the best way in terms of performace, defining a formula field for related objects or using the clause __r directly in the query ?
Which one is the best approach ?
e.g:
What is the best way in terms of performace, defining a formula field for related objects or using the clause __r directly in the query ?
Which one is the best approach ?
e.g:
- Select Id, Name From Object where Custom_Formula_Field__c = 'Any'
- Select Id, Name From Object where Custom Related_Object__r.Custom_Field__c = 'Any'
https://developer.salesforce.com/blogs/engineering/2013/02/force-com-soql-best-practices-nulls-and-formula-fields.html
2nd option is good one.
Please let us know if this will help you.
Thanks
Amit Chaudhary