posted 3 weeks ago
I created a DynamoDb table ProductCatalog. Next, I created a item with id (primary key) as 1, title as 'Book 210 Title' and vendorInfo as the below JSON:
This constitutes one item.
I did a scan on the table which displayed the item. Next, I did a query by specifying id as 1, it returned the item as result.
I am now trying to query using a parameter which is inside the JSON (for example : name under VO1 which has the value 'Acme Books').
I tried by specifying VO1.name but it did not return results.
I have seen such kind of querying in CosmosDb which is also a document oriented NoSql database like DynamoDb.
How do I try such kind of query ?
Thanks.