Forum OpenACS Development: Re: new-portals: package_id's - where are they from?

Collapse
3: Re: new-portals: package_id's - where are they from? (response to 2)
Posted by Dirk Gomez on 08/15/03 01:20 PM
Alas, above query is wrong. So how can I retrieve the package_id parameteter. Here's another query that also looks promising - but is faulty as well: 
select pem.element_id
            from portal_element_map pem,
                 portal_pages pp, portal_datasources pd,
                 portal_element_parameters pep
            where pp.portal_id = 2536537 --:portal_id
            and pem.datasource_id = pd.datasource_id
            and pem.page_id = pp.page_id
        and pem.element_id = pep.element_id
            and pd.name = 'forums_portlet';