this is my first time working with PANACHE. I am trying to call a simple query but I get returned a empty list. This is the code
val paramsMap = Parameters()
paramsMap.and("guuid", "092ed247-887e-4ffe-8b9e-876c307c038")
val panacheQuery = find(":guuid IS NULL OR GUUID = :guuid OR GUUID LIKE '%' || :guuid || '%'", paramsMap)
val en = panacheQuery.list<MldEntity>()
println(en)
When I change the value of GUUID to NULL it works as it should, also if I change it to exactly one of the existing ones in the database, GUUID = :guuid hits, but when i remove on character i get returned nothing?
It works when i run in sql console