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 vote289 views3 answers
How to run sql query
SQL
1 vote296 views1 answer
Increase existing date in sql
SQL
0 vote270 views1 answer
Check for directory in bash
SQL
5 votes253 views1 answer
Update sql user password
SQL
4 votes289 views1 answer
Alter session set nls_date_format
SQL
1 vote271 views1 answer
Mysql return text after a final full stop
SQL
2 votes273 views1 answer
Sql to char function with date
SQL
1 vote274 views1 answer
Sql into vs insert into
SQL
0 vote256 views1 answer
Insert or update cassandra
SQL
0 vote259 views1 answer
Mql5 list all available symbols
SQL