Passing value from Catalog Item variable to a specific table field

pablopaciullo · ‎09-08-2017

Hello team!

I needo to insert a value (string) from a catalog Item variable to a specific field on the table sc_req_item:

target table: sc_req_item

target field: u_oficina_afectada

source variable name: Oficina_afectada

Variable Type: reference

Refers to: cmn_building.

Should it go as a calculated field? Is it a script running as part of the workflow??

Can you please indicate me the exact steps should I follow to make it work?

Thank you!!!

Regards,

Pablo

Jeff Schodde · ‎09-08-2017

Pablo,

You could achieve this with one of two methods:

A 'before' business rule on sc_req_item. Note: you should consider adding a condition for the script to execute based on the specific catalog item(s) your variables are associated with. Basically, you don't want the business rule script to execute on every sc_req_item record because not all of them will have the same variables.
A Run Script activity in whatever workflow is associated with that catalog item.

The fundamental components for the script would look similar to this:

current.u_oficina_afectada = current.variables.Oficina_afectada;

I hope this helps.

Cheers,

Jeff

View solution in original post

Deepak Kumar5 · ‎09-08-2017

Variable is reference field type so use below.

current.u_oficina_afectada = current.variables.Oficina_afectada.getDisplayValue();

pablopaciullo · ‎09-09-2017

Thenk you Deepak!! That worked fine!!

Best regards,

Pablo

Rick Kuijpers · ‎03-27-2020

Thanks Jeff. Found this when faced with the same challenge. I used the Run Script suggestion in my workflow and it worked like a charm. Now I need to add the check if that variable exists in the catalog item and ignore the field assignment script if not.