JPQL - Passing in a list of integers for string filter
£10-20 GBP
Cerrado
Publicado hace casi 4 años
£10-20 GBP
Pagado a la entrega
I'm currently working on a filter for my application, I'm trying to provide filtering for all possible outcomes which can include having a name with all integers. So for example, while the name robert filters fine, if I had a name with 111, it can't seem to find it despite existing in the db.
JPQL:
@Query("SELECT e FROM DeTest e, DeExample c WHERE e.id= [login to view URL] " +
"AND (:name is null OR [login to view URL] LIKE '%' + :name+ '%')"...)
Page<DeTest> findAllEntities (@Param("name") String name...)
I can provide more info if needed, any help would be apprecited.