AnsweredAssumed Answered

Creating list of active users via DES

Question asked by mdcohn on Apr 12, 2017
Latest reply on Aug 21, 2017 by mdcohn

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, 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?