You need to sign in to do that
Don't have an account?
Simulate an edit/save on parent object
Greetings,
I am to Simulate an edit/save on parent object, which is a custom object, Cunsumer__c from its child, a Standard, Solutions.
The code I wrote is:
trigger AutoUpdateConsumer on Solution (after insert,after update) {
List<Solution> S = [Select Solution.Consumer__c From Solution];
// String Sol = '0000000042';
id Sol = S[0].Consumer__c;
List<Consumer__c> Con = [Select Consumer__c.Name From Consumer__c where Consumer__c.Name =: Sol ];
Database.update(Con);
}
This works fine for Sol = '0000000042' (in comments) but not for a dynamic, the id which is valid when we edit the specific Solution record and everyone which has the same parent Cunsumer.
Any Help really appreciated.
Stefanos
Have you tried using Solution.Consumer__r.Id instead of Solution.Consumer__c?
I tried but it does not work...
trigger AutoUpdateConsumer on Solution (after insert,after update) {
List<Solution> S = [Select Solution.Consumer__r.id From Solution];
// String Sol = '0000000042';
id Sol = S[0].Consumer__r.id;
List<Consumer__c> Con = [Select Consumer__c.Name From Consumer__c where Consumer__c.Name =: Sol ];
Database.update(Con);
}
Any suggestions?
Hi ,
The Consumer__c.name is text type field if you are storing id in the text field than you can tyr this.
this will give record.
String Sol = S[0].Consumer__c;
List<Consumer__c> Con = [Select Consumer__c.Name From Consumer__c where Name =: Sol ];
But if you use this wil not retrun any value.
Id Sol = S[0].Consumer__c;
List<Consumer__c> Con = [Select Consumer__c.Name From Consumer__c where Name =: Sol ];
Thanks
Ashlekh
If this post helps you than please mark it as a solution and don't forget to give me kudo's .Thanks
Hi D-Horse,
I tried but did not work,
Actually what is needed is an iconic update/save to the parent custom object Consumer__c, whenever an edit happens in one of its children the standard Solution.
If htere is a simpler way I would really appreciate.
Many thanks,
Stefanos
Hi,
Please tell me your object name and relationship between them and then what doo you want todo, and what type of error you are facing.
I think i am not getting your point so please provide this info then may be i will help you.
Hi,
Relationship:
1 Consumer__c to many Solution(s)
Custom to Standard object.
I want to update a points field in the Consumer whenever we have an addition of points in the standrad Solutions.
This now is only achievable if we edit/save the record in the Consumer__c.
I want to simulate an edit /save when a record in Solution related to the consumer__C is edited/saved.
Many thanks,
Stefanos