toggle menu
QuettaCode API
0.1.0-BETA
jvm
switch theme
search in API
QuettaCode API
/
com.quettacode.flow.crm.repository
/
ContactRepository
/
search
search
@
Query
(
value
=
"SELECT c FROM Contact c WHERE c.tenantId = :tenantId AND c.deletedAt IS NULL AND (LOWER(c.name) LIKE LOWER(CONCAT('%', :query, '%')) OR c.waId LIKE CONCAT('%', :query, '%'))"
)
abstract
fun
search
(
tenantId
:
String
,
query
:
String
,
pageable
:
Pageable
)
:
Page
<
Contact
>
(
source
)