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

3 votes207 views1 answer
Sql is not like
SQL
19 votes232 views3 answers
Grant mysql
SQL
0 vote203 views1 answer
Mysql join same table multiple times group by
SQL
1 vote203 views1 answer
Add sequence postgres
SQL
0 vote201 views1 answer
Get enginge db mysql
SQL
0 vote186 views8 answers
Convert sql query to linq online
SQL
0 vote212 views1 answer
Update and keep original value sql
SQL
-1 vote223 views3 answers
Error: mysql shutdown unexpectedly.
SQL
1 vote201 views1 answer
Oracle case
SQL
2 votes212 views2 answers
Postgres select duplicate columns
SQL