Comma separated values are not storing

[sainath3]

Hi Team,

I have two tables: Banks & Branches.

Branches table:

Branch Name	Bank Name
Branch1	Hyderabad
Branch2	Hyderabad
Branch3	Hyderabad
Branch4	Bangolore
Branch5	Bangolore
Branch6	Pune
Branch7	Pune
Branch8	Pune
Branch9	Pune

Bank Table:

Bank Name	Branches
Bangolore
Hyderabad
Pune

Requirement :

Populate all branches in bank table with Respect bank name from Branch table.

exptected result:

Bank Name	Branches
Bangolore	Branch4,Branch5
Hyderabad	Branch1,Branch2,Branch3
Pune	Branch6,Branch7,Branch8,Branch9

Actual result:

Bank Name	Branches
Bangolore	Branch4
Hyderabad	Branch2
Pune	Branch7

My code:

var bank = new GlideRecord('u_banks');
bank.query();
while (bank.next()) {
var branch = new GlideRecord('u_branches');
branch.addQuery('u_bank_name', bank.u_bank_name);
branch.query();
while (branch.next()) {
var bs = [];
bs.push(branch.u_branch_name.toString());
bank.u_branches = bs.toString();
bank.update();
}
}

Please help me where did I make mistake?

[Aman Kumar S · Accepted solution]

Hi @sainath3 ,

Change your code to:

var bank = new GlideRecord('u_banks');
bank.query();
while (bank.next()) {
    var bs = [];
    var branch = new GlideRecord('u_branches');
    branch.addQuery('u_bank_name', bank.u_bank_name);
    branch.query();
    while (branch.next()) {
        bs.push(branch.u_branch_name.toString());
    }
    bank.u_branches = bs.toString();
    bank.update();
}

[sainath3]

Thanks Aman Kumar