How to filter by elements in an array in dynamoose

Question

I've dynamoose schema like below.

var dynamoose = require('dynamoose');
 
var City = dynamoose.model('City', { id: Number, name: String });

and City names data like 'City1', 'City2',...'City100'

I'm trying to get the cities whose city names are 'City2', 'City8' and i didn't find any solution

i tried like below

Model.scan({ name: { contains: 'City2' } }).exec();

How to add City8 also

Note: name column doesn't have any index

sohaso · Accepted Answer · 2022-11-24 19:14:46Z

2

I see that you are using scan. I would use query as it's more performant and more.

The query can be something like:

CitiesModel.query("name").eq("City01").or().where("name").eq("City10").exec()

Regards!

answered Nov 24, 2022 at 19:14

sohaso

1352 silver badges9 bronze badges

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

Comments

Heisenbug · Accepted Answer · 2024-11-11 19:34:50Z

0

I would create a new index with name as hashkey and use .getBatch function. It takes an array of ids (I believe 50 ids is the size limit).

answered Nov 11, 2024 at 19:34

Heisenbug

9707 silver badges26 bronze badges