i'm facing a big problem in my SolR DB. My objects have a datetime field "Available_From" and a datetime field "Available_To". We also have a "Ranking" field for the sorting that we usually use desc. I can search correctly with direct queries (eg. give me all the items that are available at the moment) but when i do a regular search by other criteria i cannot find a way to show the items that result "available NOW" in the first places in the specific search results, usually sorted by "Ranking" field. How can i do this? Am I forced to write some java classes (the nearest thing i've found is there https://medium.com/@devchaitu18/sorting-based-on-a-custom-function-in-solr-c94ddae99a12) or is there a way to do with standard SolR queries? Will boosting work? If yes, how can i boost by the 2 "Available_From" and "Available_To" fields verified at the same time, and then show the other results sorted by "Ranking" desc ? Thanks in advance to everyone!
-- Sent from: https://lucene.472066.n3.nabble.com/Solr-User-f472068.html