Dynamodb projection by map contents

Question

my dynamodb table contains items like this

I know i can use a projection like:

        proj := expression.NamesList(expression.Name("key_Ravenna"))

to filter my results by key, but how can I filter by contents of the maps? e.G. "WHERE LatD == 41"

Appreciate the help, just started migrating my mongodb application to dynamodb

F_SO_K · Accepted Answer · 2020-05-04 20:21:38Z

1

You can access nested elements such as Maps using 'dot' notation:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Expressions.Attributes.html#Expressions.Attributes.NestedAttributes

aws dynamodb scan --table-name YOURTABLE --filter-expression 'key_Reading.Data.LatD = :val' --expression-attribute-values '{":val":{"S":"41"}}'

I've used a scan as an example, which searches across across every item in your table, but you might want a query, only searches across one partition key.

answered May 4, 2020 at 20:21

F_SO_K

15k6 gold badges64 silver badges90 bronze badges

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

2 Comments

H.Molnar Over a year ago

OK, thank you. Is it possible to get the item from my post but it only returns "key_Reading" because LatD=41 ? Like a projection would work, but i don't know whitch key to project from the begining

F_SO_K Over a year ago

Do you want to pass in the attribute name and/or value as a variable? You can just use the name of the variable, rather than a literal like "41.

Collectives™ on Stack Overflow

Dynamodb projection by map contents

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related