I am not able to query the customs fields in activity (image below), I can see and query Task and Events, as this objects are called Task and Event, but I cant find the activity one, I have look everywhere in the force.com explorer but no success
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
you can only run your SOQL queries either on Tasks or Events..
Select Id,YourCustomField__c from Task Select Id,YourCustomField__c from Event
I believe Activities/Activity is a single logical object type holding both Tasks & Events.. and Tasks and Events are the concrete physical object types that you can run your queries on..
Activities Custom fields is one common place for creating custom fields for both Tasks & Events..
you can also run queries on OpenActivities object related to a particular object (like Lead, Account..)
I tried doing it the other way around, I just need to apply a filter to only show the Personal Object with activities and not all of the records.
SELECT Id, Name, (SELECT Id, Subject FROM Tasks),(SELECT Id, Subject FROM Events), (SELECT Id, Subject FROM ActivityHistories) FROM Personal__c LIMIT 1000