Re: Solr list all records but fq matching records first

2013-08-06 Thread Thyagaraj
I verified, the code is proper, I just highlighted with bold few things. Below I have pasted it again, Method 1 SolrQuery query = new SolrQuery().setStart(first).setRows( searchCommand.getRowsPerPage()); //setting query query.setQuery("*"); //setting spati

Re: Solr round ratings to nearest integer value

2013-08-04 Thread Thyagaraj
Hello Erick, Is it possible to without changing the sql query?. I just rounded ratings value at the query time and trying to search with filter query like the one below: q=*:* fq=ratings:[2.0 TO 2.5] fl=ratings:rint(ratings) I have a rating 1.75 in a record which is rounded to 2.0 by rint but i

Re: Solr list all records but fq matching records first

2013-08-02 Thread Thyagaraj
Your solution worked perfectly in solr!. You have any idea how to achieve the same with solrj java code?. I tried below two methods(edismax & OR) in solrj java coding but I did not get the results in order, like listing matching records at the top. Am I doing anything wrong in below java coding?

Re: Solr round ratings to nearest integer value

2013-08-01 Thread Thyagaraj
After discussion I came to know that I want the second point... 2. Query to match only rounded integer values? -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-round-ratings-to-nearest-integer-value-tp4081833p4082138.html Sent from the Solr - User mailing list archive

Re: Solr round ratings to nearest integer value

2013-08-01 Thread Thyagaraj
Hello Jack Krupansky-2, Can I have all the 3 if you don't mind?, if it's not over work for you because I'm not sure exactly. Till then I'll discuss with one of my developer. Thank you for your interest! -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-round-ratings-

Re: Solr round ratings to nearest integer value

2013-08-01 Thread Thyagaraj
Hello Raymond Wiker, I just want to change the value while returning from the index (i.e, at query time). I tried the one like below but it's not working and showing same fraction value instead any nearest integer, http://192.168.1.10:8080/solr/core10/select?q=*%3A*&rint%28ratings%29&wt=xml Did

Solr round ratings to nearest integer value

2013-07-31 Thread Thyagaraj
I'm using solr 4.0 with DIH jdbc connector and I use Solr Admin web interface for testing. I have a field called *ratings* which varies like 0, 0.3, 0.5, 0.75, 1, 1.5, 1.6... and so on as per user input. I found the link http://lucene.472066.n3.nabble.com/How-to-round-solr-score-td495198.html <

Re: Solr list all records but fq matching records first

2013-07-31 Thread Thyagaraj
Thank you very much!, -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-list-all-records-but-fq-matching-records-first-tp4081572p4081826.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Solr list all records but fq matching records first

2013-07-31 Thread Thyagaraj
Awesome Jack Krupansky-2!!!. It seems to work!. What I didn't understand is *^100*. Could you give some explanation on ^100 please? if it could be any number other than 100?. Thanks a lot!, I was working on this for past 3 days!. -- View this message in context: http://lucene.472066.n3.nabb

Solr list all records but fq matching records first

2013-07-31 Thread Thyagaraj
I’m using solr 4.0 with DIH jdbc connector. I have a field named *code* with multiple values separated by semicolon(;). I am trying to list the search results which matches the field query(fq) to be listed at the top and remaining should be listed below. So this is not just a filter query to list o