I would like to setup an inbox that displays all content that has been in a "design" state for at least 90 days. I need to be able to do some basic math based on the current date/time.
Basically this would be setup for a quality role to disposition components that have been sitting idle - delete the components or push them through workflow.
Took a stab at it hoping xpath was valid option but seems that isn't the case ...
<InboxQuery>
<MetaDataCondition>
<CardType value="CTMASTERL"/>
<CardType value="CTMAPL"/>
<CardType value="CTLIBL"/>
<ISHField ref="FSTATUS" operator="equal" value="VSTATUSDESIGN" valueoption="isrcElement"/>
<ISHField ref="FSTATUS" operator="equal" value="VSTATUSROUTING" valueoption="isrcElement"/>
<ISHField ref="FISHLASTMODIFIEDON" operator="greaterthan" value="current-date() - xs:dayTimeDuration('P90D')" valueoption="isrcElement"/>
</MetaDataCondition>
</InboxQuery>
Thanks.
David