DynamoDB nested query support

Question

Does Amazon DynamoDB scan operation allow you to query on nested attributes of type Array or Object? For example,

{     Id: 206,     Title: "20-Bicycle 206",     Description: "206 description",     RelatedItems: [         341,          472,          649     ],     Pictures: {         FrontView: "123",          RearView: "456",         SideView: "789"     } } 

Can I query on RelatedItems[2] or Pictures.RearView attributes?

Answer 1

Yes, you can use a Filter Expression, which is just like Condition Expression. The section that talks about the functions that you can use in these types of expressions mentions the following:

"For a nested attribute, you must provide its full path; for more information, see Document Paths."

The Document Paths reference has examples on how to reference nested attributes in DynamoDB data types like List (what you are calling an array) and Map (what you are calling an object). Check out that reference for examples on how to do so:

• MyList[0]
• AnotherList[12]
• ThisList[5][11]
• MyMap.nestedField
• MyMap.nestedField.deeplyNestedField