Passing an Array of Values, using Typescript/Sequelize

Question

Good afternoon, I'm a junior dev who's been trying to learn Sequelize with Typescript but am having difficulties. I've created a simple query to search based off a value, but am unable to pass an array of values without breaking the query.

const findNameTsxData = (limit: number, Name: string): Promise<FinanceStuffs[]> => {
// const { in: opIn, or } = Sequelize.Op;
  return db.FinanceStuffs.findAll({
    where: { Name },
    limit
  });
};

Right now, if i pass a query on postman as

Name: "Joe"
Limit: 10,

It returns me 10 transactions by Joe, but i'd like to be able to pass multiple names in the query such as:

Name: ["Joe", "Alex", "Jacob"]
Limit: 30

I believe the answer would be mapping the array somehow, or using Sequelize.Op but i seem to be getting multiple typescript errors when tried.

If you could explain to me what i'm doing wrong, it would be greatly appreciated as a learning experience.

Thank you!

oktapodia · Accepted Answer · 2019-09-30 15:30:30Z

2

You have to use the or keyword from sequelize like mention in the documentation

Example:

const findNameTsxData = (limit: number, Names: string[]): Promise<FinanceStuffs[]> => {
const Op = Sequelize.Op;
  return db.FinanceStuffs.findAll({
    where: { Name: { [Op.or]: Names } },
    limit
  });
};

You can also use the in if you prefer

const findNameTsxData = (limit: number, Names: string[]): Promise<FinanceStuffs[]> => {
const Op = Sequelize.Op;
  return db.FinanceStuffs.findAll({
    where: { Name: { [Op.in]: Names } },
    limit
  });
};

edited Sep 30, 2019 at 15:30

answered Sep 30, 2019 at 15:13

oktapodia

1,7781 gold badge15 silver badges32 bronze badges

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

1 Comment

frogger Over a year ago

Thank you! I had to modify the [Op.or]: Names to be inside of its own object, but it worked great!

Collectives™ on Stack Overflow

Passing an Array of Values, using Typescript/Sequelize

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related