jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: Searching all versions and searching by label
Date Thu, 19 Feb 2009 08:17:07 GMT

2009/2/16 sunil.dmonte <sunil.dmonte@yahoo.com>:
> I need to do a property search in the following cases:
> 1) Search current and old versions of nodes in a subtree;
> 2) Search nodes having a given label in a subtree.
> In both cases, I can first find matching frozen nodes by doing a
> SELECT...WHERE... on nt:frozenNode. But after that I would need to do
> additional lookups on the jcr:frozenUuid property of *each* frozen node, to
> find the main path of the node, version number, label etc. There doesn't
> seem to be a way of getting this information in a single query - it appears
> to be an "n+1" kind of problem. Are there any alternatives to this approach?

you could store the path of the versionable node as a property when
you check it in.
that way you can query by that path property in the version storage.


View raw message