Service catalog - How to access Multi-row variable set - Support and Troubleshooting

Service catalog - How to access Multi-row variable set Description This is an example of how to access a Multi-row variable set from a script.

Here is a list of Multi-Row Variable sets: /nav_to.do?uri=%2Fitem_option_new_set_list.do Once a RITM is submitted, we do see the variables with its values are stored in a table - sc_multi_row_question_answer See Scriptable service catalog variables for more info In the docs, table_var means we should provide the name of the Multi-Row variable's which is Internal Name The following sample script can be used to access the variables: We have a multi-row variable with the name "server_build_list" and defined with the following fields [with data type]: u_data_center - Reference u_how_many - Integer u_storage_size - reference Script to access the data: var gr = new GlideRecord('sc_req_item'); if (gr.get(' ')) { // Syntax for this is gr.variables.table_var which returns JSON array value as String gs.log( "1.variables "+ gr.variables.server_build_list); }

// Syntax for this is gr.variables.table_var.getRow( ) which returns ith row from the multi row variable // and we are trying to access a cell out of it as below

var row = gr.variables.server_build_list.getRow('1'); gs.log( "Fetching Row 1 "+ row.u_data_center);

// Syntax for this is gr.variables.table_var.getRowCount( ) which returns current row count gs.log( "Row Count "+gr.variables.server_build_list.getRowCount()); Result *** Script: 1.variables [ { "u_data_center" : "a41d652bdb335b00af053b2ffe9619e0", "u_how_many" : "1", "u_storage_size" : "1024" }, { "u_data_center" : "a41d652bdb335b00af053b2ffe9619e0", "u_how_many" : "4", "u_storage_size" : "2048" } ]

*** Script: Fetching Row 1 a41d652bdb335b00af053b2ffe9619e0 *** Script: Row Count 2

Release or Environment London and above