DynamoDB: Get Unique Values (Guide w/ Code Examples)
Provided by Rafal Wilinski
To retrieve unique values from a DynamoDB table using the JavaScript SDK, you can use the query
or scan
operations and set the Distinct
parameter to true
. This will return only the unique values for the specified attribute.
But the scan
operation does not support Distinct
parameter, instead, you can use the filterExpression
to filter the unique values.
var params = { TableName: "myTable", Distinct: true, KeyConditionExpression: "#product = :product", ExpressionAttributeNames: { "#product": "product" }, ExpressionAttributeValues: { ":product": "myProduct" } }; dynamodb.query(params, function(err, data) { if (err) { console.log(err); } else { console.log(data); } });
Similar Code Examples
- DynamoDB: Delete Multiple Items in Javascript
- DynamoDB: Not Begins With
- DynamoDB: Get Last Inserted Item
- DynamoDB: Delete All Items With Partition Key
- DynamoDB: Query Ends With
- DynamoDB: Query Count
- DynamoDB: Like
- DynamoDB: Get By ID
- DynamoDB: Query Greater Than
- DynamoDB Get in Typescript
- DynamoDB: Delete
- DynamoDB: Not Between
- DynamoDB: Get Query
- DynamoDB: Query Items
- DynamoDB: Create if Not Exists
Spend less time in the AWS console, use Dynobase.
Start your 7-day free trial today
Product Features
DynamoDB Tools
DynamoDB Info
© 2024 Dynobase