Value of variables on catalog task

[Anubhav24]

Hi All,

We have below setup of variable mapping and then the value of these variables mapping done on RITM and Catalog task under below tables :

item_option_new : RITM and Form Variable mapping (Original variable record)

sc_item_option_mtom : This table stores the value keyed in by the user on form variables while submitting the request.

sc_item_variables_task : This table stores the Catalog task sys_id and the Form variable mapping(Original variable record)

Now my query is how is sc_task[Catalog task] variables getting the value on the variables.

@Ankur Bawiskar @Dr Atul G- LNG @Sandeep Rajput 

[Ahmmed Ali]

Hello @Anubhav24 

Basically the variable values are stored in Options (sc_item_option) table which are then linked to respective RITM in sc_item_option_mtom table. If you are opening RITM or SCTASK, you are getting values from this table only.

sc_item_variables_task: This table stores the variables which should be shown on the respective catalog task.

Example: If you have variable A and Variable B in your catalog item and you have two SCTASKs in workflow. Now if you want to show A in first task and B in second, you can update same in catalog task activity in workflow and once SCTASK is created, two records in this table will be created. One with first task & A, second with second task and B. 

The variable editor formatter in SCTASK and RITM tables dynamically read data from the above value table to show on the form. URL of formatter:

https://INSTANCE_NAME.service-now.com/sys_ui_formatter_list.do?sysparm_query=table%3Dsc_task%5EORtab...

Thank you,

Ali

[Anubhav24]

Hi @Ahmmed Ali ,

i wanted to understand this part : "Basically the variable values are stored in Options (sc_item_option) table which are then linked to respective RITM in sc_item_option_mtom table. If you are opening RITM or SCTASK, you are getting values from this table only." For RITM the mapping of variable values is done in the table "sc_item_option_mtom".

But where is the variable value mapping for catalog task table , the table "sc_item_variables_task" lists down the variables to be shown on catalog task but where is the variable value mapping done or if for catalog task also the variable value is derived from "sc_item_option_mtom" then how is it happening.

[Ahmmed Ali]

Hello @Anubhav24 

Lets say RITM1 has SCTASK1 record. Now when you open RITM1 record, the variable values are being taken from sc_item_option_mtom.

Now, when you open SCTASK1 record, there is no additional table where the same values are being stored (that would be just duplicate data). You have RITM1 record reference in the SCTASK1 record, so the same variables are read from RITM1 and shown in SCTASK1.

Thank you,

Ali

[Anubhav24]

Ok , so basically it is just showing what is already shown on RITM , I understand this now but what is the background processing , if you know can you please help me explain it.

Please mark helpful/correct if my response helped you.