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

2 votes296 views4 answers
2nd highest salary in mysql
SQL
0 vote338 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote282 views1 answer
This week mysql
SQL
1 vote281 views5 answers
Sql 2nd highest salary
SQL
0 vote296 views1 answer
Mysql get only the field names in a table
SQL
0 vote303 views1 answer
Alter boolean column postgresql
SQL
35 votes332 views5 answers
Sql alter column
SQL
0 vote286 views1 answer
Mysql workbench view
SQL
0 vote319 views2 answers
Mysql dump database tables only
SQL
0 vote290 views1 answer
What alter does in db
SQL