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

16 votes116 views4 answers
Mysql import from sql file
SQL
14 votes114 views3 answers
Alter foreign key
SQL
0 vote119 views1 answer
Mysql select row with min date
SQL
51 votes329 views6 answers
Installing mysql on ubuntu
SQL
3 votes110 views1 answer
Mysql UPDate with enner join
SQL
1 vote113 views1 answer
Update from table tsql
SQL
0 vote145 views1 answer
Sql anywhere create procedure
SQL
0 vote119 views1 answer
Object of class mysqli_result could not be converted to string
SQL
27 votes119 views4 answers
Get all tables with column name sql
SQL
0 vote121 views1 answer
Sql find table by name
SQL