I got the question from customer and didn't succeed to find something useful in the different resources. The developer confirmed that we need to make development for customer's request, but before that I just want to check maybe I missed something and there is another approach to solve the problem:
"I want to set up a batch job for the Inventory on-hand report data clean up function (Inventory management > Periodic tasks > Clean up > Inventory on-hand report data clean up). I want to delete all data or all data older than 1 day. However, I cannot achieve either.
I see 2 possibilities: there is a field to delete data before a specific date and time or I can specify in the criteria which execution time should be deleted. However, both seem to only accept absolute values, while for execution in batch it is of course necessary to specify a relative value. How do I approach this?"
It's not clear what problem you have with running it as a batch. It's supported out of the box, just expand Run in the background fast tab on the dialog and configure it as you like.
Dealing with the time is more complicated. In theory, you could simply use a filter (with something like lessThanDate()) on ExecutionTime field; the problem is date it's neither Date field not a DateTime field; it's a string instead.
If you aren't familiar with filters like (lessThanDate(-1)), you should look at that (e.g. in Advanced filtering and query syntax), because it's often useful. Just note that this applies to query ranges, not to dialog fields.
You could either add an extra field that will contain the same value as ExecutionTime but as a regular date/time value, or add a custom field to the dialog and handle it in an extension of InventOnhandStorageReportCleanUp. I would prefer the custom field; it'd make filtering easy and efficient.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
6
Share
Report
All responses (
Answers (
