fetch dynamoDB results ordered by sort key with node.js

Question

I have primary_key ('id'/string) and sort_key ('updated_at'/Unix time stamp number). When I query to dynamo DB trough lambda using node.j, I want to fetch results ordered by my sort_key.

I have tried scan but results are not ordered during scan calls. When I do the query it requires to do an operation with my primary key. How can I fetch my data sorted by sort key?

jarmod · Accepted Answer · 2020-04-13 16:08:21Z

2

In your case, you have a composite primary key comprising id plus updated_at. With this type of key you can query for records with a given id, sorted by updated_at.

If you want to sort purely by updated_at, then you need to add a Global Secondary Index on updated_at. This would require the value of updated_at to be unique for each item.

answered Apr 13, 2020 at 16:08

jarmod

79.8k18 gold badges132 silver badges137 bronze badges

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

2 Comments

Naim Mustafa Over a year ago

looks like what ive been looking for ill accept the answer as soon as I confirm. Thank you very much :)

jarmod Over a year ago

Be sure to understand what attribute projection means (at that same page). You'll need to decide which attributes to project into the GSI.

Collectives™ on Stack Overflow

fetch dynamoDB results ordered by sort key with node.js

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related