6117 2008-09-25 09:54:09 +0000 [XQuery11UC] Windowing use case Q7 - error in logic 2009-02-17 16:04:27 +0000 1 1 1 Unclassified XPath / XQuery / XSLT XQuery 3.0 Use Cases Working drafts PC Windows NT CLOSED FIXED P2 normal --- 1 mike tim jim.melton tim xfranc public-qt-comments oldest_to_newest 22042 0 mike 2008-09-25 09:54:09 +0000 The solution to windowing use case Q7 (3.15.7) does not seem to handle the case where Anton enters the building, leaves, enters again, and then Barbara enters. A new window should open each time Anton enters even if the conditions for closing the previous window have not been satisfied. 22482 1 xfranc 2008-11-19 23:33:40 +0000 Indeed, Michael. Here is a proposal for a solution: <result>{ for sliding window $w in $seq/stream/event start $s when $s/person = "Anton" and $s/direction = "in" only end $e when $e/person = "Barbara" and $e/direction = "in" where xs:dateTime($e/@time) - xs:dateTime($s/@time) < xs:dayTimeDuration("PT1H") return <warning time="{ $e/@time }">Barbara: Anton arrived 1h ago</warning> }</result> Notice the "sliding" instead of tumbling. Probably the "where" could also be replaced by a "and" with the "only end" condition. 23411 2 tim 2009-02-03 12:14:55 +0000 The solution from Franc might cause several notifications. I would propose: declare variable $seq := fn:doc("person_events.xml"); <result>{ for tumbling window $w in $seq/stream/event start $s when $s/person eq "Anton" and $s/direction eq "in" only end $e next $n when xs:dateTime($n/@time) - xs:dateTime($s/@time) gt xs:dayTimeDuration("PT1H") or ($e/person eq "Barbara" and $e/direction eq "in") or ($e/person eq "Anton" and $e/direction eq "out") where $e/person eq "Barbara" and $e/direction eq "in" return <warning time="{ $e/@time }">Barbara: Anton arrived 1h ago</warning> }</result> 23793 3 tim 2009-02-17 15:32:37 +0000 For the current working draft I used my solution and I mark this bug FIXED. Mike, if you agree with my solution, please mark it CLOSED.