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.