I am creating a custom event on a table active_work_order_tab and I want to use a custom column from a custom table into it to get the run time value into the condition like ‘&NEW:METER_READING’. This column belongs to a custom table. How it is possible?
Solved
How to use column of another table into a custom event on another table?
+2Best answer by JoDe
Hi
This is possible with some limitations. You cannot select the new/old value from the custom event screen. You will have to retrieve them by either SQL or workflows in the event action.
in regards to SQL, this only works if the record is changed. If during the creation step we want to use these values we will have to create a script creating a background job for AFTER the commit has been done since you cannot query your own transaction.
Hi
This is possible with some limitations. You cannot select the new/old value from the custom event screen. You will have to retrieve them by either SQL or workflows in the event action.
in regards to SQL, this only works if the record is changed. If during the creation step we want to use these values we will have to create a script creating a background job for AFTER the commit has been done since you cannot query your own transaction.
+2Hi
Thanks for your precious reply. The main strategy I'm using is to retrieve a value from a table using an SQL query, but I need the value that the user has entered at runtime. Please suggest a solution for how I can obtain this runtime value.
you can pass the NEW ROWKEY and then do a select CF$_…. from active_work_order_CFT WHERE ROWKEY = ‘&NEW:ROWKEY’.
Again, please note that if it's a newly passed record, the record in the CFT will not exist yet since it's the current transaction.
if it IS the same transaction and you would like to use the new value you might have to amend the script to create a job in the background jobs. This way the sql statement executes AFTER the transaction has been committed.
+2I don’t want to commit the transaction coz I want to implement a check on the pre-commit value. It means this method is not possible for the uncommit data.
Hi Ishtiaq,
This unfortunately isn't possible. As a work around you can make the field only editable AFTER the record has been created (which isn't Ideal, I know).
For these validations where you want to check other values from the same transaction you might have to use workflows.
There you can get all values from the current transaction to do validations on.
Please note however there is a big array of issues with workflows which are still unresolved and because of that I personally would recommend against it (at least until 25R1, perhaps 25R2).
If you plan on using MobileWorkOrder, migration jobs etc. prepare to run into many many issues.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.