Dear users Does anybody know how to sort search results by a float field (using Solr version 8.9), but having documents that have NaN for this field always appear last? Currently, when sorting by the float field in DESC order, the values NaN appear at the top. I'd like to have these appear always at the bottom, independent of the sorting ASC or DESC.
I have tried to sort with "if" or "map", but can't get the Boolean expression to match NaN. Any help appreciated. Thanks Theo Disclaimer This e-mail message and any attachments (“message”) may contain confidential, privileged or proprietary information and is intended solely for the use of the named recipient(s). If you are not the intended recipient, you may not disclose, copy, distribute or retain any part of this message. If you have received this message in error, please inform the sender immediately by return e-mail and delete this message from your system. The BIS is not liable for any error in the content of this message and does not represent that it is uncorrupted and/or free of viruses. Views expressed in this message are those of the author and may not reflect those of the BIS. By exchanging e-mails with the BIS it is understood that the BIS may collect, store and further use e-mail addresses and other personal information which may be provided therein. The BIS will treat such information as confidential.