Questetra Get Membership Mail Address Belong To Org

Questetra Get Membership Mail Address Belong To Org
Get Questetra Membership Mail Address Belong To Org
Configs
  • A1: INPUT Qgroup Id (Org Id).#{EL}
  • A2: Select ORG DATA
  • B1: Select STRING DATA for Quser Emails: separating new line
  • B2: Select STRING DATA for Quser Emails: separating comma
  • C: Get Leader Only (ON)
Script (click to open)


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

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


//// == Calculating / 演算 ==
let qGroup = null;
if ( conf_qgroupId !== null && conf_qgroupId !== "") {
qGroup = qgroupDao.findById( new java.lang.Long(conf_qgroupId) );
} else if (conf_qgroup !== null) {
qGroup = engine.findData( conf_qgroup );
}
if (qGroup === null){
engine.log("No organization specified.");
return;
}
let qUsers;
if ( strIsLeaderOnly === "true"){
engine.log("Get Leader Only.");
qUsers = quserDao.findByQgroupAndPosition( qGroup , true);
}else{
engine.log("Get All Staff/Leader.");
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

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

Notes

  • If both A1 and A2 are set, A1 takes precedence
  • 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

Scroll to Top

Discover more from Questetra Support

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

Continue reading