0

I am having trouble sorting my DynamoDB database by createdAt

I am working from the AWS console. I’m using AWS AppSync and DynamoDB for the back-end, and React and Apollo Client for the front-end. I’m not using AWS Amplify (company policy)

My original DynamoDB table doesn’t have a createdAt column, which I think is adding to the issue

I have tried creating mutations to add in new records WITH a createdAt timestamp, but it is not working.

I have tried writing queries multiple different ways.

I have tried updating my Type in Schema to include "@model (timestamps: etc.)"

I have tried adding this to the response template for the schema resolver: "$util.time.nowISO8601()"

What is the best way be able to sort the records according to most recent to least and vice versa? With AWS AppSync, DynamoDB, ApolloClient, and React, not AWS Amplify

If you could, please specify if I need to change up my Type, or my Query/mutation, or what the query should look like

Thank you

PhuongHoang68
  • 1

1 Answers1

0

Sorting on DynamoDB is only by the sort key for a given item collection (items which share the same key but uniquely identified by sort key). That means you cannot get ordering of items across the entire table.

If you want to have a sorted order of all items across the entire table you will need to create an index with a static value as the partition key and createdAt as the sort key.

Leeroy Hannigan
  • 11,409
  • 3
  • 14
  • 31
  • Hi. Does DynamoDB have built-in timestamps for when we create the records? I want to access the createdAt time for each of the records but I am having trouble doing so. Do you have suggestions? – PhuongHoang68 Jun 23 '23 at 14:08
  • No. You would need to add the attribute yourself. There are no system variables or metadata at play. – Leeroy Hannigan Jun 23 '23 at 14:29