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

0 vote120 views1 answer
Get only first row mysql
SQL
2 votes133 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote141 views1 answer
Mysql workbench not showing schemas
SQL
1 vote169 views1 answer
Insert column after column mysql
SQL
1 vote143 views1 answer
Sql server today minus n
SQL
3 votes101 views2 answers
Coalesce mysql
SQL
0 vote128 views1 answer
Equi joins in oracle
SQL
5 votes123 views1 answer
Ora-00054 find lock
SQL
6 votes134 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote192 views2 answers
Mysql cast to varchar
SQL