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

1 vote320 views2 answers
Into sql
SQL
0 vote455 views1 answer
TSQL Find csv file in folder
SQL
0 vote338 views1 answer
Mysql date only no time
SQL
4 votes349 views1 answer
Mysql timestamp in laravel migration
SQL
1 vote360 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote355 views1 answer
WHERE not regex in SQL
SQL
0 vote336 views1 answer
How to check if there is no database schema
SQL
34 votes396 views5 answers
Oracle alter table add column
SQL
9 votes341 views4 answers
Add primary key to existing table sql
SQL
2 votes329 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL