Apex Code Development You need to sign in to do that
Don't have an account?
cFang Prevent Duplicate Records
The code below is setup to automatically create projects for all opportunities that reach a probability of >=90%. I am new to APEX coding and would like to add additional statements that would only allow 1 project for each opportunity. Right now, if an opportunity is updated from 90% to 100% an additional project would be created. What is the best way to limit the code so that only 1 project is created for each opportunity regardless of how many times the probability is updated?
Any help is greatly appreciated.
This is the code:
trigger Locate_Prob90_Opportunities on Opportunity (after update,after insert) {
list<Opportunity> p90opps =
[select probability
from opportunity
where probability >=90
for update];
for (opportunity oppz: p90opps){
if(oppz.probability>=90){
SFDC_project__c prject = new SFDC_Project__c(name='Acme test',opportunity__c=oppz.id);
insert prject;
}
}
}
Actually, it may be easiest to do this with a validation rule, all you do is add a custom field to the project object with a formula of one, so it is a constant of 1. Then you add a roll-up field on the opportunity that sums that field. Finally a validation rule on the project object that fires if the roll-up field is >= 1. The only downside is that you would have to check and see if the update on the opprotunity is rolled back when the insert fails, i think that it might, but I am not sure.
If you wanted to do it in apex you would do something like:
List<ID>oppIds = new List<ID>();
for (opportunity o: p90opps){oppIds.add(o.id);}
List <SFDC_project__c> pList = new List<SFDC_project__c>([select id from SFDC_project__c where opportunity__c IN: oppIds]);
if (pList.isempty()){
...do work
}