You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Helio S. P. (JIRA)" <ji...@apache.org> on 2007/05/15 18:29:16 UTC
[jira] Created: (JCR-923) Supporte arithmetic Operators on search
Supporte arithmetic Operators on search
---------------------------------------
Key: JCR-923
URL: https://issues.apache.org/jira/browse/JCR-923
Project: Jackrabbit
Issue Type: New Feature
Components: query
Affects Versions: 1.3
Reporter: Helio S. P.
Priority: Minor
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:
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.
The example was based on http://www.w3.org/TR/xquery-operators/#func-add-yearMonthDurations
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JCR-923) Support arithmetic Operators on search
Posted by "Helio S. P. (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Helio S. P. updated JCR-923:
----------------------------
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
was:
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:
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.
The example was based on http://www.w3.org/TR/xquery-operators/#func-add-yearMonthDurations
> Support arithmetic Operators on search
> --------------------------------------
>
> Key: JCR-923
> URL: https://issues.apache.org/jira/browse/JCR-923
> Project: Jackrabbit
> Issue Type: New Feature
> Components: query
> Affects Versions: 1.3
> Reporter: Helio S. P.
> Priority: Minor
>
> 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
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JCR-923) Support arithmetic Operators on search
Posted by "Helio S. P. (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Helio S. P. updated JCR-923:
----------------------------
Summary: Support arithmetic Operators on search (was: Supporte arithmetic Operators on search)
> Support arithmetic Operators on search
> --------------------------------------
>
> Key: JCR-923
> URL: https://issues.apache.org/jira/browse/JCR-923
> Project: Jackrabbit
> Issue Type: New Feature
> Components: query
> Affects Versions: 1.3
> Reporter: Helio S. P.
> Priority: Minor
>
> 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:
> 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.
> The example was based on http://www.w3.org/TR/xquery-operators/#func-add-yearMonthDurations
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JCR-923) Support arithmetic Operators on search
Posted by "Jukka Zitting (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jukka Zitting updated JCR-923:
------------------------------
Affects Version/s: (was: 1.3)
I guess that at least the stated use case can just as well be achieved by programmatically calculating the correct right hand side value when creating the query string, so I wouldn't put high priority on this issue. However, if we ever start supporting more complex XQuery constructs, then supporting also functions like this would be a nice touch.
> Support arithmetic Operators on search
> --------------------------------------
>
> Key: JCR-923
> URL: https://issues.apache.org/jira/browse/JCR-923
> Project: Jackrabbit
> Issue Type: New Feature
> Components: query
> Reporter: Helio S. P.
> Priority: Minor
>
> 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
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.