OR conditional expression for Query in DynamoDB NodeJS

Question

I'm trying to get a list of entries from DynamoDb using FilterExpression. I'd like to return value if at least one of the statements are TRUE. But for some reason looks like AND is a default conditional operator and my result is empty. How to change default conditional operation to OR in NodeJS?

            params = {
                TableName: '......',
                IndexName : 'user_id-index',
                KeyConditionExpression: 'user_id = :user_id',
                FilterExpression: 'contains (email, :key) OR contains (name, :key)',
                ExpressionAttributeValues: {
                    ":user_id": userId,
                    ":key": item_to_search
                }
            };

Khalid T. · Accepted Answer · 2018-04-15 06:04:51Z

5

Your problem is that NAME is a reserved word in DynamoDB. So, you'll have to use ExpressionAttributeNames for that:

params = {
  TableName: '......',
  IndexName: "user_id-index",
  KeyConditionExpression: "user_id = :user_id",
  FilterExpression: "contains (email, :key) OR contains (#name, :key)",
  ExpressionAttributeNames: {
    "#name": "name"
  }
  ExpressionAttributeValues: {
    ":user_id": userId,
    ":key": item_to_search
  }
};

answered Apr 15, 2018 at 6:04

Khalid T.

10.6k5 gold badges51 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

OR conditional expression for Query in DynamoDB NodeJS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related