By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

AWS CLI filter using Query

0

Hi, I want to query list of DocumentDB instance classes and apply a filter to StorageType attribute. I realized that the filter criteria I use ?storagetype=='invalid' does not affect the output. What am I doing wrong here?

aws docdb describe-orderable-db-instance-options --engine docdb --vpc --region eu-central-1 --engine-version 5.0.0 --query 'OrderableDBInstanceOptions[?storagetype=='invalid'].DBInstanceClass'

Thanks in advance

Topics
Management & Governance
Tags
AWS Command Line Interface
Language
English
Eralper
asked 4 months ago91 views
1 Answer
1

Can you try to either put the query in quotes

“OrderableDBInstanceOptions[?storagetype=='invalid'].DBInstanceClass”

Or have the invalid string as:

'OrderableDBInstanceOptions[?storagetype== `invalid`].DBInstanceClass'
profile picture
EXPERT
Antonio_Lagrotteria
answered 4 months ago
profile picture
EXPERT
Gary Mclean
reviewed 4 months ago
  • Eralper
    4 months ago

    Thank you Antonio,

    The first option worked for me aws docdb describe-orderable-db-instance-options --engine docdb --vpc --region eu-central-1 --engine-version 5.0.0 --query "OrderableDBInstanceOptions[?StorageType=='standard'].DBInstanceClass"

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content