Does SQL Parameter supports "IN"?

[jeffpeiyt]

Does the SQL parameter support "IN"? If yes, can we add an example?

The use case is

SELECT * FROM c WHERE c.attribute IN ('value1', 'value2')

https://docs.microsoft.com/en-us/azure/cosmos-db/sql-query-keywords#in

Parameter values can be any valid JSON: strings, numbers, Booleans, null, even arrays or nested JSON. Since Azure Cosmos DB is schemaless, parameters aren't validated against any type.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: d4787bd5-5e70-c491-0772-5158de8b8624
• Version Independent ID: cb34b3f3-4dcb-0c98-ace5-1da73b2259bc
• Content: Parameterized queries in Azure Cosmos DB
• Content Source: articles/cosmos-db/sql-query-parameterized-queries.md
• Service: cosmos-db
• Sub-service: cosmosdb-sql
• GitHub Login: @timsander1
• Microsoft Alias: tisande

[ChaitanyaNaykodi-MSFT]

Hello @jeffpeiyt, Thank you for your feedback! We will review and update as appropriate.

[jeffpeiyt]

https://stackoverflow.com/questions/60933325/how-to-create-the-sqlqueryspec-in-java-in-order-to-retrieve-a-list-of-documents resolves the issue. Consider add it to the doc so that it saves people 4 hours on trying and googling.