'Combining fields in a Couchbase Spring-Data Query

I have a couchbase query that needs to search for a name, the object being searched stores firstName and lastName fields. My search query may be something like "Bob Smith", I have tried combining the fields in the query however this does not work ?

@Query("#{#n1ql.selectEntity} WHERE #{#n1ql.filter} AND LOWER(firstName) + ' ' + LOWER(lastName) LIKE $1 ")
javaspringspring-datacouchbasen1ql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions