OpenACS / openacs-4 / packages / acs-subsite / lib

subsites.xql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 4
Last Commit: 13 Nov
Commits this week: 0
Total Lines of Code (LoC): 40
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -5
    • +2
    ./subsites.xql
  2. … 8099 more files in changeset.
Tuesday 15 Feb 2022
6:21 pm

gustafn

Fixes for Oracle 19c: boolean types in query

This fixes the following bug for Oracle:

[13/Feb/2022:17:53:36][8701.7f9f62f0b700][-conn:oacs-5-10-0:default:0:0-] Error: nsoracle.c:1367:OracleSelect: error in `OCIStmtExecute ()': ORA-00920: invalid relational operator

:

: SQL:

:

: select p.package_id,

: p.instance_name,

: n.node_id,

: n.name,

: :subsite_url || n.name as url,

: (select count(*)

: from group_approved_member_map m

: where m.rel_type = 'membership_rel'

: and m.group_id = ag.group_id) as num_members,

: (select min(r2.member_state)

: from group_member_map m2,

: membership_rels r2

: where m2.group_id = ag.group_id

: and m2.member_id = :untrusted_user_id

: and r2.rel_id = m2.rel_id) as member_state,

: g.group_id,

: g.join_policy

: from site_nodes n,

: apm_packages p,

: application_groups ag,

: groups g

: where n.parent_id = :subsite_node_id

: and p.package_id = n.object_id

: and p.package_key in ('acs-subsite')

: and ag.package_id = p.package_id

: and g.group_id = ag.group_id

: and (g.join_policy !>>>!!= 'closed' or acs_permission.permission_p(p.package_id, :untrusted_user_id, 'read'))

: order by lower(instance_name)

:

Options
    • -1
    • +2
    ./subsites.xql
Tuesday 09 Jul 2019
11:24 am

antoniop

Rework query to use permission api instead of just removed materialized views

Options
    • -5
    • +1
    ./subsites.xql
Saturday 02 Jul 2016
1:35 pm

gustafn

- reduce dependencies on acs_object_party_privilege_map (on PostgreSQL)

Options
    • -43
    • +0
    ./subsites.xql
  2. … 3 more files in changeset.
Friday 01 Jul 2016
3:47 pm

gustafn

- replace obsolete all_object_party_privilege_map by acs_object_party_privilege_map

Options
    • -1
    • +1
    ./subsites.xql
  2. … 12 more files in changeset.
Saturday 12 Mar 2005
11:59 pm

donb

Jeff's "anyone can be a subsite" patch came complete with an extra "]".

"acs-subite" doesn't match "acs-subsite]" ...

Options
    • -1
    • +1
    ./subsites.xql
Tuesday 08 Mar 2005
12:32 am

jeffd

missing close querytext

Options
    • -1
    • +1
    ./subsites.xql
Monday 07 Mar 2005
10:02 pm

jeffd

first part of tip 76 -- multiple packages as subsites adds a subsite::package_keys function for listing subsites, and uses it instead of hard coding acs-subsite all over

Options
    • -0
    • +43
    ./subsites.xql
  2. … 6 more files in changeset.