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 vote261 views1 answer
Oracle for loop on list
SQL
0 vote256 views2 answers
How to update date in oracle
SQL
53 votes498 views6 answers
How to install mysql ubuntu
SQL
0 vote250 views1 answer
Postgresql delete multiple rows
SQL
1 vote286 views1 answer
Sql row having max
SQL
0 vote232 views1 answer
Hallo
SQL
11 votes250 views2 answers
Docker create postgres db
SQL
0 vote258 views1 answer
Search column name sql
SQL
1 vote261 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote315 views1 answer
Postgres extract number from string
SQL