+ Start a Discussion
lavanya mulpurilavanya mulpuri 

Query data that's displayed in the LIST VIEW for ACTIVITY object

HI All,

Need to query the data that's displayed here

As you can see the image above, It's list of records from Activity List View. How can I query all the TASK records that are getting displayed in this ListView.

Trying to implement, this functionality because, LEX doesn't support Activity List View

Thanks in advance!

Best Answer chosen by lavanya mulpuri
v varaprasadv varaprasad
Hi Lavanya,

Please check query :
SELECT Id,DeveloperName,name FROM ListView WHERE SObjectType = 'Activity'

SELECT Id,DeveloperName,name FROM ListView WHERE SObjectType = 'Activity' and DeveloperName = 'TodaysTasks'


SELECT Id,DeveloperName,name FROM ListView WHERE SObjectType = 'Task' and DeveloperName = 'TodaysTasks'

More Info : 

https://salesforce.stackexchange.com/questions/167009/can-we-access-all-listview-records-of-any-object-using-listview-id/167011
https://developer.salesforce.com/forums/?id=906F000000096ONIAY



Hope this helps you.


Thanks
Varaprasad
@For Support: varaprasad4sfdc@gmail.com

All Answers

v varaprasadv varaprasad
Hi Lavanya,

Please check query :
SELECT Id,DeveloperName,name FROM ListView WHERE SObjectType = 'Activity'

SELECT Id,DeveloperName,name FROM ListView WHERE SObjectType = 'Activity' and DeveloperName = 'TodaysTasks'


SELECT Id,DeveloperName,name FROM ListView WHERE SObjectType = 'Task' and DeveloperName = 'TodaysTasks'

More Info : 

https://salesforce.stackexchange.com/questions/167009/can-we-access-all-listview-records-of-any-object-using-listview-id/167011
https://developer.salesforce.com/forums/?id=906F000000096ONIAY



Hope this helps you.


Thanks
Varaprasad
@For Support: varaprasad4sfdc@gmail.com
This was selected as the best answer
v varaprasadv varaprasad
Hi Lavanya,

Use below extension to export your listviews ; 

https://chrome.google.com/webstore/detail/salesforce-data-exporter/fimhgbeiaffioifgjfcfjnphifipknao?hl=en


Thanks
Varaprasad
@For Support: varaprasad4sfdc@gmail.com