Hi,
I have a Process Flow that is execute when a event occurs.
The Flow adds a new line to the order_change_log, See API for to add line in Trans log | IFS Community
How do i get the current datetime to fill the creation_datetime field in the API inside the Process Flow or API action?
I know i can change the Process Flow from execute when a event occurs to Periodic Data Query, and get the current datetime from de SQL, but i want to use the executer when event occurs.
Thanks,
Robin
Best answer by robinsch
Hi Joshua,
Thanks for the research, i have to use it in a “when a event occurs Process Flow” that also triggers a outbound message to our customer when Status changes and write a message to order_changes_log so our agent can see that message is send.
For the date i have created a formula in the formula manager that i use in de API
Formula: #YYYY+-+#MM+-+#DD
Only the time formula #TIME gives not the right format so i cannot use that.
So for time i will use fixed time for now.
Thanks again,
Robin.
+24Hi Robin,
To clarify, you are referring to the creation_datetime of the transaction log entry? If so, isn’t this populated automatically unless you supply it in the API by the business logic? I haven’t tried doing the API without supplying this value to see what happens but was just thinking.
If it is a different column or entity, let us know. The question has been raised to R&D by both Joshua and myself. I don’t think there is a way the API itself can retrieve a getdate() like value but this is being confirmed.
Hi Phil,
Yes i am, if the field is not supply in the API, the created at and actual date will not be automatically filled by business logic.
Hi Robin,
After doing some research I cannot find a way embed current Date/Time within the API.
Unfortunately module order_changes_log does not auto populate creation_datetime.
However if you are planning to build a Process Flow, this can be easily added in the input file or sql.
If you are using a sql query as an input, you can add a current date/time and use it as the input.
Hi Joshua,
Thanks for the research, i have to use it in a “when a event occurs Process Flow” that also triggers a outbound message to our customer when Status changes and write a message to order_changes_log so our agent can see that message is send.
For the date i have created a formula in the formula manager that i use in de API
Formula: #YYYY+-+#MM+-+#DD
Only the time formula #TIME gives not the right format so i cannot use that.
So for time i will use fixed time for now.
Thanks again,
Robin.
If this is important for the business, I would ask IFS to customize order_changes_log BO. This would be a small change.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
