Apex Code Development You need to sign in to do that
Don't have an account?
AK_Smith Compare results of 2 SOQL requests
Hello!
I have 2 objects PA__c and journal__c
I need to create a new record on object stat__c and write results to the fields.
stat__c .Field1__c. If there any journal__c created within 30 min after first PA__c (datetime field Start_date__c) than Field1__c = yes
stat__c .Field2__c. If there any journal__c created within 8 hours after last PA__c (datetime field Start_date__c) than Field2__c = yes
The trigger should be schedulable
I have 2 objects PA__c and journal__c
I need to create a new record on object stat__c and write results to the fields.
stat__c .Field1__c. If there any journal__c created within 30 min after first PA__c (datetime field Start_date__c) than Field1__c = yes
stat__c .Field2__c. If there any journal__c created within 8 hours after last PA__c (datetime field Start_date__c) than Field2__c = yes
The trigger should be schedulable