Hi Server Side Scripting - Record Producer & Task

[Tara Bauch]

Hi - I have built my first record producer (previously have only done request items) and I'm relatively new to building scripts, both client and server side. Here's the situation I have that I need to solve using scripting on the server side. 

My main table for my record producer is called DNRC Personnel Action Form and then there is another task that is called DNRC Personnel Action Form Task. Because I need to be able to show the task table information when our ITIL users are working in specific record producers, I have created a relationship between these two tables - because they otherwise aren't related. Here's what the relationship looks like: 

Applies to Table: DNRC Personnel Action Form [x_g_som_dnrc_onb_0_personnel_action_form]

Queries from Table: DNRC PAF Task [x_g_som_dnrc_onb_0_paf_task]

I then was able to go to a submitted record producer and change the form to include the PAF tasks from that table (Tasks Included attachment). However, I know I need to go back to the relationship and narrow the tasks being queried by inserting a script (Query-Script Screen attachment). Because I don't have a lot of scripting experience, I'm totally lost - but I know this is a relatively simple thing and hoping someone in the group can help me write this. A couple other notes - not sure if they matter, but thought I'd include: I need to grab all related tasks, not just open ones. Some of the tasks will also run parallel. 

Thanks everyone! 

[AshishKM]

Hi @Tara Bauch , 

This mapping is based on some common column ( referenced field ) in the task table from the form table. 

add the below code in query part.

current.addQurey('task_table_column_name', form_table_coulmn_name );

This is for reference only, considering each task record has form record column with value ( or not ).

If this doesn't  not help , then share the more screen shot of FORM table and TASK table with common table.

-Thanks,
AshishKM