How to query couchbase with multiple values using spring-data-couchbase

Question

Hi I have an endpoint like /findBy and it can take several query params similar like ;

findBy?color="blue"&size="big"&city="ny"&country="usa"

How can I have such query in repository layer using spring-data-couchbase. Normally if it would something like findByCity or findByColor only I would have such methods in my repository

@Repository
public interface HouseRepository  extends CouchbaseRepository<House, String> {

    House findByColor(String Color);
    House findByCity(String City);
}

but in this case I might not get all the parameter values. I want to query whatever values I have. Same findBy should return the values in these cases:

findBy?country="usa"
findBy?city="ny"&country="usa"
findBy?color="blue"&size="big"

Can such thing be done using spring data couchbase without writing custom sql queries?

score 2 · Answer 1 · answered Mar 20 '22 at 17:33

You can use `Querydsl Extension.`

Querydsl is a framework that enables the construction of statically typed SQL-like queries through its fluent API.

You have QueryDSL integration, you can derive queries from the attributes contained in a Request query string.

Please see these links for more information:

How to query couchbase with multiple values using spring-data-couchbase

1 Answers1

You can use Querydsl Extension.

You can use `Querydsl Extension.`