Return-Path: X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DC5BEDCAA for ; Tue, 4 Sep 2012 07:21:57 +0000 (UTC) Received: (qmail 76576 invoked by uid 500); 4 Sep 2012 07:21:54 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 76443 invoked by uid 500); 4 Sep 2012 07:21:52 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 76400 invoked by uid 99); 4 Sep 2012 07:21:50 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Sep 2012 07:21:50 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FSL_RCVD_USER,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mark.mandel@gmail.com designates 209.85.214.176 as permitted sender) Received: from [209.85.214.176] (HELO mail-ob0-f176.google.com) (209.85.214.176) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Sep 2012 07:21:45 +0000 Received: by obbtb18 with SMTP id tb18so13213026obb.35 for ; Tue, 04 Sep 2012 00:21:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=PtcMy816MyQsQza65w7DipVhmYSl+wqjSheFqzpL10w=; b=SupkVXMTXCkahnGaYic+98AW8N1Uw/NwYQx707q1IAGnfoEB9ftcZvc9dnYLOgXMqZ mvJEaQuLzANefU9VJ6mvTJ81/kdVQlhTmvrIW6FTsgGdRLaRDsoNNslnbNetUpVdd011 UQeURUucYN92CPGMHsUMweXtrACGvMObIw+qWZu0A2vFDzppnWYs5L2xS0DhlmkUAD0F ufI2JLOgVvY3LbuGnM6Ijew+B9HYaZGxizJ5OEwqTAI2R8tTsZgXfy97tP5GGQvzXOiv cPurgpiV8H641Maq/DVHIkSwGFAv5Z625MTPp+GU/WwqPenB86o8bk1DAu5sEgvcgZVD grBA== Received: by 10.60.5.194 with SMTP id u2mr15285776oeu.24.1346743284147; Tue, 04 Sep 2012 00:21:24 -0700 (PDT) MIME-Version: 1.0 Received: by 10.60.2.231 with HTTP; Tue, 4 Sep 2012 00:21:03 -0700 (PDT) From: Mark Mandel Date: Tue, 4 Sep 2012 17:21:03 +1000 Message-ID: Subject: Using a sum of fields in a filter query To: solr-user@lucene.apache.org Content-Type: multipart/alternative; boundary=e89a8ff2509e0e279104c8db1b55 --e89a8ff2509e0e279104c8db1b55 Content-Type: text/plain; charset=ISO-8859-1 Hey all, I have a series of fields with numeric values in my solr index. What I want to be able to do is the equivalent of something like below in my filter query (fq) parameter: sum(fielda, fieldb, fieldc):[0 to 100] So the sum of the fields is between 0 and 100. Is there some way to do this in SOLR on a FQ? I've hunted high and low and haven't been able to see the correct syntax for it. If someone could point me in the right direction, I would greatly appreciated it. Thanks! Mark -- E: mark.mandel@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com 2 Devs from Down Under Podcast http://www.2ddu.com/ --e89a8ff2509e0e279104c8db1b55--