Arranging the checkbox list posted using array from table

[JBARLOW]

Hi everyone, Does anyone know how to arrange this list on my checkbox posted using array from table? to another checkbox? If anyone could help or give some reference. Thankyou.

Note: Its better if the arrangement is based on the numbering on the another column. Please see attached image of table.

[JBARLOW]

So are you looking to add values to the checkbox ordered by their rank value?
So based on the table above the checkbox would list cities in this order

Austin
Barcelona
Cairo
Bogota
Alexandria etc etc

[gfsampayan28]

Hi Sir jbarlowjb. Yes, Let me explain it correctly. I have a table with Rank_Branch, City_Branch and Hemisphere. I want to filter the table by choosing on the Hemisphere (Radiobutton) then listdown its City_Branch unde r that specific hemisphere which is need to be display based on the rank of those branches in the checkbox.

[former_member838037]

If you want to arrange the checkbox values according to the other dimension member, then one thing you can do. You can make the "Rank_Countries" the ID and "City Branch" as the description. And then you can just use a for loop to add the "City Branch" values to the Check Box which will be sorted according to the ID.

Please upvote, if this answer helps you.

[gfsampayan28]

Question Sir argha2000 how can I do that if the list on the checkbox is cascaded from the list in the radio button? I just need to arrange the list according to the of rank_countries in the table?

[gfsampayan28]

CheckboxGroup_1.removeAllItems();

res = Tbl_Retail_1.getDataSource().getResultSet({"Hemisphere_Globe":Checkbox_HemisphereList_arry});

console.log(res);

for (a=0; a<res.length; a++){

CheckboxGroup_1.addItem(res[a]["Rank_Branch"].id,res[a]["City_Branch"].description);

num

}

Note: After doing this one I still cant arrange the order of the displayed branch on the checkbox.