Service catalog - How to access Multi-row variable set

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('<SYS_ID OF RITM>'))
      {
      // 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(<ROW NUMBER [i]>) 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 

London and above