dynamodb - scan items by value inside array

Question

I'm doing a table scan. This table has an array as one of its fields, the "apps" field (apps is not a key of any kind). I want to select all rows, whose apps array contains a certain value "MyApp". I tried something of that kind, but my syntax is incorrect:

    ComparisonOperator = "#apps CONTAINS :v",
    ExpressionAttributeNames = {
        '#apps': 'apps'
    },
    ExpressionAttributeValues = {
        ":v": "MyApp"
    }

Thanks.

Matias Cicero · Accepted Answer · 2017-04-22 20:37:52Z

16

The documentation about Condition Expressions clearly states that the appropiate syntax is:

contains(#apps, :v)

The correct request would be:

FilterExpression: "contains(#apps, :v)",
ExpressionAttributeNames: { "#apps": "apps" },
ExpressionAttributeValues: { ":v": "MyApp" }

edited Apr 22, 2017 at 20:37

answered Mar 17, 2016 at 18:00

Matias Cicero

26.5k21 gold badges91 silver badges160 bronze badges

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

Collectives™ on Stack Overflow

dynamodb - scan items by value inside array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related