how to define the query for findBySearchTerm?

opensingular / singular-keycloak-database-federation

Keycloak User Storage SPI for Relational Databases (Keycloak User Federation, supports postgresql, mysql, oracle and mysql)

Apache License 2.0

120 stars 57 forks source link

how to define the query for findBySearchTerm? #45

Open WalkerWalker opened 1 year ago

WalkerWalker commented 1 year ago

sorry for this naive question. I am not sure how to define the query for findBySearchTerm. Currently I am doing something like the following, but I guess it should be more powerful? Thank you in advance.

select id, username, email, first_name as "firstName",last_name as "lastName" from auth_user where username like (?)

WalkerWalker commented 1 year ago

any help