Master Table, List All Options as TSV String

Master Table: List All Options as TSV String
Master Table, List All Options as TSV String

Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated into TSV (Tab-Separated Values) and stored into Multiline-String type.

(C) Questetra, Inc. (MIT License)
https://support.questetra.com/addons/master-table-list-all-options-as-tsv-string/

Configs
  • A: Set Name of Master (e.g. “foo.xml”) * #{EL}
  • B: Select STRING DATA for Master TSV (update) *
Script (click to open)

// GraalJS Script (engine type: 2)
/*
 Questetra BPMS V12.0 (released 2020-05-11)
 - configs.getObject()
 - engine.findData()
 - engine.setData()
*/

//////// START "main()" /////////////////////////////////////////////////////////////////
main();
function main(){ 

//// == Config Retrieving / 工程コンフィグの参照 ==
const strMasterName = configs.get( "strSetConfA"  );      // required
const pocketStrTsv  = configs.getObject( "SelectConfB" ); // required
if( strMasterName === "" ){
  throw new Error( "\n AutomatedTask ConfigError:" +
                   " Config {MasterFile Name A} is empty \n" );
}


//// == Data Retrieving / ワークフローデータの参照 ==
// (nothing, except Expression Language config)


//// == Calculating / 演算 ==
const jarrOptions = itemDao.findAll( strMasterName, true );
// return "List<ItemView>" (java.util.ArrayList)
// M319: Register an Options-XML file to which the Process Model Definitions Refer
// M319: Options-XML: 複数の業務プロセス定義から参照される選択肢XML
// R2300 com.questetra.bpms.core.event.scripttask.ItemDaoWrapper
if( jarrOptions.size() - 0 === 0 ){
  throw new Error( "\n AutomatedTask UnexpectedOptionsXmlError:" +
                   strMasterName + " not found or null \n" );
}

engine.log( " AutomatedTask OptionsXML: " + 
            strMasterName + ": " +
            jarrOptions.size() + " options" );
let strTsv = '';
for( let i = 0; i < (jarrOptions.size() - 0); i++ ){
  strTsv += jarrOptions.get(i).getValue();
  strTsv += '\t';
  strTsv += jarrOptions.get(i).getDisplay();
  strTsv += '\n';
}
strTsv = strTsv.slice( 0, -1 );


//// == Data Updating / ワークフローデータへの代入 ==
engine.setData( pocketStrTsv, strTsv );

} //////// END "main()" /////////////////////////////////////////////////////////////////

Download

Capture

Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated into TSV (Tab-Separated Values) and stored into Multiline-String type.

Notes

  1. M319: Register an Options-XML file to which the Process Model Definitions Refer

See also

1 thought on “Master Table, List All Options as TSV String”

  1. Pingback: Converter (Options to Table) – Questetra Support

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top

Discover more from Questetra Support

Subscribe now to keep reading and get access to the full archive.

Continue reading