For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
We are changing with internal messages some values of our Activities based on different events (activity started, suspended, passed the ETA, not done etc) and we would like to update each time the field modified to contain the date and time of the change.
We havent found the way to do exactly that. We have thought of using predefined fields such as start time but this only shows time and not the date.
Hi Vassiliki,
Wild idea, but did you tried with the
now("yyyy-MM-dd HH:mm:ss")
formula? (This is coming from Admin guide, within Language Expressions section related to field visibility.)
Regards,
Zsolt
Thank you for the suggestion. Unfortunately, the expression does not get calculated and I haven't found an option to treat it as an expression instead of text.
I am using the now("yyyy-MM-dd HH:mm:ss") in the message body of a set property message scenario and it get inserted as a text. So on the UI I am getting:
Modified | now("yyyy-MM-dd HH:mm:ss") |
Okay, one try is done
Next one is:
{date}
from here https://docs.oracle.com/en/cloud/saas/field-service/19a/famsc/message-content.html#r_dateTimeFormat
Zsolt
date works. but only for the date not the time. If for example I use {date|%G-%m-%d %H:%M:%S} I am getting
2019-02-19 00:00:00 |
Okay, can you combine this field with the "We have thought of using predefined fields such as start time but this only shows time" part?
Because the "ETA" field in the example gives a different time than the current time, but maybe also okay in your scenario. {ETA|%F %H:%M:%S}
Zsolt
Used {message_time_of_content_generation} for those ones