Grouper Users - Open Discussion List

["Wang, Simon" <>]

Thanks Chris.

 

From your script, I got the enabled_time and disabled_time as: 1293868800000 1294473600000. Obviously, the disabled time is later than the enabled time, which means the current state is disabled.

 

Simon

 

From: [mailto:] On Behalf Of Chris Hyzer
Sent: January 19, 2011 3:43 PM
To: Wang, Simon;
Subject: [grouper-users] RE: start-date end-date not working with database query

 

Is the membership disabled or not enabled yet?  J

 

This query should give you enabled memberships:

 

SELECT group_name, subject_id

   FROM grouper_memberships_lw_v

  WHERE subject_id = 'AAA'

    AND list_name = 'members'

    AND group_name = 'BBB';

   

    

This query *should* give you enabled/disabled memberships and tell you why disabled, though Im not 100% sure J

 

SELECT gg.name group_name, subject_id, immediate_mship_enabled, immediate_mship_enabled_time, immediate_mship_disabled_time

   FROM grouper_memberships_all_v gmav, grouper_groups gg, grouper_members gm, grouper_fields gf

  WHERE gm.id = gmav.member_id

    AND gf.id = gmav.field_id   

    AND gmav.owner_group_id = gg.id

    AND subject_id = 'AAA'

    AND gf.name = 'members'

    AND gg.name = 'BBB';

 

 

Thanks,

chris

 

From: [mailto:] On Behalf Of Wang, Simon
Sent: Wednesday, January 19, 2011 5:27 PM
To:
Subject: [grouper-users] start-date end-date not working with database query

 

Hi,

 

When I tried to test Grouper 1.5.3 start-date end-date feature, after the “MAINTENANCE__enabledDisabled” cleanup, the membership was gone from Grouper UI, gsh, but using database query the membership still exists in the grouper_memberships_v view. The command I used was:

 

select group_name, subject_id

   from grouper_memberships_v

  where subject_id = 'AAA'

    and list_name = 'members'

    and group_name = 'BBB'

 

Can someone help me with this issue? I noticed that the context_id column is null. Is this the criteria needs to be used?

 

Thanks!

 

Simon Wang

 

________________________________________

Sr. Programmer Analyst

Information Technology - University of British Columbia

6356 Agricultural Road, Vancouver, BC, V6T 1Z2, Canada

Phone: 604-822-0387

Email: