Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Siana DcruzSiana Dcruz 

How to compare fields of two different objects!!

Hi all,
I need help in trigger, There are two objects Intake_details and claim. The issue is,some claim records are being created that do not have a corresponding Intake Detail record
A claim record should only be created if its name(claim number) field matches the Intake_details name field. 

Please suggest me how to do this.
Best Answer chosen by Siana Dcruz
Veenesh VikramVeenesh Vikram
A trigger like this will do the Job: 
trigger preventinsert on claim__c(before insert){
	Set<String> indicatorNames = new Set<String>();
	Set<String> namesofClaim = new Set<String>();
	for(claim__c claim : trigger.new){
		namesofClaim.add(claim.Name);
	}
	for(Intake_details__c intake : [SELECT Id, Name FROM Intake_details__c Where Name in :namesofClaim]){
		indicatorNames.add(intake.Name);
	}
	for(claim__c claim : trigger.new){
		if(!indicatorNames.contains(claim.Name)){
			claim.addError('CANNOT INSERT');
		}
	}
}

Hope this helps!

Veenesh

All Answers

Veenesh VikramVeenesh Vikram
A trigger like this will do the Job: 
trigger preventinsert on claim__c(before insert){
	Set<String> indicatorNames = new Set<String>();
	Set<String> namesofClaim = new Set<String>();
	for(claim__c claim : trigger.new){
		namesofClaim.add(claim.Name);
	}
	for(Intake_details__c intake : [SELECT Id, Name FROM Intake_details__c Where Name in :namesofClaim]){
		indicatorNames.add(intake.Name);
	}
	for(claim__c claim : trigger.new){
		if(!indicatorNames.contains(claim.Name)){
			claim.addError('CANNOT INSERT');
		}
	}
}

Hope this helps!

Veenesh
This was selected as the best answer
Siana DcruzSiana Dcruz
Thanks!!.It worked..
But in my case, IF claim name doesnt match with any of the intakedetail name then I need to a create a intakedetail record with the corresponding claim name.How will I achieve that?
Veenesh VikramVeenesh Vikram
trigger preventinsert on claim__c(before insert){
	Set<String> indicatorNames = new Set<String>();
	Set<String> namesofClaim = new Set<String>();
	List<Intake_details__c> insertList = new List<Intake_details__c>();
	for(claim__c claim : trigger.new){
		namesofClaim.add(claim.Name);
	}
	for(Intake_details__c intake : [SELECT Id, Name FROM Intake_details__c Where Name in :namesofClaim]){
		indicatorNames.add(intake.Name);
	}
	for(claim__c claim : trigger.new){
		if(!indicatorNames.contains(claim.Name)){
			insertList.add(new Intake_details__c(name=claim.Name));
			//claim.addError('CANNOT INSERT');
		}
	}
	if(insertList.size()>0){
		insert insertList;
	}
}

 
Siana DcruzSiana Dcruz
Thanks Veenesh :)
 
Flavia DcostaFlavia Dcosta
I tried a similar approach for mine - i have 2 objects Student__c and Blacklisted_candidate__c. in this situation i should not be able to create a record in Student__c if the Pan_Card_Permanent__C number of Student__c object matches with the Pan__c of Blacklisted_candidate__c object, but my trigger is not working.


trigger preventinsert on Student__c (before insert) {

//creating set strings to hold PAN of both objects
set<string> BCPAN = new set<string>();
set<string> SMPAN = new set<string>();

for(student__C FORSTUD: trigger.new){
SMPAN.add(FORSTUD.Pan_Card_Permanent__C);
}

for(blacklisted_candidate__C FORBC : [SELECT ID, PAN__c FROM blacklisted_candidate__C WHERE PAN__c IN :SMPAN]){
BCPAN.ADD(FORBC.Pan__C);}

for(student__C FORSTUD:trigger.new){
If (!BCPAN.CONTAINS(FORSTUD.Pan_Card_Permanent__C)){
FORSTUD.adderror('Blacklisted Candidate - PAN appears in blacklisted candidate Object');}}}