Sorting, Skip and Limit(Skip) queries for Amazon DynamoDB

2
votes

I am new to AWS Lambda, Amazon DynamoDB and serverless. I have one user table want to do like this.

  1. I want to fetch records pagination wise in each page fetch 10 records from the user table,
  2. I want to make sorting on columns like name and email. This both column with string datatype.

I am using serverless with node.js. Here I'm attaching my serverless.yaml file

UserDynamoDbTable:
  Type: 'AWS::DynamoDB::Table'
  DeletionPolicy: Retain
  Properties:
    AttributeDefinitions:
      -
        AttributeName: id
        AttributeType: S
    KeySchema:
      -
        AttributeName: id
        KeyType: HASH
    ProvisionedThroughput:
      ReadCapacityUnits: 1
      WriteCapacityUnits: 1
    TableName: 'user'

For sorting i'm trying with this query

let params = {
     TableName: 'user',
     limit: 10,
     ScanIndexForward: false
};
dynamoDb.scan(params, (error, result) => { })

But I didn't get a response as per my requirement. Please help me here I'm new into this. Thanks in advance.

1
javascriptnode.jsamazon-web-servicesaws-lambdaamazon-dynamodb

1 Answers

1
votes

ScanIndexForward works on range key only. As the table doesn't contain range key (i.e. sort key) defined, the data is not sorted.

Specifies ascending (true) or descending (false) traversal of the index. DynamoDB returns results reflecting the requested order determined by the range key.

Unfortunately, DynamoDB can't sort the data by any other attributes. It can sort by range key only.