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

42 votes259 views6 answers
Install beautifulsoup
SQL
0 vote211 views1 answer
Data types mysql vs postgresql
SQL
2 votes192 views1 answer
How to make insert script from table in SQL server
SQL
0 vote235 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
4 votes200 views2 answers
REST API
SQL
0 vote178 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote195 views1 answer
Sql server for loop
SQL
1 vote138 views1 answer
Mssql string length
SQL
0 vote194 views1 answer
Tinydb add table
SQL
1 vote128 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL