This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 76%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
0
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_test ) \n" +
" ORDER BY km.createdDate DESC ")
Flux<ContainerData> findAllById(@Paramjeet Dahiya ("ids") String[] ids);
or even
@Query (value = " SELECT *\n" +
" FROM container_name km\n" +
" WHERE km.id IN (@IDS_test ) \n" +
" ORDER BY km.createdDate DESC ")
Flux<ContainerData> findAllById(@Paramjeet Dahiya ("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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
@Claudio Resende , thank you for reaching out to us. I would like to share with you this sample for usage of Spring Native Cosmos DB APIs. And, here is the official interface sample that you can refer to, while developing your project.
I could not find OOB usage of array of strings for ReactiveCosmos methods, but you can do something like below:
@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);
where you can construct ids like below:
List<String> idsList = Arrays.asList("String 1", "String 2", "String 3");
String ids = String.join(", ", idsList);
Let me know if this helps you.
Hi,
Thank you for your reply, I have tried it before, but didn't work either, but I managed to sort it out using arrays_contain
" WHERE array_contains(@ids, km.id, true) ")
it worked like a charm.
It could be achieved by
@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);