File: index-postgresql.xql

package info (click to toggle)
dotlrn 2.5.0%2Bdfsg2-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd, stretch
  • size: 109,504 kB
  • ctags: 21,125
  • sloc: tcl: 219,608; sql: 202,152; xml: 127,658; java: 7,268; php: 4,780; sh: 2,180; perl: 1,207; makefile: 110
file content (24 lines) | stat: -rw-r--r-- 521 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="calendar_list">      
      <querytext>
      
    select     calendar_id, 
               calendar_name
    from       calendars
    where      owner_id = :user_id
    and        acs_permission__permission_p(
                  calendar_id, 
                  :user_id,
                  'calendar_admin'
               ) = 't'
    order by   calendar_name

      </querytext>
</fullquery>

 
</queryset>