Nested attributes query on DynamoDB

Question

I have something like this on Dynamo:

{
    "mail": "[email protected]",
    "data": {
        "type": 1
    }
}

I have an index on "mail" attribute and I'm trying to query over all data found with an specified mail filtering the attribute "data". Something like this:

const params = {
    TableName: 'tableName',
    IndexName: "mail_index",
    KeyConditionExpression: "#mail = :mail",
    FilterExpression: '#status = :val',
    ExpressionAttributeNames: {
        '#mail': 'mail',
        '#status': 'data.type'
    },
    ExpressionAttributeValues: {
        ':mail': '[email protected]',
        ':val': {N: 5}
    } 
};

dynamoDoc.query(params, (err, data) => {
    console.log(data);
});

But I'm always getting an empty result. What am I doing wrong?

Milan Cermak · Accepted Answer · 2019-02-28 17:58:47Z

2

Try this:

const params = {
    TableName: 'tableName',
    IndexName: "mail_index",
    KeyConditionExpression: "#mail = :mail",
    FilterExpression: '#data.#type = :val',
    ExpressionAttributeNames: {
        '#mail': 'mail',
        '#data': 'data',
        '#type': 'type'
    },
    ExpressionAttributeValues: {
        ':mail': '[email protected]',
        ':val': {N: 5}
    } 
};

Because both data and type are reserved words, DynamoDB needs both of them to be escaped.

answered Feb 28, 2019 at 17:58

Milan Cermak

8,1043 gold badges48 silver badges60 bronze badges

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

1 Comment

RFE Over a year ago

Thx! Worked for me

Collectives™ on Stack Overflow

Nested attributes query on DynamoDB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related