a question about jcr:path in queries.
Consider the following query:
SELECT base.[jcr:path], content.[jcr:lastModified],
content.[jcr:lastModifiedBy] FROM [nt:base] as base LEFT OUTER JOIN
[nt:resource] as content ON ISCHILDNODE(content, base) WHERE
((base.[jcr:primaryType] = 'nt:file' OR base
On Nov 19, 2013, at 19:15 , Datenheld datenh...@gmx.de wrote:
Hi Alex,
first of all - thank you for the reply.
There must be some sort of Davex limitation because Row.getPath() does
trigger another roundtrip for the query I mentioned (JR 2.6.4 libraries,
although I fetched some jars
Just for documentation purposes (as no one seems to care on this list).
Maybe some day this will help someone who searches for a problem like
this via google.
As stated before you cannot query [jcr:path] via JCR SQL2 with
Jackrabbit 2.6.4 if you use a JOIN. You have to fetch if separately
On 17.11.2013, at 11:30, Datenheld datenh...@gmx.de wrote:
Hi again,
here's a question about jcr:path in queries.
Consider the following query:
SELECT base.[jcr:path], content.[jcr:lastModified],
content.[jcr:lastModifiedBy] FROM [nt:base] as base LEFT OUTER JOIN
[nt:resource
Hi again,
here's a question about jcr:path in queries.
Consider the following query:
SELECT base.[jcr:path], content.[jcr:lastModified],
content.[jcr:lastModifiedBy] FROM [nt:base] as base LEFT OUTER JOIN
[nt:resource] as content ON ISCHILDNODE(content, base) WHERE
((base.[jcr:primaryType
On 19.09.2013, at 15:28, Stanislav Orlenko orlenko.s...@gmail.com wrote:
How to implement similar select with JCR 2.0?
select * from cq:Page where jcr:path =
'/content/company/%/support/downloads'
I cannot find something like a pseudo-property jcr:path for JCR 2.0
First of all and most
How to implement similar select with JCR 2.0?
select * from cq:Page where jcr:path =
'/content/company/%/support/downloads'
I cannot find something like a pseudo-property jcr:path for JCR 2.0
Thanks
On Thu, Jul 29, 2010 at 00:12, Alejandro Gomez
alejandro.go...@gmail.com wrote:
Hi everyone,
I'm using jackrabbit 2.1.0, and jcr-sql2 for queries.
I have read in past emails that ...SQL-2 does not support the jcr:path
pseudo
property, which is only present in JCR 1.0 SQL.
Now, I would
, 2010 at 00:12, Alejandro Gomez
alejandro.go...@gmail.com wrote:
Hi everyone,
I'm using jackrabbit 2.1.0, and jcr-sql2 for queries.
I have read in past emails that ...SQL-2 does not support the jcr:path
pseudo
property, which is only present in JCR 1.0 SQL.
Now, I would like to know how can
Hi everyone,
I'm using jackrabbit 2.1.0, and jcr-sql2 for queries.
I have read in past emails that ...SQL-2 does not support the jcr:path pseudo
property, which is only present in JCR 1.0 SQL.
Now, I would like to know how can I do (if possible) to reference to a
node's path, for example, I
Hi,
in my workspace I'm trying to find all my sicr:document(s) (nodetype
children of nt:file) which filename property contains the passed string
So, for test, I've executed the following query:
SELECT * FROM sicr:document WHERE jcr:path LIKE '/SicrelFolder/test.txt'
Even if I used the LIKE
Sunday 22 March 2009 23:34:21 Jukka Zitting написав:
Hi,
On Sun, Mar 22, 2009 at 10:13 PM, Alexander Klimetschek
aklim...@day.com wrote:
On Sun, Mar 22, 2009 at 6:09 PM, Daniel Manzke
daniel.man...@googlemail.com wrote:
is it possible to use the pseudo-property jcr:path in XPath? I
Hi,
is it possible to use the pseudo-property jcr:path in XPath? I want to use
it to add additional paths where I want to search.
Thanks for helping :),
Daniel
Hi,
On Sun, Mar 22, 2009 at 10:13 PM, Alexander Klimetschek
aklim...@day.com wrote:
On Sun, Mar 22, 2009 at 6:09 PM, Daniel Manzke
daniel.man...@googlemail.com wrote:
is it possible to use the pseudo-property jcr:path in XPath? I want to use
it to add additional paths where I want to search
Hi,
sbarriba wrote:
I've included some background below but my question is. is using
jcr:path in a query to be avoided due to performance?
I'd say, it depends on the query and the content structure you have. but in
general, path constraints are more expensive than constraints on properties
Hello Shaun,
Regarding avoiding path constraints queries taking long, you might
(will) also win a lot by making the where clause only a little more
specific. So, if you keep you where path constraint, but, at the same
time, add at you 'category nodes' like '/sport' or '/entertainment' a
mixin for
8d1c00807300458tabfbf6am5dab26204ac12...@mail.gmail.com%3e.
Regards,
Shaun
-Original Message-
From: Ard Schrijvers [mailto:a.schrijv...@onehippo.com]
Sent: 26 January 2009 09:25
To: users@jackrabbit.apache.org
Subject: RE: Is using jcr:path in a query a performance bottleneck?
Hello Shaun,
Regarding avoiding path
Hi all,
I've included some background below but my question is. is using
jcr:path in a query to be avoided due to performance?
We have some Jackrabbit repositories which have grown to include circa
200,000 nodes of a acme:Story. The nodes have been structured in a deep
hierarchy to comply
the name. then you can write:
select * from ns:type where jcr:path like '/foo/bar/%' and upper(ns:name) =
'FOOBAR'
And, last but not least, there is a way to specify a soundslike concept,
always using jcr:path?
this also requires that the node name is available as a property. then you can
jcr:path LIKE '/foo/bar/%/foobar'
However, if the node is stored as FOOBAR, Foobar, fooBar or so on, searching
will not return any result. Is there a way to make this search case insensitive?
And, last but not least, there is a way to specify a soundslike concept,
always using jcr:path?
Thank you
and sql, but without sucess.
Well, in the url
http://people.apache.org/~mreutegg/jcr-query-translator/translator.html, I
post the following xpath:
/jcr:root/A/element(*,my:type)[(@jcr:path!='/A/B')]
and in SQL Query box appears:
SELECT * FROM my:type WHERE jcr:path '/A/B' AND jcr:path LIKE
sbarriba wrote:
Has anyone hit issues with running a query like
select * from acme:Object where jcr:path LIKE '/home/folder1/%' or jcr:path
LIKE '/home/folder2/%'
jackrabbit does not support these kind of queries. Using SQL in jackrabbit you
can basically restrict the scope
Hi;
I saw in another thread in this forum a post that I can do a query like
this:
select * from nt:base where jcr:path = '/MyFolder/MyNode' OR
jcr:path='MyFolder/MyOtherNode'.
But when I try it I get an error:
Invalid combination of jcr:path clauses
But, It would to work, doesn't it?
Att
Helio
23 matches
Mail list logo