Questetra Get Membership Mail Address Belong To Org

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.

Scroll to Top

Discover more from Questetra Support

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

Continue reading