var members = Table_1.getDataSource().getMembers("Sales_Manager");
var Ordermembers = ArrayUtils.create(Type.string); // create an array variable set to type: string
var i=0
if (members.length > 0) {
for (i=0;i< members.length; i++)
{ var membersID = members[i].id; // write the current member id to the membersID variable
var membersDescription = members[i].description; //same logic for the description
// create a new variable ‘ID_DESC’ which is populated with the MemberID + ; + Member Description var ID_DESC = ""+ membersDescription+";"+ membersID+"";
// push (add) the concatenated value to the Ordermembers array variable
Ordermembers.push(ID_DESC);
// sort the Ordermembers array alphanumerically – noting that the first value is the description
Ordermembers.sort();
}
/*here we loop through all values of the Ordermembers array variable, splitting the values on the character
‘;’ The MemberDescription is added to OrderDescription and the ID is added to IDDescription
these 2 new variables are then used to populate the checkbox group */
for (i=0;i<Ordermembers.length; i++)
{ var membersDivide = Ordermembers [i].split(";");
var OrderDescription = membersDivide[0];
var IDDescription = membersDivide[1];
CheckboxGroup_1.addItem(IDDescription,OrderDescription);
}}
Code language: JavaScript (javascript)
