2 # Check for REPORT calendar-query of VTODO within time range
5 URL=http://regression.host/caldav.php/user1/home/
6 HEADER=User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.8pre) Gecko/20071023 Sunbird/0.7
7 HEADER=Accept: text/xml
8 HEADER=Accept-Language: en-us,en;q=0.5
9 HEADER=Accept-Charset: utf-8,*;q=0.1
10 HEADER=Content-Type: text/xml; charset=utf-8
15 <?xml version="1.0" encoding="UTF-8"?>
16 <calendar-query xmlns:D="DAV:" xmlns="urn:ietf:params:xml:ns:caldav">
22 <comp-filter name="VCALENDAR">
23 <comp-filter name="VTODO">
24 <time-range start="20071101T110000Z" end="20080104T110000Z"/>
35 FROM calendar_item JOIN caldav_data USING (dav_id)
36 WHERE calendar_item.dav_name ~ '^/user1/home/'
37 AND caldav_data.caldav_type = 'VTODO'
38 AND (rrule IS NOT NULL OR dtstart IS NULL
41 (due IS NULL AND dtstart > '20071101T110000Z')
42 OR due > '20071101T110000Z'
44 AND dtstart < '20080104T110000Z'