How to pass multiple values to one parameter

Question

Currently i have done code to accept one category_id in the param and return output base on category_id.

if ('category' in params) {
        assert.number(params.category, 'params.category')

        const { category: category_id } = params
        query = query.where('category.id', category_id)
      }

Now i want to pass multiple values to category_id and return result for all category_id's.

I will pass like this, category_id=1,2,3

Can someone helps me to fix this?

you need to pass category_id in Array for multiple values like const { category: [1,2,3] } — Nikas, Apr 01 '20 at 11:16
https://stackoverflow.com/questions/31704936/knexjs-loop-of-queries/43953308 — mplungjan, Apr 01 '20 at 11:17

score 0 · Accepted Answer · answered Apr 01 '20 at 16:59

0

http://knexjs.org/#Builder-whereIn

query.whereIn('category.id', [1, 2, 3]);

answered Apr 01 '20 at 16:59

Rostyslav Bornitskyi

151
2
7

score 0 · Answer 2 · answered Apr 02 '20 at 07:07

Improve Ростислав Борніцький answer little bit,

if ('category' in params) {
        assert.array(params.category, 'params.category')

        const { category: category_id } = params
        query = query.whereIn('category.id', category_id)
      }

How to pass multiple values to one parameter

2 Answers2