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