Hi all,
is it possible to create a SQL query to select all locked or not locked nodes? 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 nodes? 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 [email protected] <BLOCKED::mailto:[email protected]> 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.
