Forum OpenACS Q&A: How to get all package_id's of classes/communities and subgroups?

Collapse
1: How to get all package_id's of classes/communities and subgroups?
Posted by Nima Mazloumi on 04/13/04 04:17 PM
I have problems with getting all package_ids of calendars that belong to either a class or community or subgroup as a list.

Can someone kindly help me out?

Greeings,
Nima

Collapse
2: Re: How to get all package_id's of classes/communities and subgroups? (response to 1)
Posted by Barry Books on 04/14/04 01:27 PM
check out site_node::get_children. It returns urls which can be converted to a package_id with site_node::get_from_url (or others)
Collapse
3: Re: How to get all package_id's of classes/communities and subgroups? (response to 1)
Posted by Harish Krishnan on 04/14/04 06:51 PM
I found a table dotlrn_community_applets which is maintaining a mapping of  packages per commmunity:
check dotlrn/sql/oracle/applets-create.sql. May be that can help...

regards
Harish

Collapse
4: Re: How to get all package_id's of classes/communities and subgroups? (response to 1)
Posted by Nima Mazloumi on 04/15/04 01:24 PM
Hi Barry, hi Harish, thank you very much for your hints. That was very helpful.