QUERY JPQL

select la 
  from lancamento la 
 where (:descricao is null or descricao like %:descricao%) 
   and (:dataDe is null or dataVencimento >= :dataDe) 
   and (:dataAte is null or dataVencimento <= :dataAte)

Source: app.algaworks.com

Similar codes

15 votes201 views2 answers
Open postgress in terminal mac
SQL
2 votes289 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote225 views1 answer
Mysql drop trigger
SQL
3 votes252 views1 answer
Oracle detect invalid password
SQL
18 votes201 views2 answers
Sql inner join
SQL
0 vote227 views2 answers
Nested query
SQL
3 votes193 views1 answer
What is having clause
SQL
0 vote198 views1 answer
Can we rollback deleted data in sql
SQL
0 vote196 views1 answer
Sql get month from date
SQL
0 vote284 views1 answer
Generate sql from specific migration ef core
SQL