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

3 votes150 views1 answer
Pl sql escape &
SQL
0 vote157 views1 answer
Sp in sql server
SQL
0 vote149 views1 answer
C# check if mysql query modified rows
SQL
0 vote136 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote165 views1 answer
How to install Firebird
SQL
18 votes142 views3 answers
Mysql add column with default value
SQL
3 votes162 views2 answers
Oracle apex view logs
SQL
0 vote182 views1 answer
Postgres get database encoding
SQL
0 vote149 views1 answer
How to export only procedures mysql
SQL
0 vote144 views1 answer
Best way to bind parameters to SqlCommand C#
SQL