amazon web services - javascript query last items in dynamodb from aws lambda - Stack Overflow

admin管理员组

文章数量:1352147

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.

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.

• javascript
• amazon-web-services
• aws-lambda
• amazon-dynamodb

Share Improve this question Follow asked Nov 27, 2018 at 6:20 Kevin FangKevin Fang 2,01244 gold badges1717 silver badges3333 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 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.

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

本文标签： amazon web servicesjavascript query last items in dynamodb from aws lambdaStack Overflow