AnsweredAssumed Answered

Service Catalog 14.1.02 - extracting data from table rows

Question asked by shomer on Oct 26, 2016
Latest reply on Oct 27, 2016 by shomer

Hi all,

 

Trying to get label values from table rows (via ca_fdGetSelectedTableRows and ca_fdGetInsertedTableRows) and dump into a text area so I can reuse (in this case pass to SDM as part of description).

 

Have got far enough to know I need to define JSON objects and can get it to output a single row label value, but am stuck on trying to get it to pass all selected or inserted rows (not familiar w/ JSON at all, and CA couldn't help...have limited time to research).

 

So something like the following (have tried several variations), except looping (or wildcard?) so it is passing all rows and not individual rows as they are selected/inserted/changed:

 

//get Report Columns labels from table
  getReportColumnsTable : function () {
    var RCTSelections = ca_fdGetSelectedTableRows(ca_fd.formId,'table_ReportColumns');
    var RCTSelection = JSON.parse(JSON.stringify(RCTSelections));
    var i = 0;
    for (i = 0; i < RCTSelection.length; i++) {
      //Do something
      ca_fdSetTextFieldValue(ca_fd.formId,'txta_RCSelections',RCTSelection[i].sym);}
    },

 

Any help would be greatly appreciated...

 

EDIT: Forgot to mention, table has single column using sym field from DB report data object used (and table is fetching data based on user input in another select field on form so don't have flexibility in data source). Text field for table column _id is also sym.

Outcomes