count rows with x value node.js

Question

I have this:

if (rows[i]["SUB_STATUS"] == "ACTIVE") {
   console.log("status is " + rows[i]["SUB_STATUS"])
 } else if (rows[i]["SUB_STATUS"] == "INACTIVE") {
    console.log("status is inactive " + rows[i]["SUB_STATUS"])
}

and I want to count the number of rows that my table holds with rows[i]["SUB_STATUS"] = to inactive, and active. How is this possible?

about14sheep · Accepted Answer · 2022-01-08 17:23:14Z

1

Without having more context, I can't tell exactly how you want this information stored. However, it is rather simple to keep a count of occurrences. You can store the number of times you encounter either of these situations in variables.

let numActive = 0;
let numInactive = 0;

if (rows[i]["SUB_STATUS"] == "ACTIVE") {
   numActive++;
   console.log("status is " + rows[i]["SUB_STATUS"])
 } else if (rows[i]["SUB_STATUS"] == "INACTIVE") {
    numInactive++;
    console.log("status is inactive " + rows[i]["SUB_STATUS"])
}

// Do something with these values
console.log('Number of active:', numActive);
console.log('Number of inactive:', numInactive)

answered Jan 8, 2022 at 17:23

about14sheep

2,0992 gold badges14 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

count rows with x value node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related