[JCR-923] Support arithmetic Operators on search

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: jackrabbit-core, query
• Assignee: Unassigned
• Reporter: Helio S. P.
• Created: 15/May/07 16:28
• Updated: 17/Oct/08 10:07

Description

The query languages should support arithmetic operators over propertie values.

Example 1: find all nodes with a date property foo with date value plus some time duration that is greater than today (or another date propertie):

In XPath that's:

//*[op:add-yearMonthDurations(@foo,xs:yearMonthDuration("P3Y3M")) > xs:dateTime('2006-12-31T00:00:00.000Z')]

it was added 3 years and 3 months in the date value present in propertie foo and made the comparison during the query.
The example was based on http://www.w3.org/TR/xquery-operators/#func-add-yearMonthDurations