You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by Dave Brosius <db...@mebigfatguy.com> on 2008/03/21 17:53:43 UTC
FW: Search for creation dates - help
OK, so i realized that i was missing a prefix for the deref method, so the new query is this
//*[@jcr:primaryType = 'prm:File' and jcr:deref(@jcr:baseVersion, nt:version)/jcr:content/@jcr:lastModified >= xs:dateTime('2000-01-01T00:00:00.000-05:00')] order by jcr:score() descending
now i'm getting an exception:
javax.jcr.query.InvalidQueryException: Unsupported location for jcr:deref()
at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.createFunction(XPathQueryBuilder.java:967)
at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.visit(XPathQueryBuilder.java:515)
at org.apache.jackrabbit.core.query.xpath.SimpleNode.jjtAccept(SimpleNode.java:80)
at org.apache.jackrabbit.core.query.xpath.SimpleNode.childrenAccept(SimpleNode.java:89)
at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.visit(XPathQueryBuilder.java:551)
at org.apache.jackrabbit.core.query.xpath.SimpleNode.jjtAccept(SimpleNode.java:80)
at org.apache.jackrabbit.core.query.xpath.SimpleNode.childrenAccept(SimpleNode.java:89)
at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.createExpression(XPathQueryBuilder.java:707)
at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.visit(XPathQueryBuilder.java:488)
[snip...]
I see a possibly similar bug that was fixed: JCR-338
-----Original Message-----
From: Dave Brosius <db...@mebigfatguy.com>
Sent: Thursday, March 20, 2008 7:15pm
To: users@jackrabbit.apache.org
Subject: Search for creation dates - help
I am trying to put together a query for when the creation date of a nt:file derived object is greater than some date. I've tried
//*[@jcr:primaryType = 'prm:File' and deref(@jcr:baseVersion, nt:version)/@jcr:lastModified >= xs:dateTime('2000-01-01T00:00:00.000-05:00')] order by jcr:score() descending
This doesn't seem to work at the moment, Am i off base here?
Re: FW: Search for creation dates - help
Posted by Marcel Reutegger <ma...@gmx.net>.
Hi Dave,
this is because jackrabbit does not support jcr:deref in a predicate. see:
https://issues.apache.org/jira/browse/JCR-977
regards
marcel
Dave Brosius wrote:
> OK, so i realized that i was missing a prefix for the deref method, so the new query is this
>
> //*[@jcr:primaryType = 'prm:File' and jcr:deref(@jcr:baseVersion, nt:version)/jcr:content/@jcr:lastModified >= xs:dateTime('2000-01-01T00:00:00.000-05:00')] order by jcr:score() descending
>
> now i'm getting an exception:
>
> javax.jcr.query.InvalidQueryException: Unsupported location for jcr:deref()
> at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.createFunction(XPathQueryBuilder.java:967)
> at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.visit(XPathQueryBuilder.java:515)
> at org.apache.jackrabbit.core.query.xpath.SimpleNode.jjtAccept(SimpleNode.java:80)
> at org.apache.jackrabbit.core.query.xpath.SimpleNode.childrenAccept(SimpleNode.java:89)
> at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.visit(XPathQueryBuilder.java:551)
> at org.apache.jackrabbit.core.query.xpath.SimpleNode.jjtAccept(SimpleNode.java:80)
> at org.apache.jackrabbit.core.query.xpath.SimpleNode.childrenAccept(SimpleNode.java:89)
> at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.createExpression(XPathQueryBuilder.java:707)
> at org.apache.jackrabbit.core.query.xpath.XPathQueryBuilder.visit(XPathQueryBuilder.java:488)
> [snip...]
>
> I see a possibly similar bug that was fixed: JCR-338
>
>
>
> -----Original Message-----
> From: Dave Brosius <db...@mebigfatguy.com>
> Sent: Thursday, March 20, 2008 7:15pm
> To: users@jackrabbit.apache.org
> Subject: Search for creation dates - help
>
> I am trying to put together a query for when the creation date of a nt:file derived object is greater than some date. I've tried
>
> //*[@jcr:primaryType = 'prm:File' and deref(@jcr:baseVersion, nt:version)/@jcr:lastModified >= xs:dateTime('2000-01-01T00:00:00.000-05:00')] order by jcr:score() descending
>
>
> This doesn't seem to work at the moment, Am i off base here?
>
>
>