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

18 votes234 views3 answers
Mysql add column default value
SQL
41 votes259 views6 answers
Alter table add column in SQL Server
SQL
0 vote225 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
1 vote236 views1 answer
Apex ORA-20999
SQL
1 vote225 views1 answer
Postgresql last element of array
SQL
0 vote218 views1 answer
Call function sql oracle
SQL
3 votes238 views1 answer
Where id is in list sql
SQL
3 votes224 views2 answers
Brew start mysql
SQL
1 vote224 views1 answer
Psql filed name alter
SQL
0 vote201 views1 answer
Mysql create table columns with spaces
SQL