Unable to filter query results in web console

Question

Hi,

I used the following tutorial to set up a dynamoDB that is populated by an IoT rule.
https://docs.aws.amazon.com/iot/latest/developerguide/iot-ddb-rule.html

I can see the data that has been inserted using the DynamoDB Explore Items interface in the AWS console.  I would now like to use the Scan or Query console interface to filter the results based on a stored attribute.  It seems that no matter what I try for the attribute name I can't seem to get a match.   I'm having difficulty finding definitive guidance on how the attribute naming works in the console i/f (most docs deal with API or CLI).    In my case the attribute I want is called 'Code' and it is under a Map attribute called 'mqtt_data' so I'm assuming I should be using mqtt_data.Code as my attribute name.

I did find the following post https://stackoverflow.com/questions/62898632/how-to-filter-map-in-dynamodb-on-aws-console that suggests that "Filtering MAP or LIST in web console is not possible.".  This would seem to be a problem for my use case as all of the data inserted by the IoT rule is under a single top-level MAP.   Can anyone confirm if this is true?  It seems odd to support MAPs in the CLI or API but not in the console.   My preference is for the console so that my clients don't need to run code in order to get the data they need.  Can anyone suggest a work-around?

Thanks!
Phil

Accepted Answer

Your problem is you are trying to filter on a nested value, which is not possible in the web console. These are the only values to filter on:
![Enter image description here](/media/postImages/original/IMFDAojliOSSyeF46vHgcaPw)

You can use the [PartiQL Web Console](https://eu-west-1.console.aws.amazon.com/dynamodbv2/home?region=eu-west-1#partiql-editor) and issue a SQL like query, for exampe:

```
SELECT *
FROM MyTable 
WHERE mqtt_data.Code= 'some value' 
```

Answer

The tutorial you followed uses the DynamoDB[1] action. An alternative would be to use the DynamoDBv2[2] action to write the payload content to separate columns in the DynamoDB table. In this way you could leverage the DynamoDB Explorer UI to filter the items.

[1] https://docs.aws.amazon.com/iot/latest/developerguide/dynamodb-rule-action.html
[2] https://docs.aws.amazon.com/iot/latest/developerguide/dynamodb-v2-rule-action.html

Unable to filter query results in web console

Relevant content