Skip to main content
Question

IFS Cloud - Database task schedule parameters

  • June 15, 2023
  • 1 reply
  • 162 views

Forum|alt.badge.img+17

Hello,

 

I am currently using the database task ‘Create Consolidated Pick List for Customer Orders”. We have a parameter that will create a pick list for any customer order who’s due date is within 3 days of the current date. This works fine by defining the execution offset as -3 but how could I set this to be equal to or less than 3? If a customer order ever gets created with a due date that is older than the sysdate (couldnt happen unless through a migration) then that customer order would never have its pick list created. 

 

How can I get around this and print all older pick lists as well? The parameters are pretty limiting.

 

Any and all input would be greatly appreciated.

 

Thanks,
Bryan

1 reply

Forum|alt.badge.img+17
  • Author
  • Superhero (Customer)
  • 254 replies
  • June 27, 2023

I have yet to find an answer for this. Any and all input would be greatly appreciated.

 

I’d really hate to have to create a workflow to check for these constantly.

 

Thanks,
Bryan