Questetra Get Membership Mail Address Belong To Org
Gets the email address of members that belong to a specified Organisation in Questetra.
Configs
  • A1: INPUT Qgroup Id (Org Id) *
  • B1: Select STRING DATA for Quser Emails: separating new line
  • B2: Select STRING DATA for Quser Emails: separating comma
Script (click to open)


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

  //// == Config Retrieving / 工程コンフィグの参照 ==
  //// == Data Retrieving / ワークフローデータの参照 ==
  //// == Validation / 入力チェック
  const conf_qgroupId = configs.get( "conf_QgroupId" );
  const conf_Qusers_separating_newline = configs.getObject( "conf_Qusers_separating_newline" );
  const conf_Qusers_separating_comma = configs.getObject( "conf_Qusers_separating_comma" );

  //// == Calculating / 演算 ==
  const qGroup = qgroupDao.findById( new java.lang.Long(conf_qgroupId) );
  const qUsers = quserDao.findByQgroup( qGroup );

  let qUsersList = "";
  let qUsersListByComma = "";

  for(var i=0; i < qUsers.size(); i++){
      qUsersList += qUsers.get(i).getEmail() + "\n";
      qUsersListByComma += qUsers.get(i).getEmail() + ",";
  }
  qUsersList = qUsersList.replace(/\n$/,"");
  qUsersListByComma = qUsersListByComma.replace(/\,$/,"");
  engine.log("qUsersList: " + qUsersList);
  engine.log("qUsersListByComma:" + qUsersListByComma + "");

  //// == Data Updating / ワークフローデータへの代入 ==
  if ( conf_Qusers_separating_newline !== null ){
    engine.setData( conf_Qusers_separating_newline, new java.lang.String(qUsersList) );
  }
  if ( conf_Qusers_separating_comma !== null ){
    engine.setData( conf_Qusers_separating_comma, new java.lang.String(qUsersListByComma) );
  }
} //////// END "main()" /////////////////////////////////////////////////////////////////

Download

2021-12-01 (C) Questetra, Inc. (MIT License)
https://support.questetra.com/addons/questetra-membership-get-mail-address-belong-to-org/
The Add-on import feature is available with Professional edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.

Notes

  • How to get Qgroup ID
    • [System Settings] > [Organizations List] > Click target organization name > Check Organization ID
    • Input the Organization ID excluding “g”.

Capture

See also

Leave a Reply

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

%d bloggers like this: