0 Replies Latest reply on May 5, 2011 1:08 PM by hrshah

    question on blogpost activity

      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;