You need to sign in to do that
Don't have an account?
kishore64
How we can get the current page ID in Trigger
Hi everybody,
Actually i have checkbox field in my child record Here my requirement is the recent record should be active. For Example:I have 2 records in parent object under that one record have 3 childs and the 3 child record should be active for that i wrote a trigger that is working fine but my problem is it is taking the overall child records which is recent record then that is activating the checkbox but i need 0ne parent record under 3 childs are there i want 3 rd record should be activate at the same time the second parent record have 3 childs here also the 3rd record should be activte. Totally i need 2 activate child records for that object.
Here i am implemented the trigger i know i am not writing any query on parent object but how to write i don't know that's reason i am posting here
trigger ActivateSpecificationSheet on Specification_Sheet__c(before insert) {
if(trigger.isInsert){
for(Specification_Sheet__c ssh : Trigger.New){
ssh.Is_Active__c = true;
}
List<Specification_Sheet__c > updssh = New List<Specification_Sheet__c >();
List<Specification_Sheet__c > sshlst = [select id,name,Is_Active__c,Sales_Order_LineItem__c from Specification_Sheet__c where Is_Active__c = true ];
for(Specification_Sheet__c ssh1: sshlst){
ssh1.Is_Active__c=false;
updssh.add(ssh1);
}
update updssh;
}
}
Can any one suggest me please help me out......
Actually i have checkbox field in my child record Here my requirement is the recent record should be active. For Example:I have 2 records in parent object under that one record have 3 childs and the 3 child record should be active for that i wrote a trigger that is working fine but my problem is it is taking the overall child records which is recent record then that is activating the checkbox but i need 0ne parent record under 3 childs are there i want 3 rd record should be activate at the same time the second parent record have 3 childs here also the 3rd record should be activte. Totally i need 2 activate child records for that object.
Here i am implemented the trigger i know i am not writing any query on parent object but how to write i don't know that's reason i am posting here
trigger ActivateSpecificationSheet on Specification_Sheet__c(before insert) {
if(trigger.isInsert){
for(Specification_Sheet__c ssh : Trigger.New){
ssh.Is_Active__c = true;
}
List<Specification_Sheet__c > updssh = New List<Specification_Sheet__c >();
List<Specification_Sheet__c > sshlst = [select id,name,Is_Active__c,Sales_Order_LineItem__c from Specification_Sheet__c where Is_Active__c = true ];
for(Specification_Sheet__c ssh1: sshlst){
ssh1.Is_Active__c=false;
updssh.add(ssh1);
}
update updssh;
}
}
Can any one suggest me please help me out......
When a trigger is initiated, you will get an array of records in the Trigger.new and Trigger.old objects.
You can iterate through those and get the Id, plus the other fields on that record.
for example:
trigger testAccountTrigger on Account (after insert, after update){
for(Account a: Trigger.new){
System.debug('id is: ' + a.Id);
System.debug('name is : ' + a.Name);
}
}
I believe, this was helpful.
Regards
Pramod