Forum OpenACS Development: Live parties view

Collapse
Posted by Lars Pind on
We need a view which returns "live" parties, i.e., users and groups who aren't deleted or banned.

We need this for, among other things, /packages/acs- subsite/www/permissions/grant.tcl. (See also this but: https://openacs.org/sdm/one-baf.tcl?baf_id=1524).

I can infer from the cc_users view how to check for live status of users, but how do I do that for groups and get it into one common live_parties view? Anyone familiar enough with the data models to know?

/Lars

Collapse
Posted by Roger Williams on
Since groups cannot be un-"live" in the system, can't you just join cc_users with all of the groups?

Regards..

Collapse
Posted by Lars Pind on
Probably. I'll try that. Thanks.
Collapse
Posted by Lars Pind on
Alright, there's now a patch for this bug: https://openacs.org/sdm/one-patch.tcl?patch_id=247.

Could someone please test this on Oracle, then I'll go ahead and apply this patch to the development branch. /Lars

Collapse
Posted by Jon Pike on
Hi Lars,

Just tried this patch out on oracle .. obviously creating the grant-oracle.xql file from the tcl query, and does not error.  However it did show the banned users I have added into the system, but not the deleted ones.

Hope this helps

Jon

Collapse
Posted by Lars Pind on
Bugger. Looks like I'll have to do some testing myself.