javascript query last items in dynamodb from aws lambda

Question

So I have a dynamodb table with a primary key ID and a secondary key Time which is a number/timestamp. Now I want to query the latest record of a particular ID. I tried to construct the parameters like this but don't know how to move forward to query the item with the largest Time.

function get_snapshot(id, callback){
    let params = {
        TableName: "Table1",
        KeyConditionExpression: "ID = :id and Time ", // here I stuck
        ExpressionAttributeValues: {
        ":id": id
        }
    }; 
    docClient.query(params, function(err, data){
        ... // process the fetched item here
    })
}

I'm quite new to this field. There could be a lot of rookie mistakes. Any help is appreciated.

Vitor Ceolin · Accepted Answer · 2021-09-21 13:26:47Z

10

You don't actually need the Time attribute for your query. If you want to get the 10 latest items, for example, your query params should look like this:

let params = {
    TableName: "Table1",
    KeyConditionExpression: "ID = :id",
    ExpressionAttributeValues: {
        ":id": id
    },
    ScanIndexForward: false,
    Limit: 10
};

ScanIndexForward: false tells DynamoDB that it should return results starting with the highest sort key value. Limit: 1 tells DynamoDB that you only want to get the first 10 results.

edited Sep 21, 2021 at 13:26

Vitor Ceolin

2262 silver badges20 bronze badges

answered Nov 27, 2018 at 7:00

Matthew Pope

7,7292 gold badges34 silver badges57 bronze badges

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

Comments

Wogwugwu Zenith · Accepted Answer · 2021-01-21 06:09:09Z

0

Just to add, the ScanIndexForward is a boolean, and isn't supposed to be quoted.

So

let params = {
    TableName: "Table1",
    KeyConditionExpression: "ID = :id",
    ExpressionAttributeValues: {
        ":id": id
    },
    ScanIndexForward: false,
    Limit: 1
};

Thanks for this answer 🙏

answered Jan 21, 2021 at 6:09

Wogwugwu Zenith

93 bronze badges

Collectives™ on Stack Overflow

javascript query last items in dynamodb from aws lambda

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