Add Variables name and there values in related list of incident form

[Divya Dahate]

Hello All, 

I'm trying to add 2 variables name and there values on New custom related list on the incident form. 

Can you please suggest something to achieve this.

I created the Relationship as below:

Applies to table: incident

Queries from table: ar_sc_item_option_mtom

And in Query i added:

sc_item_optionIN('66c127a11bd61cd0b7e8315bcd4bcb5b', '3d2154abdb4d37c438d2c19115961957');

and it's showing like this on incident form. 

I'm not sure how can i add only current catalog item's variables here and only show too variable on related list.

If you have any idea in this please let me know 

Thank you!

[Ankur Bawiskar · Accepted solution]

@Divya Dahate 

I believe you want to see variables associated with the current incident when incident got submitted from record producer

update as this

Queries from: question_answer

Script:

current.addQuery('sys_id', parent.table_sys_id);

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

[Divya Dahate]

Hello @Ankur Bawiskar , 

Thank you! for you response, 

I added the script but it's showing black values:

As per my understanding it will show variable name and there backend name only, my question here is

Is there any ways to show like for ex: Application and there selected value , group and there selected group name (values which is selected when form is submit)

Can we achieve this? 

[Ankur Bawiskar]

@Divya Dahate 

it will show the Question(variable) and it's value.

Remember the question_answer variable holds sysId for reference and list field and not the display value

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

[Ankur Bawiskar]

@Divya Dahate 

sc_item_option_mtom table holds information only for RITM

question_answer table holds information about variable details for records submitted via record producer

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