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 votes174 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote143 views1 answer
Postgres read table structure
SQL
0 vote150 views1 answer
Oracle table privileges
SQL
1 vote105 views1 answer
Mysql collation
SQL
6 votes174 views2 answers
Return columns from table sql
SQL
2 votes160 views1 answer
Oracle sql merge
SQL
0 vote136 views1 answer
First Step in installing SQL workbench
SQL
1 vote144 views2 answers
Find a column in all tables mysql
SQL
22 votes153 views3 answers
How to join three tables in sql using joins
SQL
2 votes159 views1 answer
Oracle drop sequence if exists
SQL