-
Re: Getting all activity in a given place
josh.richau Oct 30, 2014 12:45 PM (in response to jzawadzk)filtering to the place should work - what is the url you are trying?
-
Re: Re: Getting all activity in a given place
jzawadzk Oct 31, 2014 8:37 AM (in response to josh.richau)For example running ?filter=place(Help Group)&filter=activity(view)&after=2014-10-22&before=2014-10-23 has "totalCount" of 785. Daily Activity CMR shows that on the 22nd 1785 views took place.
-
Re: Re: Getting all activity in a given place
josh.richau Oct 31, 2014 11:09 AM (in response to jzawadzk)The CMR chart includes views from content in child projects - but for the API the views you are retrieving are for the content in the top level group. You would need to include the projects to match up the numbers.
-
Re: Re: Re: Getting all activity in a given place
jzawadzk Nov 3, 2014 3:24 AM (in response to josh.richau)Ok, so I did the following queries with the following results:
Query Count after=2014-10-22&before=2014-10-23&filter=match(activity.actionObject.name,Help Group)&filter=action(ACTIVITY_VIEW_SOCIALGROUP) 989 after=2014-10-22&before=2014-10-23&filter=place(Help Group)&filter=activity(view) 785 after=2014-10-22&before=2014-10-23&filter=match(activity.destination.name,Help Group)&filter=action(ACTIVITY_VIEW_PROJECT) 39 after=2014-10-22&before=2014-10-23&filter=place(Knowledge Base,Migration Center,Jive Demo)&filter=activity(view) 0 The last queries searches projects within the Help Group.
Views according to the CMR: 1785
So those queries hopefully cover everything that the CMR does. Now my numbers are slightly bigger than the ones from the CMR. Does it mean that CMR excludes some of those events? Or is it also counting some other ones as well?
Regards,
Jakub
-
Re: Getting all activity in a given place
dirk.mcnealy Nov 3, 2014 1:48 PM (in response to jzawadzk)As far as I can tell, the CMR report does not include the views on projects or sub groups. There were 11 events that were views on the social group which did not get widened. What this means is that we have the data for the place in hbase, but the action object in elasticsearch only contains the id's, not the social group name, so the name filtering does not work. I have opened a bug and am investigating why this is and how to make the data available for DES.
In the meantime, filtering on the id instead of the name will work. These filters will give you the 1000 views:
after=2014-10-22&before=2014-10-23&filter=match(activity.actionObject.objectId,1003)&filter=action(ACTIVITY_VIEW_SOCIALGROUP)
-
Re: Getting all activity in a given place
jzawadzk Nov 5, 2014 3:01 AM (in response to dirk.mcnealy)Thanks Dirk, at least we managed to find a bug with the DES.
Also a side question: should filter=place work with anything else apart from the place name? In Using the V2 Jive Data Export Service (Analytics) it says that the filter compares against all friendly fields, but I couldn't get it to work for the display name or the url of the place. Both filter=place(https://cisco.jiveon.com/groups/help) and filter=place(help) return no results. The destination object with friendly=true looks like this:
"Destination":
{
"Name": "Help Group",
"Status": "ACTIVE",
"ObjectType": "socialgroup",
"Url": "https://cisco.jiveon.com/groups/help",
"CreationDate": 1409074018257,
"DisplayName": "help"
}
-
Re: Getting all activity in a given place
dirk.mcnealy Nov 5, 2014 11:18 AM (in response to jzawadzk)You're right, that document is wrong. place(...) is a shortcut for match(activity.destination.name,...). I'll get that document updated.
-
Re: Getting all activity in a given place
jzawadzk Nov 6, 2014 2:25 AM (in response to dirk.mcnealy)Ok, thanks for the clarification!
-
-
-
Re: Getting all activity in a given place
jzawadzk Nov 6, 2014 5:09 AM (in response to dirk.mcnealy)Do you have a case number or anything else we can use to track progress of fixing the bug?
-
-
-
-
-
-
Re: Getting all activity in a given place
dirk.mcnealy Oct 31, 2014 2:02 PM (in response to jzawadzk)1 person found this helpfulYou are correct that it is the ACTIVITY_VIEW_SOCIALGROUP that are not showing up using the place filter. That socialgroup was viewed 1000 times in the time window, which accounts for the difference between the place filter and cmr. The reason for this is the place filter filters on the destination of the event, but in the case of viewing a socialgroup, the socialgroup is the action object. To get the views on your social group, use the following filters:
filter=match(activity.actionObject.objectType,socialgroup)&filter=match(activity.actionObject.name,Help Group)