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