Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 44093 invoked from network); 20 Aug 2010 11:05:44 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 20 Aug 2010 11:05:44 -0000 Received: (qmail 59046 invoked by uid 500); 20 Aug 2010 11:05:44 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 58792 invoked by uid 500); 20 Aug 2010 11:05:41 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 58779 invoked by uid 99); 20 Aug 2010 11:05:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Aug 2010 11:05:41 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of aklimets@day.com designates 207.126.148.96 as permitted sender) Received: from [207.126.148.96] (HELO eu3sys201amo012.postini.com) (207.126.148.96) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 20 Aug 2010 11:05:32 +0000 Received: from source ([209.85.212.50]) by eu3sys201aob106.postini.com ([207.126.154.11]) with SMTP ID DSNKTG5hZXgFx//ujBoVMZyDsk+MCcf/x5+d@postini.com; Fri, 20 Aug 2010 04:05:12 PDT Received: by vws5 with SMTP id 5so3440692vws.37 for ; Fri, 20 Aug 2010 04:05:09 -0700 (PDT) MIME-Version: 1.0 Received: by 10.220.62.197 with SMTP id y5mr802043vch.3.1282301996236; Fri, 20 Aug 2010 03:59:56 -0700 (PDT) Received: by 10.220.185.202 with HTTP; Fri, 20 Aug 2010 03:59:56 -0700 (PDT) In-Reply-To: References: <004F9B11-F526-4BD9-B9E7-CF02F7E0205F@mac.com> <7C04B569-23D4-4CC4-BFA6-56E077C06C16@mac.com> Date: Fri, 20 Aug 2010 12:59:56 +0200 Message-ID: Subject: Re: select all nodes not having certain subnodes? From: Alexander Klimetschek To: users@jackrabbit.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org On Thu, Aug 19, 2010 at 15:15, Will Scheidegger wrote: > Thanks. Since I'm on Jackrabbit 1.6 SQL2 is not an option. I guess I'll have to do it programmatically although this is far less efficient. Not necessarily. But it might also make sense to create your own index for this lookup, if speed is important for this operation. You would then store some time-based node structure (like 2010/08/20, maybe also including the hours of the day if there are a lot of events) and hang in the rooms that have a reservation on that day / time span. Then you just have to scan this "day" node for any matches or non-matches. Regards, Alex -- Alexander Klimetschek alexander.klimetschek@day.com