You need to sign in to do that
Don't have an account?
chandrashekar Jangiti
Need to display User's records in Junction Object based on Selected Alert country field..
Hi Folks,
I need one trigger it is urget,
I have 3 objects like Alerts,Subscriptions,AlertSubscriptions...Subscriptions obj have Lookup User,Country picklist fields and Alerts objetct have picklist Country__c ,Name text field,
so here whenever in Alerts object selected Country field as "India" need to display India subscription user records in Junction object AlertSubscription..
for help to Others am posting code here...
trigger resultsdip on Alerts__c (after insert) {
List<string>seltcountry = new list<string>();
For(Alerts__c a: trigger.new){
if(a.Country__c !=null){
seltcountry.add(a.Country__c);
}
}
list<Subscriptions__c>sublst =[select id, name, Country__c, First_Name__c, Last_Name__c, User__c from Subscriptions__c
where Country__c=:seltcountry ];
List<AlertSubscriptions__c> listaltsub = new List<AlertSubscriptions__c>();
for(Alerts__c a: trigger.new){
//integer i=1;
for(Subscriptions__c s:sublst ){
if(a.Country__c== s.Country__c){
AlertSubscriptions__c altsub = new AlertSubscriptions__c();
altsub.Name=s.Country__c;
altsub.Alertss__c= a.Id;
altsub.Subscript__c = s.Id;
altsub.User__c= s.User__c;
listaltsub.add(altsub);
// i++;
}
}
}
system.debug('altsubrecords....'+listaltsub);
if(listaltsub.size()>0){
insert listaltsub;
}
}