Notifications - Displaying the Value of Fields from Other Tables

[TStark]

I have a notification on the demand (dmn_demand) table in which I'm trying to include the value of a field from another table. I'm not sure of which table to use and am not sure if my script is correct. I created a mail script and am calling it from within the notification, but apparently I am doing something wrong. Below is my script and a screenshot of the data (category) in which I need to be included in the notification.

Thanks
AJ

[Ankur Bawiskar]

@TStark 

update as this in line 3

demand.addQuery('instance.trigger_id', current.sys_id);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[TStark]

I appreciate you response @Ankur Bawiskar but that didn't work.

AJ