nova
Reputation: 313
How to query the greates value (sortkey/range) dynamodb?
Maybe this is a very simple question but I didn't find a suitable solution for this. I have a secondary key /range key /sort key, what ever and its value is a number. So in the Table a several items with this key and I want to get the Item with the greatest number/value. I found this at stack overflow but this does not look like something from the aws documentation. In this documentation you can find gt or ge but I don't want to compare the value with a number, I want the greatest ... Maybe you can help
Upvotes: 1
Views: 527
Answers (1)
birnbaum
Reputation: 4966
If the property you want to query is your sort/range key, you only need to set ScanIndexForward=false (order descending) and set the Limit to 1
Upvotes: 2
Related Questions
- How do I get the path to the current script with Node.js?
- How can the default node version be set using NVM?
- How can I update each dependency in package.json to the latest version?
- How can I get the full object in Node.js's console.log(), rather than '[Object]'?
- How to get GET (query string) variables in Express.js on Node.js?
- How to import an SQL file using the command line in MySQL?
- What is the recommended way to delete a large number of items from DynamoDB?
- How do you get a list of the names of all files present in a directory in Node.js?
- TypeScript getting error TS2304: cannot find name ' require'
- What is the purpose of Node.js module.exports and how do you use it?