quarkusquarkus-panache

Quarkus PanacheEntityBase query with IN


I have a customer entity of type PanacheEntityBase. I would like get all customers by ids

I can get it with customer.list("customerId", id) in a loop. I dont think its a good solution. I prefer using IN. Please suggest how to use IN with PanacheEntityBase


Solution

  • I solved the problem with customerEntity.list("customerId IN (?1)", customerIds);

    Note: customersids must be a java list (Array did not work)