In FSM6u10, I have created a notification message for Projects. For the most part the notification forms correctly, however some fields do not seem to pull in a value.The values below do not populate where other fields from the Project table do. project.user_def1project.user_def2project.created_by Below is an extract from the message, but have added a column on the right with the table.field used. SCA_ID 154 project.project_id Place_ID ZZ PLACE ONE project.place_id Description test project.project_title SCA_Status OPEN project.proj_status SCA_Approval_Status REJECTED project.approval_status Activity project.user_def1 SCA_Start_Date 26 November 2021 00:25 project.user_def_dttm1 SCA_End_Date 26 November 2021 01:50 project.user_def_dttm2 Permitted_Access project.user_def2 Created_By project.created_by SCA_Owner APAVLOU
The online documentation indicates business rule operators:to days, to hours, to minutes, to secondsConvert to days, convert to hours, convert to minutes, convert to secondsBut there is no example as to how this is actually implemented. to_minutes() does not work.I am trying to calculate the duration (time difference) between two dates in a business rule.Thanks in advanceBen
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.