cosmos db cannot query using IN, spring data native query and array or collection(Java)

Question

I am trying to create(using spring native query) the findAllId for the reactive repository spring data cosmo DB. Since for the ReactiveCosmosRepository is not implemented.

@Query(value = " SELECT *\n" +
        " FROM   container_name km\n" +
        " WHERE  km.id IN (@ids) \n" +
        " ORDER  BY km.createdDate DESC ")
Flux<ContainerData> findAllById(@Param("ids") String[] ids);

or even

@Query(value = " SELECT *\n" +
        " FROM   container_name km\n" +
        " WHERE  km.id IN (@ids) \n" +
        " ORDER  BY km.createdDate DESC ")
Flux<ContainerData> findAllById(@Param("ids") Iterable<String> ids);

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

So the question is, how to use IN operator with spring data native query in cosmos db and collection or array out of the box without having to do a workaround.

Did you try array_contains ?

Vova Bilyachat
– Vova Bilyachat

2021-05-11 23:46:28 +00:00
Commented May 11, 2021 at 23:46 — Vova Bilyachat
– Vova Bilyachat, Commented May 11, 2021 at 23:46

Vova Bilyachat · Accepted Answer · 2021-05-10 12:54:43Z

2

You should use array_contains

@Query(value = " SELECT *\n" +
        " FROM   container_name km\n" +
        " WHERE  array_contains(@ids, km.id, true) \n" +
        " ORDER  BY km.createdDate DESC ")
Flux<ContainerData> findAllById(@Param("ids") Iterable<String> ids);

answered May 10, 2021 at 12:54

Vova Bilyachat

19.5k4 gold badges60 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cosmos db cannot query using IN, spring data native query and array or collection(Java)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related