Forum OpenACS Development: Re: Finding the package_id for cr_items

Collapse
2: Re: Finding the package_id for cr_items (response to 1)
Posted by Robert Locke on 05/26/03 01:04 PM
Hi Jarkko,

There is a table called "pa_package_root_folder_map" which links the photo-album package_id to a folder_id, which I imagine you could then link to the photos contained in that folder.  (I'm not sure why the package_id column of cr_folders was not used.  Perhaps the author was not aware of its existence.)

What happens if you don't include the "url" parameter?  Or is it required?  If not, maybe it could include a random photo from any installed photo album site-wide or subsite-wide.  Just a suggestion.

Thanks for taking on this work...

Collapse
3: Re: Finding the package_id for cr_items (response to 2)
Posted by Jarkko Laine on 05/26/03 01:40 PM
Hi Robert,

And thanks, I'll take a look at pa_package_root_folder_map.

The url parameter is optional and if let away defaults to all package instances (of the whole site at this point). I think that's good enough in most occasions and at least the query should be *fast* 😊