Populate a Checkbox Group with alphanumerically sorted dimension members

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)
Scroll to Top