Skip to main content

Hello,

 

I am trying to create a workflow that gets run everyday to close out Business Opportunities that have expired. IFS Cloud does not handle this automatically so my attempt to do so consists of a workflow that reads a list of Business Opportunities and sorts based off of a date value that I generate via a script task. It’s formatted the same way as the workflow dates (MM/DD/YYYY HH:MI:SS AM) but when I try to either filter the read projection results (SalesQuotationsHandling-OrderQuotationSet) with this filter ((objstate = 'PLANNED' OR objstate = 'RELEASED' OR objstate = 'REVISED') AND expiration_date <= to_date(${varDate},'MM/DD/YYYY HH:MI:SS AM')) the results show that the workflow is processing, but it never ends. 

Is there a way to avoid this? I’ve tried adding parameters instead of filters, but this doesn’t help either. Any and all help would be greatly appreciated.

Thanks,
Bryan

Just to add to this, it does end, but it fails


Reply