AWS DynamoDB Scan on Set attribute

Question

How does scan work with Set Attribute Type (NS or SS). I like to provide some condition for retrieve a Set. For eg: in Table I have

{Item1: Attr1{NS : 1,2,3,4,5}}
{Item2: Attr1{NS : 6,7,8}}
{item3: Attr1{NS : 7,10}}

I'd like to take the Item2 and Item3 by giving some scan condition. Can any one help me with this?

Michael Hart · Accepted Answer · 2012-12-13 06:47:31Z

2

Use CONTAINS or NOT_CONTAINS as the ComparisonOperator of the ScanFilter (more info here: http://docs.amazonwebservices.com/amazondynamodb/latest/developerguide/API_Scan.html)

Eg:

{
  "TableName":"MyTable",
  "ScanFilter": {
    "Attr1": {
      "AttributeValueList": [{"N":"7"}],
      "ComparisonOperator": "CONTAINS"
    }
  }
}

This will return Item2 and Item3 because they both contain 7.

answered Dec 13, 2012 at 6:47

Michael Hart

5,1893 gold badges25 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

AWS DynamoDB Scan on Set attribute

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