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 vote317 views1 answer
List MySQL Table and Index Size
SQL
0 vote424 views2 answers
Insert data into multiple tables mysql
SQL
29 votes334 views5 answers
Mysql show table structure
SQL
0 vote325 views1 answer
Reset postgresql password windows
SQL
0 vote308 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote344 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote316 views1 answer
Nueva tabla mysql
SQL
2 votes312 views1 answer
How to select first row of database sql
SQL
0 vote340 views1 answer
Postgresql delete limit
SQL
0 vote336 views1 answer
Setval in postgres
SQL