Search code examples
solrsolrcloud

Solr - calculate duration from start and end dates

Using Solr 8.0.0, with each document holding a start timestamp field and an end timestamp field, how would I query in a way that returns just the duration between these dates? So I would be going for an equation like this:

(Endtime - Starttime) - 500 seconds = 23 seconds over expected duration.

But getting the result across all documents in the collection.

Would this be the subject of a streaming expression? Any example code you can give? I specifically want to keep this calculation load within the SolrCloud.

Solution

  • You can use a function query. The ms function gives you the difference in milliseconds between two dates. You can use sub to subtract 500 seconds from that number.

    You can use the frange query parser to filter documents that match a given range. Which means we end up with something like:

    q={!frange l=0}sub(ms(endtime,starttime),500000)