Let's say I essentially want to create a list of all the users who have ever been active in a space--that is, viewed the overview page, as well as any documents, blog posts, or discussions.
What is the best way to use the DES to do this currently? I believe right now I actually need to do two queries and then collate the information:
(1) if I filter by destination.name, I can get all the activities in a space. But this will not include viewing the overview page, which I believe is ACTIVITY_VIEW_COMMUNITY.
To get those activities I also need to (2) separately filter by destinationactionobject.Name
Then, I need to combine the data to get a list of all active users.
Is there a simpler way to do this, preferably with a single query?