Filter and Sort Array of Docs in NodeJS [duplicate]

Question

I have an array which holds information about availability and some other info about products. Instead of returning the all Data in Array i want to only return docs in array where the avail = true and then return all sorted by the id.

[
    {
        "id": 5,
        "avail": true,
        "name": "product A",
        "qty": 18
    }, {
        "id": 9,
        "avail": false,
        "name": "product B",
        "qty": 0
    }, {
        "id": 7,
        "avail": true,
        "name": "product C",
        "qty": 3
    }, {
        "id": 1,
        "avail": true,
        "name": "product D",
        "qty": 47
    }, {
        "id": 4,
        "avail": false,
        "name": "product E",
        "qty": 0
    }
]

When you see that three people answer within 3 minutes of your question, you know that you have asked something you could have googled in less than 3 minutes. (Instead of answering, those 3 should really have voted to have this question closed as duplicate, or at least link to a dupe). — trincot
– trincot, Commented Jun 17, 2019 at 19:18

amik · Accepted Answer · 2019-06-17 19:18:04Z

2

const result = original.filter(x => x.avail);
result.sort((a, b) => a.id - b.id);

answered Jun 17, 2019 at 19:18

amik

6,0005 gold badges41 silver badges65 bronze badges

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

Comments

MattB · Accepted Answer · 2019-06-17 19:17:40Z

1

You can use filter and sort to accomplish this:

var arr = [
    {
        "id": 5,
        "avail": true,
        "name": "product A",
        "qty": 18
    }, {
        "id": 9,
        "avail": false,
        "name": "product B",
        "qty": 0
    }, {
        "id": 7,
        "avail": true,
        "name": "product C",
        "qty": 3
    }, {
        "id": 1,
        "avail": true,
        "name": "product D",
        "qty": 47
    }, {
        "id": 4,
        "avail": false,
        "name": "product E",
        "qty": 0
    }
];

var newArr = arr.filter(a => {
    return a.avail;
}).sort((a, b) => {
    return a.id > b.id;
});

console.log(newArr)

answered Jun 17, 2019 at 19:17

MattB

1,1048 silver badges15 bronze badges

Comments

Tom O. · Accepted Answer · 2019-06-17 19:24:37Z

First you can get only the records having avail: true by calling Array.prototype.filter on the data array. Next, sort those results using Array.prototype.sort and comparing the id value of each array element.

Here's an example:

const getAvailableProducts = allProducts => allProducts.filter(el => el.avail).sort((a, b) => a.id - b.id);

const available = getAvailableProducts([{
  "id": 5,
  "avail": true,
  "name": "product A",
  "qty": 18
}, {
  "id": 9,
  "avail": false,
  "name": "product B",
  "qty": 0
}, {
  "id": 7,
  "avail": true,
  "name": "product C",
  "qty": 3
}, {
  "id": 1,
  "avail": true,
  "name": "product D",
  "qty": 47
}, {
  "id": 4,
  "avail": false,
  "name": "product E",
  "qty": 0
}]);

console.log('The following products are available:');
console.log(available);

agtabesh · Accepted Answer · 2019-06-17 19:20:33Z

0

const data = [{
  "id": 5,
  "avail": true,
  "name": "product A",
  "qty": 18
}, {
  "id": 9,
  "avail": false,
  "name": "product B",
  "qty": 0
}, {
  "id": 7,
  "avail": true,
  "name": "product C",
  "qty": 3
}, {
  "id": 1,
  "avail": true,
  "name": "product D",
  "qty": 47
}, {
  "id": 4,
  "avail": false,
  "name": "product E",
  "qty": 0
}];

const filteredData = data.filter(x => x.avail).sort((a, b) => a.id - b.id);
console.log(filteredData);

answered Jun 17, 2019 at 19:20

agtabesh

5683 silver badges16 bronze badges

Collectives™ on Stack Overflow

Filter and Sort Array of Docs in NodeJS [duplicate]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related