Search comparing two datetime properties

[schipmolder]

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!

[jpotts]

Can you just grab the value of myModel:mySecondTimestamp programmatically and then do the comparison using a CMIS query, like:

select * from myModel:myType where myModel:myFirstTimestamp < TIMESTAMP '2015-09-14T22:28:58.000-05:00'
‍‍‍

Jeff