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?
SELECT jivedw_month."year", jivedw_month.month_of_year, jivedw_blogpost.subject, jivedw_activity_agg_month.activity_type, jivedw_activity_agg_month.activity_count FROM public.jivedw_activity_agg_month, public.jivedw_blogpost, public.jivedw_object, public.jivedw_month WHERE 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 ORDER BY jivedw_month."year" ASC, jivedw_month.month_of_year ASC, jivedw_blogpost.subject ASC;