DynamoDB query on sub field of JSON Object
<p>Is it possible to search for a subfield of a json object in dynamoDB table?</p>

<p>My table:</p>

<pre><code>Item: "item name",  
Location: {...},  
ItemInformation :  
{  
   ItemName: "itemName",  
   ProductLine: {  
      Brand: "Razer",  
      ManufacturerSource: "Razer"  
}
</code></pre>

<p>Originally in this table ItemInformation would be a key and searching for an object we would construct the json for the item information and then query with the json string as a key.. Now we need to implement searching by sub fields of that object, which can contain different fields each time, i.e. isDigital: "true". </p>

<p>I notice in the question:
<a href="https://stackoverflow.com/questions/29410402/dynamodb-advanced-scan-java">DynamoDB advanced scan - JAVA</a></p>

<p>The answer would seem to be no and I would have to separate out the fields. But I am curious about why and how the PHP library can query for sub fields on a JSON object in dynamoDB. Is there really no better solution then to store the column as separate fields and then add an index on all fields?</p>