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

6 votes132 views3 answers
Update with inner join postgres
SQL
1 vote139 views1 answer
Sql order by where condition
SQL
2 votes136 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote137 views1 answer
Soql update query
SQL
0 vote142 views1 answer
Ksql quickstart docker
SQL
0 vote100 views1 answer
Sql select rows with simlar names
SQL
10 votes135 views4 answers
Drop primary key
SQL
1 vote122 views1 answer
Table infromation in sql server
SQL
0 vote150 views1 answer
Duplicate value unique constraint mysql error
SQL
4 votes171 views1 answer
Mysql delete last row
SQL