Can't query on DynamoDB records where attribute is null

Question

Can't get query on DynamoDB null attributes. I have below query, I am getting NameError: name 'true' is not defined

const filter = {
    FilterExpression: 'id = :null',
    ExpressionAttributeValues: {
        ':null': true,
    },
};

user3807691 · Accepted Answer · 2020-11-05 12:16:08Z

1

You need to specify the type of null as well.

Try this :

const filter = {
  FilterExpression: 'id = :null',
  ExpressionAttributeValues: {
    ':null': {BOOL: true}
  }
};

answered Nov 5, 2020 at 12:16

user3807691

1,3242 gold badges11 silver badges33 bronze badges

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

1 Answer 1