I am not sure if I am approaching my problem the right way, maybe not, so I will give a very brief explanation of what I am trying to achieve:
Currently I have 2 communities, Community 1 is focused on making calls and it has 2 sort of users internal and external. The external users will make an specific type of calls and the second type of users will follow up this calls. After the external users made the call I am creating an event, that looks something like:
Assigned to: Person who made the call (external user)
custom field: an specific value
The internal user, should be able to see a list of all activities made by all the external users, so I am trying to do something like:
SELECT Subject, Id, What.Id, Custom_Field__c FROM Event WHERE Custom_Field__c = 'an specific value'
However this only displays if the event is assign to the current log in user. I need to be able to display all the events, regardless of who is assigned to it.
On community 2, is more for sales people who eventually will need to see the list of all this events created
So I am not really sure what I am missing, the class the I am using is set like:
public without sharing
THe following are the options that I have from Sharing Settings in setup, I dont have that option. My Salesforce is the enterprice, and this image was taking from admin user