In SQL you can order by an expression like:
SELECT * FROM TABLE1 ORDER BY 
(
CASE WHEN COL1 BETWEEN ${PARAM1} - 10 AND ${PARAM1} + 10 AND COL2=${PARAM2}
THEN 1
        WHEN COL1 BETWEEN ${PARAM1} - 10 AND ${PARAM1} + 10 AND
COL3=${PARAM2} THEN 2
        WHEN COL1 - COL3=${PARAM3} THEN 3
        WHEN COL4 LIKE '${PARAM4}%' THEN 4
END
)

AND HOW TO DO THAT IN SOLR?
THANKS!



--
View this message in context: 
http://lucene.472066.n3.nabble.com/Order-by-an-expression-in-Solr-tp4079270.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to