topic Re: Search comparing two datetime properties in Alfresco Archive

Search comparing two datetime properties

schipmolder — Tue, 03 Nov 2015 13:08:34 GMT

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 wher

Re: Search comparing two datetime properties

jpotts — Mon, 16 Nov 2015 23:28:34 GMT

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