1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
-1
Hi Sanderk77. The documentation on nested object queries should get you on the right path: https://docs.aws.amazon.com/iot/latest/developerguide/iot-sql-nested-queries.html
UPDATE: Example query (using a wildcard to deal with the un-named array).
SELECT (SELECT * FROM * where type = 'S4' and unlocked = false) as value FROM 'topic'
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 3 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
Hi, thanks for your response. I've already looked at that page, but all the examples are named arrays. So I'm really looking for an example for this problem.
Hi. Answer updated with an example query.