Search code examples
salesforceapex-codevisualforcesoql

Getting List of Open Events in salesforce

i have to retrieve list of Open Events in salesforce i am using following method for getting list of open Events

public List<OpenActivity> getActivity1(){

Meeting_Master__c mmm= [SELECT (SELECT Subject,Location__c,EndDateTime,StartDateTime
                           FROM OpenActivities Where IsTask = false )
                   FROM Meeting_Master__c where Id =:ApexPages.currentPage().getParameters().get('id')];
return mmm.openActivities;
}

ok i got the list but i need event's StartDateTime field but it is an invalid field for OpenActivity please specify how to get list of OpenEvents in which StartDateTime is also included??

Solution

  • In this case you should use query to event object

     [SELECT Subject, 
         Location__c,
         EndDateTime,
         StartDateTime
 FROM Event 
 WHERE  WhatId =:ApexPages.currentPage().getParameters().get('id')];

    Hope this may help you