Good Afternoon,
I have a dilemma where I am firing an event via a UI action to trigger a notification. At present this is on the problem table but I am having issues pulling in details from the problem task table which is also needed to go into my notification as part of my requirement.
At present here is what I have (see below). The event and my notification trigger correctly off of this UI action. However on my notification only problem fields come through and not the problem task fields.
Any help correcting my script would be appreciated
Hi Anvesh,
I will try and be as clear as possible with the requirement.
Our client requires that at any stage under the problem module, they can generate a report that pre-populates data from the problem table into a notification. We have successfully set up an event and linked this to the notification and this works fine.
The problem is at present, it will successfully transfer the data from the problem table into the notification HOWEVER it will NOT successfully transfer data from the problem task table, we need to pull data from 2 tables, both the problem and problem task table,
The above screenshot shows the script we have implemented as a UI Action, do we need to add to the above script so that it querys the data in the Problem Task table i.e we need the Task ID, Task description, Assigned to field etc, all of which the data does not pull through succesfully at the moment and we dont know why this is?
We was hoping the solution would be a script within the UI action as shown above, not a mail script?
The above screenshot is currently what information the notification is populating, as you can see it is populating PROBLEM reference, not Problem Task ID, even though we have configured the notification to request those fields to show problem task ID and not Problem Reference see below
The notification is created from the table "PROBLEM TASK"
I hope this information helps
TIA
