How to convert query ' WHERE IN' of strings with TypeORM Query Builder?

Question

Getting errors in following TypeORM query:

async exportUsers(stateId: string, zipcodes: string) 
{
  //zipcodes = '60563', '54656', '94087';//
  const query = await this.userRepository
  .createQueryBuilder('user')
  .select('user.email', 'email')
  .where('left(user.Zip,5) in :zip', { zip: zipcodes }); 
}

How to pass string containing 'array of strings' to TypeORM query using IN.

N2517 · Accepted Answer · 2021-11-04 16:31:05Z

5

This worked:

zipcodes = '60563', '54656', '94087';
const ziplist: string[] = zipcodes.replace("'", "").split(",");

Changed query to:

.where('left(s.ShipToZip,5) in (:...zip)', { zip: ziplist });

edited Nov 4, 2021 at 16:31

answered Aug 22, 2021 at 17:32

N2517

811 silver badge7 bronze badges

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

Comments

Dharman · Accepted Answer · 2021-08-21 08:27:13Z

0

Replace your where clause with this code:

.where("left(user.Zip,5) IN (:zip )", { zip : zipcodes })

Note: your zipcode variable should be in array format; in means:

zipcodes = ['94085','54656','94087']

edited Aug 21, 2021 at 8:27

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Aug 21, 2021 at 8:21

negin motalebi

3934 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to convert query ' WHERE IN' of strings with TypeORM Query Builder?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related