-
Re: Export group members along with their joining date?
Caton Guilbault Feb 13, 2018 8:44 AM (in response to ripunjoy)3 people found this helpfulHi 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
-
Re: Export group members along with their joining date?
ripunjoy Feb 13, 2018 7:13 PM (in response to Caton Guilbault)Thanks much, Caton!
Best,
Ripunjoy
-