Azure Cosmos DB with Java SDK - SQL query using in filter is not working

Question

Hi,

I am using Azure SDK with Spring to get the list of data's from cosmos for the given id's .So i composed the query as below,

@Query(value = " SELECT * FROM container_name km WHERE km.id IN (@ids) ")

but it is not retrieving any results, and it is not throwing any exception either.

Answer 1

Hi, @Yuvaraj Madheswaran Welcome to the Microsoft Q&A platform.

Regarding the query you provided, it looks correct, and I don't see any issues with it. However, you can try modifying the query to use a parameterized query instead of string concatenation to pass the ids parameter

@Query(value = "SELECT * FROM container_name km WHERE ARRAY_CONTAINS(@ids, km.id)")
List<MyData> getDataByIds(@Param("ids") List<String> ids);

Regards

Geetha

Answer 2

Removed the query. Modified the method as below,

List<MyData> getDataByIdInOrderByIdAsc(List<String> ids);

This fix the issue.