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

2 votes223 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote226 views1 answer
Excel export from sql using python
SQL
0 vote215 views2 answers
Plsql function that return a table
SQL
1 vote227 views1 answer
Mysql current running queries
SQL
0 vote239 views1 answer
Sql find gaps in date ranges
SQL
0 vote193 views1 answer
SQL server select to get sum of hours
SQL
2 votes220 views3 answers
How to pass password mysql command line
SQL
1 vote222 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote220 views1 answer
Create database store
SQL
3 votes201 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL