jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Sascha.The...@innovations.de>
Subject Query to list all locked nodes
Date Thu, 07 Oct 2010 08:30:30 GMT
Hi all,


is it possible to create a SQL query to select all locked or not locked


I am currently using this query to search for locked nodes:


SELECT * FROM nt:base WHERE jcr:lockOwner IS NOT NULL


And this query to search for not locked nodes:


SELECT * FROM nt:base WHERE jcr:lockOwner IS NULL


I have problems with deeply locked nodes. This nodes may not have a lock
owner but are also locked because their parent is locked.


Is there a way to create queries to search only for locked/not locked


Thanks an advance,

Sascha Theves
Platform and Technology (INST/EPI)

Innovations Software Technology
Bosch Group
Ziegelei 7, 88090 Immenstaad, Germany
Telefon: +49(0)7545-202-537
Fax:       +49(0)7545-202-301
www.innovations.de <http://www.innovations.de/> 

Executives: Achim Berger, Thomas Cotic, Thomas Schmid
Register Court Ulm HRB 631888

This message may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please inform us immediately and
destroy this message including all copies thereof.


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message