Re: Query regarding solr custom sort order
Hi, Let me clarify the situation here in details. The default sort which Websphere commerce provide is based on name price of any item. but we are having unique values of every item. hence sorting goes on fine either as intger or as string but while preprocess we generate some temporary tables like TI_CATGPENREL_0, where sequence number is multiple value for a particular catentry id(item). this field (sequence) is declared as varchar because it can contain multiple values separated by ; which solr returns, hence sorting based on sequence will happen lexicographically as discussed in the thread. So can we restrict it to send single values based on certain category ID or something like this. Thanks in advance, Uma Shankar -- View this message in context: http://lucene.472066.n3.nabble.com/Query-regarding-solr-custom-sort-order-tp3631854p3665545.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Query regarding solr custom sort order
Hi Bernd, The column which comes from database is string only, that is being default populated. How do I convert it to double as the format is 1.00,2.00,3.00 in database. So I need it to be coverted to double only. Thanks, Uma Shankar -- View this message in context: http://lucene.472066.n3.nabble.com/Query-regarding-solr-custom-sort-order-tp3631854p3637181.html Sent from the Solr - User mailing list archive at Nabble.com.
Query regarding solr custom sort order
Hi, We want to sort our records based on some sequence which is like 1 2 3 4 5 6 7 8 9 10 11 12 13 14. I am using Websphere commerce to retrieve data using solr. When we are customizing the sort order/ option in wc-search.xml file then we are getting the sort order as 1 10 11 12 13 14 2 3 4 5 6 7 8 9 like this. As I guess the sort order is checking with first digit of all sequences based on that if they are same moving on to compare the next digit so on, which is resulting on wrong sort output. Can anyone put some thoughts on this or help me out if I am doing something wrong here. Thanks in advance Uma Shankar -- View this message in context: http://lucene.472066.n3.nabble.com/Query-regarding-solr-custom-sort-order-tp3631854p3631854.html Sent from the Solr - User mailing list archive at Nabble.com.