[samigo-team] [Building Sakai] Samigo Release To Select Groups

[Shawn Foster]

Thanks, Karen! That's the part I was looking for.

For anyone else interested, this query looks up those agent ids/group 
ids from Karen's query to get the group's name:

select * from sakai_site_group where group_id = '##agendid##';

Thanks,
-Shawn

On 14-04-07 1:37 PM, Karen Tsao wrote:
> Hi Shawn,
>
> Please use this query to find groups:
>
> select * from SAM_AUTHZDATA_T where FUNCTIONID='TAKE_PUBLISHED_ASSESSMENT'
> and QUALIFIERID=:published_assessment_id
>
> Thanks,
> Karen
>
>
>
> On Mon, Apr 7, 2014 at 9:20 AM, Shawn Foster <sfoster9 at uwo.ca> wrote:
>
>> Hi,
>>
>> I'm trying to investigate a data issue for one of our users. In the
>> "sam_publishedaccesscontrol_t" table the "releaseto" column says
>> "Selected Groups".
>>
>> Where in the database does Samigo save the list of groups that a
>> particular published assessment is released to? That is, where in the
>> database can I find the actual groups for a published assessment id?
>>
>> Thanks,
>> -Shawn
>>
>> --
>> Shawn Foster
>> Instructional Technology Support and Application Development
>> Information Technology Services
>> Western University
>> London, Ontario, Canada
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>