- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2021 01:35 PM
In my customized version of Incident Management, I have 'Assignment Group' as one of the columns in 'task_sla' table. On 'tasl_sla' record has 'Task' number which is the Incident number of the corresponding (parent) Incident record.
When an Incident is resolved, the 'Assignment Group' value on the Incident is written to 'Assignment Group' on the related 'task_sla' record.
Recently, while doing an upgrade, I lost values in 'Assignment Group' field in the 'task_sla' records. One can easily write a simple script and run it one-time as a back-ground job to re-populate the missing values. But I am trying to use Flow Designer and I have NOT succeeded so far.
My flow Flow definition consists of -
(a) Trigger = Run once ,
(b) Actions 1 = Update Multiple Task SLA records
I define the conditions for selecting the records for the above step 'Action 1'. But the problem is, how do I access the Incident tabel, using the 'Task' on each of the 'task_sla' record. I can not select 'Incident' table here using the 'pill-selector'. Do I have to write a script, using f(x) ? If 'yes' can someone tell me where do I start? I tried the following-
var inc = fd_data.actions.current.task.etDisplayValue();
But that doesn't work. Please help.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2021 11:30 PM
Hi rrmurkute,
You can not access table in current action
but table in "Action before current action" or "Trigger".
(Please refer below image.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-14-2021 11:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2021 08:44 PM
Thanks, Takazawa. That gave me a good start.
•