Query on AWS DynamoDB for Boolean and Date ranges

Question

I have 2 problems. I want to query a dynamodb database on Bool and on Date.

Is this possible as I only see String Number and Binary?

notionquest · Accepted Answer · 2016-11-07 10:50:53Z

2

There are two types of expressions.

KeyConditionExpression - Supports only String, Number and Binary

FilterExpression - Can be used for Non-Key attributes. You can query for the Date and BOOL attributes.

There is a BETWEEN operator which can be used for DATE range as well.

Code to filter by Date:-

var params = {
    TableName : table,
    KeyConditionExpression : 'email = :email',
    FilterExpression: 'createdAt = :createdAt',
    ExpressionAttributeValues : {
        ':email' : '[email protected]',
        ':createdAt' :  "2016-11-07"
    }   
};

My Item:-

Date is stored as String in database.

Date S (string type). The Date values are stored as ISO-8601 formatted strings.

edited Nov 7, 2016 at 10:50

answered Nov 7, 2016 at 10:10

notionquest

39.4k6 gold badges120 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

cdub Over a year ago

I cannot get FilterExpression to query for Bool or Date

cdub Over a year ago

See this other post I have stackoverflow.com/questions/40461910/…

cdub Over a year ago

You haven't answered the other post

cdub Over a year ago

other stack posters seem to exprience the same issue too

adamkonrad Over a year ago

I'm pretty sure this is some nasty hack on the DynamoDB side. I'd use integer timestamp and query that. Can't fool a number.

Collectives™ on Stack Overflow

Query on AWS DynamoDB for Boolean and Date ranges

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related