v.21.7Improvement
Add == Operator for Time Conditions in sequenceMatch and sequenceCount Functions
Add==operator on time conditions forsequenceMatchandsequenceCountfunctions. For eg: sequenceMatch('(?1)(?t==1)(?2)')(time, data = 1, data = 2). #25299 (Christophe Kalenzaga).
Why it matters
This feature allows users to specify exact equality conditions on timestamps within sequence pattern matching, enhancing expressiveness and precision in event sequence queries where exact time matches are required.How to use it
Use the== operator inside time conditions within the pattern string of sequenceMatch or sequenceCount. For example:SELECT sequenceMatch('(?1)(?t==1)(?2)')(time, data = 1, data = 2) FROM tableThis checks that the time condition is exactly equal to 1 between the matched events.