I'm using following query to get counts of various activity types for blogpost content type.
Is it correct? Do I only include object types 37 and 38? are there any other object types that should be included in blogpost activity view...like comment, question, bookmark etc?
jivedw_activity_agg_month.direct_dw_object_id = jivedw_object.dw_object_id AND
jivedw_activity_agg_month.direct_object_type = jivedw_object.object_type AND
jivedw_activity_agg_month.month_id = jivedw_month.month_id AND
jivedw_object.object_id = jivedw_blogpost.blogpost_id AND
jivedw_object.object_type IN ('37','38') AND
jivedw_activity_agg_month.user_id != -1