ishfolderquery functions/variables?

 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

Parents Reply Children