How to loop and output values from two separate arrays into one single string

Question

How can I loop into two arrays and create string output from both arrays statArr and typeArr with appending some AND & OR operators?

What I am hoping to get at the output is

stat = 'Closed' AND type = 'RD' OR
stat = 'Closed' AND type = 'WW' OR
stat = 'Closed' AND type = 'CC' OR
stat = 'Closed' AND type = 'MB' OR
stat = 'Closed' AND type = 'CN' OR
stat = 'Investigation' AND type = 'RD' OR
stat = 'Investigation' AND type = 'WW' OR
stat = 'Investigation' AND type = 'CC' OR
stat = 'Investigation' AND type = 'MB' OR
stat = 'Investigation' AND type = 'CN'

var statArr = ["Closed", "Investigation"];
var typeArr = ["RD", "WW", "CC", "MB", "CN" ];
var sql = "";
for (let i = 0; i < statArr.length; i++) {
  sql += "stat = " + statArr[i] + " AND Type =";
 }
 console.log(sql);

this stat = 'Closed' AND type = 'RD' OR stat = 'Closed' AND type = 'WW' OR stat = 'Closed' AND type = 'CC' OR stat = 'Closed' AND type = 'MB' OR stat = 'Closed' AND type = 'CN' OR stat = 'Investigation' AND type = 'RD' OR stat = 'Investigation' AND type = 'WW' OR stat = 'Investigation' AND type = 'CC' OR stat = 'Investigation' AND type = 'MB' OR stat = 'Investigation' AND type = 'CN' — Behseini
– Behseini, Commented Sep 4, 2022 at 18:40

AKX · Accepted Answer · 2022-09-04 18:48:22Z

2

Nest two for loops to generate each stat/type combination, then join them with ORs. I added parentheses to each clause just to make sure precedence works as it should.

var statArr = ["Closed", "Investigation"];
var typeArr = ["RD", "WW", "CC", "MB", "CN" ];
var clauses = [];
for(var stat of statArr) {
  for(var type of typeArr) {
    clauses.push(`(stat = '${stat}' AND type = '${type}')`);
  }
}
var sql = clauses.join(" OR ");

The output is

(stat = 'Closed' AND type = 'RD') OR (stat = 'Closed' AND type = 'WW') OR (stat = 'Closed' AND type = 'CC') OR (stat = 'Closed' AND type = 'MB') OR (stat = 'Closed' AND type = 'CN') OR (stat = 'Investigation' AND type = 'RD') OR (stat = 'Investigation' AND type = 'WW') OR (stat = 'Investigation' AND type = 'CC') OR (stat = 'Investigation' AND type = 'MB') OR (stat = 'Investigation' AND type = 'CN')

However, I think you might really just want

stat IN ('Closed', 'Investigation') AND type IN ('RD', 'WW', 'CC', 'MB', 'CN')

which could be generated with

const quote = s => `'${s}'`;
var sql = `stat IN (${statArr.map(quote).join(", ")}) AND type IN (${typeArr.map(quote).join(", ")})`;

edited Sep 4, 2022 at 18:48

answered Sep 4, 2022 at 18:40

AKX

171k16 gold badges146 silver badges228 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Behseini Over a year ago

Thanks AKX, can you please also let me know how to achieve the second solution?

Shinebayar · Accepted Answer · 2022-09-04 18:48:52Z

0

Using nested for loop, you can get result.

    var statArr = ["Closed", "Investigation"];
    var typeArr = ["RD", "WW", "CC", "MB", "CN" ];
    var sql = "";

    for (let i=0; i<statArr.length; i++) {
        for(let j=0; j<typeArr.length; j++){
            console.log(`stat = '${statArr[i]}' AND type = '${typeArr[j]}' OR`)
        }
    }

edited Sep 4, 2022 at 18:48

answered Sep 4, 2022 at 18:46

Shinebayar

263 bronze badges

1 Comment

AKX Over a year ago

This will include a final OR, which is not desired.

Collectives™ on Stack Overflow

How to loop and output values from two separate arrays into one single string

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related