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 votes136 views4 answers
Mysql decimal
SQL
1 vote143 views2 answers
Oracle list partitioned tables
SQL
2 votes142 views1 answer
Date conversion in mysql column
SQL
0 vote167 views1 answer
Mysql grant user wildcard database
SQL
10 votes147 views4 answers
Else if mysql
SQL
0 vote148 views1 answer
Extract sql from query object sqlalchemy
SQL
5 votes159 views1 answer
How to get all table names in sql query
SQL
0 vote182 views1 answer
Sqlite update where exists
SQL
2 votes151 views1 answer
Mysql trigger after update
SQL
1 vote150 views1 answer
Float precision in psql
SQL