Copying variables and rules applied to a catalog item from a RITM to a task in a custom table.

AdrieliP
Tera Contributor

I need to copy the variables and ensure they meet the rules applied in the RITM due to the catalog item.

 

The scenario: I need to create a record in a custom TASKS table (x_stps2_tasks) and have it filled through the values from an RITM. I've already created an 'ACTION' within the 'FLOW DESIGNER' that applies these rules by creating a record in the 'sc_item_produced_record' table, thus validating the rules applied to the RECORD PRODUCER. However, I need something similar that works for 'MAINTAIN ITEM'. Is there a table where I can create this link and bring all the rules and variables from a catalog item to a task in a custom table created through an RITM via flow designer?

2 REPLIES 2

Neel Patel3
Giga Guru

Hello Adrielli,

 

You can use the 'Create Record' action in the Flow.

Step 1: Use 'Get Catalog Variables' action to get values from submitted RITM

Step 2: Use 'Create Record' action, select your table and map field according to your requirements.

That's it.

 

Hope this helps!

Its_Azar
Tera Guru

Hi there @AdrieliP 

 

Start by creating a custom action in Flow Designer that will handle the logic of copying variables and ensuring they meet the rules applied in the RITM.

This action will be triggered when a new task record is created in your custom table (x_stps2_tasks).

Within the custom action, use GlideRecord  to retrieve the variables and rules applied in the RITM associated with the task.

You can query the sc_req_item table to fetch the variables and sysapproval_approver table to get the approval rules.

Implement the logic to apply the rules retrieved from the RITM to the task record in your custom table.

Copy the variables from the RITM to the task record

Once the variables are copied and rules applied, update the task record in your custom table with the modified values.

 

If this helps kindly accept the response thanks much

☑️ If this helped, please mark it as Helpful or Accept Solution so others can find the answer too.




Kind Regards,

Mohamed Azarudeen Z

Developer @ KPMG

 Microsoft MVP (AI Services), India