AnsweredAssumed Answered

Search comparing two datetime properties

Question asked by schipmolder on Nov 3, 2015
Latest reply on Nov 16, 2015 by jpotts
Hi, does anybody know how to search for objects with 2 datetime properties where one datetime property needs to be before the other?

I have a custom model with an object that has 2 custom datetime properties, myModel:myFirstTimestamp and myModel:mySecondTimestamp and I'd like to find all objects where myModel:myFirstTimestamp < myModel:mySecondTimestamp if that makes sense.

I have tried this in solr4 and cmid but can't get it to work. I did find how to search for date ranges where the date was static, but not where the second argument was a property of the object.

Thanks!

Outcomes