
2 risposte
In following case we need to execute Query inside trigger1) Some time we need to fatch the related object record in trigger in that case we also need to execute Soql2) We need to fatch the reference record value (Lookup) . For example Account detail in Contact Trigger.3) If Trigger is on After Event in that case also we need query the record if we need to update the same record.Trigger Best Practices1) One Trigger Per Object2) Logic-less Triggers3) Context-Specific Handler Methods4) Bulkify your Code5) Avoid SOQL Queries or DML statements inside FOR Loops6) Using Collections, Streamlining Queries, and Efficient For Loops7) Querying Large Data SetsNOTE:- Trigger.new will give you same object record onlyPlease check below post for more infohttp://amitsalesforce.blogspot.com/2015/06/trigger-best-practices-sample-trigger.htmlPlease let us know if this will help youThanksAmit Chaudhary