8 Replies Latest reply on Jun 17, 2015 7:41 AM by jemjanik

    Finding the list of group created, date created, and creator

    jemjanik

      I think I'm in need of being pointed in the right direction.  I started with the activity_fact table figuring I could query  for create events where the direct object type was a social group and then go find out the info on the group and user from other tables.  I started with:

       

      select activity_ts, dw_container_id, user_id
      from jivedw_activity_fact
      where activity_type=20 and
      direct_object_type=700

       

      and the dw_container_id is null so joining up with the jivedw_container table.  Am I going down the wrong path here?