2 Replies Latest reply on Feb 13, 2018 7:13 PM by ripunjoy

    Export group members along with their joining date?

    ripunjoy
    ripunjoy Feb 13, 2018 6:59 AM

      Hi - I am trying to export the members of a Group along with their joining dates. While the data exists (Manage->Members each member's join date appears) there is no way to export that data along with the joining date. Does any body know if we can get this information from the Database? If yes, which table to refer to? Please advice.

       

      Thanks!

       

      Best,

      Ripunjoy

      • 382 Views
      • Tags:
        • Re: Export group members along with their joining date?
          Caton Guilbault
          Caton Guilbault Feb 13, 2018 8:44 AM (in response to ripunjoy)

          Hi Ripunjoy,

           

          I think this is the query your looking for:

           

          SELECT

               jivesgroup.name,

               jiveuser.username,

               to_timestamp(jivesgroupmember.creationdate/1000) as JoinDate,

               CASE

                    WHEN jivesgroupmember.membertype = 0 THEN 'Admin'

                    WHEN jivesgroupmember.membertype = 1 THEN 'Member'

                    WHEN jivesgroupmember.membertype = 2 THEN 'Awaiting_Decision'

                    WHEN jivesgroupmember.membertype = 3 THEN 'Banned'

                    WHEN jivesgroupmember.membertype = 4 THEN 'Invited'

                    ELSE 'CustomMemberType'

               END AS MemberTypeDecoded,

               jiveuser.userenabled

           

          FROM jivesgroup

          LEFT JOIN jivesgroupmember on jivesgroup.groupid = jivesgroupmember.groupid

          LEFT JOIN jiveuser on jivesgroupmember.userid = jiveuser.userid

           

          ORDER BY  jivesgroup.name asc

          4 people found this helpful