[SalesForce] Find Parent Event of Child Event

Problem Statement

Show a list of events on visualforce page, and give ability to respond as accept/reject/maybe.

Scenario:

3 users are participating in an event.
Event is created by a user named "Ab Jindal" and he invites two other sfdc users i.e. "Ab Dev" and "Sm Dev"
Here is event data with parent event and eventrelations created for owner "Ab Jindal"
EventRelation table data for this event:

From above screenshots, its clear that one needs Parent Event Id to update any EventRelation. Even if we try to hack and create a new EventRelation record via invited user i.e. "Ab Dev" or "Sm Dev", it will fail. Here is sample failure code

EventRelation er = new EventRelation(
                           RelationId = UserInfo.getUserId()  ,  
                           EventId = '00U2000000VcrubEAB',
                           Status = 'Declined'
                     );

insert er;

Here is the error which comes on executing above code:

System.DmlException: Insert failed. First exception on row 0; first
error: INVALID_OPERATION, You cannot create an Event Relation with a
child event.: [EventId]

So, I wanted to know either of following two questions:

How we can get parent event id from a child event ?
Or, how to update child event with accept/decline/maybe info ?

Similar Questions

On researching found this post which is somewhat close to my challenge, but is not having correct resolution.

Best Answer

Event Relation records to be inserted always with status as "New" but, later it can be updated to "Accepted" or "Declined" .

Insert :

EventRelation er = new EventRelation( RelationId = UserInfo.getUserId() ,
EventId = '00U2000000VcrubEAB', Status = 'New' );

insert er;

Update :

Get event id from event object. Then query to Event Relation and get the id(event relation record id) ;

EventRelation er = new EventRelation( Id = "EventRelation rec id",
Status = 'Declined' );

update er;

Related Solutions

[SalesForce] Lightning Components: Firing a nested/child component’s methods from the super/parent component

I guess the application events should just work .I feel you are messing a bit with the syntax .

Lets try correcting it

The application events are fired as below

//super-component_controller.js
 ({
  fireEvent: function(component){
  var myEvent = $A.get("e.c:myEvent");
  myEvent.fire();
  console.log('event fired');
  }
})

Nested component handling

<!-- nested-component -->
<aura:component>
   <aura:handler event="c:myEvent" action="{!c.gotEvent}" />
<aura:component>

If you look at this carefully ,couple of key points

1. Application events are fired using global $A variable

2.The name on the registration component for aura:register is mandatory but its not used any where else .

[SalesForce] Event parent relationship fields are null in trigger

This problem has a very simple solution, but first we need to understand the reason. You are using trigger context variables in iteration and trigger context variables i.e. trigger.new, trigger.old etc. do not query value of relationship field. So you can access e.AccountId, e.WhoId but not e.Account.Name or e.Who.Name. This is applicable to all triggers not just code that you have written.

To solve this problem you have two options:

If you are in a after trigger, which you are in current situation you can write a query on your base object(Event) and query all fields that you need including relationship fields. so your code will be something like this:

trigger TripMeetingFromMeeting on Event (after insert, after update) 
{
    Set<id>EventId = new Set <ID>();
    List<Trip_Meeting__c> TMS = new List <trip_meeting__c>();
    List<Event> events = [Select Id, Business_Trip__c, ActivityDate, Subject, Business_Trip__r.name, e.Whatid, Account.Name, Who.Name From Event Where Id in : trigger.new];
    for (Event E: events){
        if (e.Business_Trip__c!=null){
            TMS.add(new Trip_Meeting__c(Meeting__c =e.id, Business_trip__c=e.Business_Trip__c,
                                Meeting_Date__c=e.ActivityDate, Meeting_subject__c=e.Subject,
                               TripNameDELETE__c=e.Business_Trip__r.name,
                                mWhatID__c=e.Whatid,
                               Meeting_Company__c=e.Account.name,
                               Meeting_Name__c=e.Who.name)
                                );

        }
    }
    system.debug('TMS!!!============================'+TMS);
    Database.insert(tms, false);
}

If you are in a before trigger, you need to process in three step, pre-process, query, post-process.

(a) Pre-Process - Build a set of Id for each related object that you want to access e.g. Account, User etc.

(b) Query - Write a query for each object and assign result to Map, where sobject should be your real object e.g. Account, User etc.

Map<Id, Account> accountMap = new Map<Id, Account>([Select Id, Name From Account Where Id in: accountIds]);

(c) Post-Process - In this step you iterate on trigger context variables and when it comes to access related object field you located that object from Map created in query step and access related field.

account.get(e.AccountId).Name;

Best Answer

Related Solutions

[SalesForce] Lightning Components: Firing a nested/child component’s methods from the super/parent component

[SalesForce] Event parent relationship fields are null in trigger

Related Topic