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 vote158 views1 answer
Edit a field mysql terminal
SQL
5 votes252 views4 answers
Sql check
SQL
0 vote256 views1 answer
Sql server system messeges
SQL
0 vote182 views1 answer
Limit in access query
SQL
1 vote185 views2 answers
Begin transaction sql
SQL
0 vote125 views1 answer
Check sql query executed wp
SQL
0 vote184 views1 answer
How to join result table in mysql
SQL
0 vote170 views1 answer
Postgres where
SQL
1 vote182 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote171 views1 answer
Restore backupfile discourse
SQL