Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 50694 invoked from network); 28 Mar 2007 11:11:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 28 Mar 2007 11:11:42 -0000 Received: (qmail 73407 invoked by uid 500); 28 Mar 2007 11:11:46 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 73318 invoked by uid 500); 28 Mar 2007 11:11:46 -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 73276 invoked by uid 99); 28 Mar 2007 11:11:46 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=FROM_NO_LOWER X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from [194.8.61.2] (HELO mailslot1.tirol.gv.at) (194.8.61.2) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Mar 2007 04:11:45 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: Search Question Date: Wed, 28 Mar 2007 13:10:54 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Search Question Thread-Index: AcdxKcCywWjSyexqTJaanxKlp0JzrQ== From: =?iso-8859-1?Q?K=D6LL_Claus?= To: X-OriginalArrivalTime: 28 Mar 2007 11:10:58.0168 (UTC) FILETIME=[C2F36F80:01C77129] X-Virus-Checked: Checked by ClamAV on apache.org i have added a text file to my workspace and it contains the word "car" = with the sql search SELECT * FROM nt:base WHERE contains(*, 'car')=20 a node will be found the node path is /test.txt/jcr:content But if i try to combine the full text search with a single property to = limit the search result it does not work SELECT * FROM nt:base WHERE contains(*, 'car') and my:createuser =3D = 'admin' The node structure looks like /test.txt (nt:file) -my:createuser (Mixin) - .. some properties /jcr:content (nt:resource) -jcr:mimetype -jcr:lastModified -jcr:data -.... Is it possible to limit a full text search ? thanks for help claus