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 97A0898DC for ; Mon, 3 Oct 2011 19:43:02 +0000 (UTC) Received: (qmail 20742 invoked by uid 500); 3 Oct 2011 19:42:59 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 20674 invoked by uid 500); 3 Oct 2011 19:42:59 -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 20666 invoked by uid 99); 3 Oct 2011 19:42:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2011 19:42:59 +0000 X-ASF-Spam-Status: No, hits=2.3 required=5.0 tests=FREEMAIL_FROM,SPF_SOFTFAIL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of ajdabholkar@hotmail.com does not designate 216.139.236.26 as permitted sender) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Oct 2011 19:42:52 +0000 Received: from ben.nabble.com ([192.168.236.152]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1RAoPI-0008EN-7F for solr-user@lucene.apache.org; Mon, 03 Oct 2011 12:42:32 -0700 Date: Mon, 3 Oct 2011 12:42:32 -0700 (PDT) From: abhayd To: solr-user@lucene.apache.org Message-ID: <1317670952216-3390926.post@n3.nabble.com> Subject: sorting using function query results are notin order MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org hi I am trying to sort results from solr using sum(count,score) function. Basically its not adding things correctly. For example here is partial sample response "Count":54, "UserQuery":"how to", "score":1.2550932, "query({!dismax qf=UserQuery v='how'})":1.2550932, "sum(Count,query({!dismax qf=UserQuery v='how'}))":1.2550932}, how come addition of 54+1.2550932 is equla to 1.2550932 ?as if What i m doing wrong? here is my complete query ------------------------------------ http://localhost:10101/solr/autosuggest/select?q=how&start=0&indent=on&wt=json&rows=5&sort=sum%28Count,query%28{!dismax%20qf=UserQuery%20v=%27how%27}%29%29%20desc&fl=UserQuery,score,Count,query%28{!dismax%20qf=UserQuery%20v=%27how%27}%29,sum%28Count,query%28{!dismax%20qf=UserQuery%20v=%27how%27}%29%29&debug=true { "responseHeader":{ "status":0, "QTime":0, "params":{ "sort":"sum(Count,query({!dismax qf=UserQuery v='how'})) desc", "wt":"json", "rows":"5", "indent":"on", "fl":"UserQuery,score,Count,query({!dismax qf=UserQuery v='how'}),sum(Count,query({!dismax qf=UserQuery v='how'}))", "debug":"true", "start":"0", "q":"how"}}, "response":{"numFound":2628,"start":0,"maxScore":1.2550932,"docs":[ { "Count":54, "UserQuery":"how to", "score":1.2550932, "query({!dismax qf=UserQuery v='how'})":1.2550932, "sum(Count,query({!dismax qf=UserQuery v='how'}))":1.2550932}, { "Count":51, "UserQuery":"how to text", "score":0.8964951, "query({!dismax qf=UserQuery v='how'})":0.8964951, "sum(Count,query({!dismax qf=UserQuery v='how'}))":0.8964951}, { "Count":117, "UserQuery":"how to block calls", "score":0.7171961, "query({!dismax qf=UserQuery v='how'})":0.7171961, "sum(Count,query({!dismax qf=UserQuery v='how'}))":0.7171961}, { "Count":109, "UserQuery":"how to call forward", "score":0.7171961, "query({!dismax qf=UserQuery v='how'})":0.7171961, "sum(Count,query({!dismax qf=UserQuery v='how'}))":0.7171961}, { "Count":79, "UserQuery":"how do I pay my bill?", "score":0.7171961, "query({!dismax qf=UserQuery v='how'})":0.7171961, "sum(Count,query({!dismax qf=UserQuery v='how'}))":0.7171961}] }, -- View this message in context: http://lucene.472066.n3.nabble.com/sorting-using-function-query-results-are-notin-order-tp3390926p3390926.html Sent from the Solr - User mailing list archive at Nabble.com.