Tranformmap error logs in requested item variable

keshav77
Tera Contributor

Hi All,

 

I am running one tranformmap on  catalog and there is onbefor tranformmap script is also running on the incoming data if the data is invalid  it ignore row entre in tagret table and in tranform map I ma create error logs and message I want to populate them under the variable of requested which currently not working.

how to get those error message in that variable please let me know.

 

the below image where I want to place them in requested item

@Ankur Bawiskar  is there any way to do that

keshav77_0-1752773800663.png

 

1 REPLY 1

Brad Warman
Giga Sage

You'll likely need to gliderecord in to the sc_item_option table to find the record of the catalog item which has been submitted, then update the 'value' field of the 'row count' question/variable. This would need to be done on each failure so make sure you don't override the 'value' field each time or you'll only get the value for the last failure.

 

M2M table to request item
sc_item_option_mtom.request_item = sc_req_item.sys_id

M2M table to variable
sc_item_option_mtom.sc_item_option = sc_item_option.sys_id