Question: ordering by timestamp fields about dynogels HOT 2 CLOSED

hi @endymion00

It funny that you ask because we have to do the same thing just last week.
I spend a whole day to figure out how to do this... so hoped you didn't have to go through the same ordeal.

Yes, dynamoDB stores data type as string...
but they have RangeKey that works with dates, with the exception that the date string are stored in UTC.

so what you need to do is set the createdAt or updatedAt as the rangeKey
on insertion, you'll need to set the createdAt as part of the insertion (recommended to use momentjs moment.utc().toISOString())

then on query, you'll need to do something along the line of:

OrderTable.scan().loadAll()
        .filterExpression('CreatedAt BETWEEN :fromDate AND :toDate')
        .expressionAttributeValues({':fromDate': fromDate, ':toDate': toDate})
        .projectionExpression('OrderName, OrderId, OrderAddress') \\ optional

from dynogels.

hey @M1chaelTran,

Thank you very much for help :)
I've started the migration from number dates to ISO string dates since it is more human readable for application data troubleshooting and also to avoid transformations when sending and receiving dates from an API (we use API Gateway over dynamoDB)

And yes, moment is the way to go. I feel very confident by using this module in all my node projects. In this case with one single of line of code it is possible to migrate from number dates to string dates easily.

from dynogels.