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

0 vote286 views1 answer
Mysql cdn link
SQL
0 vote291 views1 answer
Mysql foreach insert
SQL
0 vote295 views1 answer
Mysql cast null to string
SQL
0 vote299 views2 answers
What is the default password for sql server sa
SQL
0 vote287 views1 answer
Plpgsql if statement
SQL
0 vote299 views2 answers
Jsonb
SQL
0 vote307 views1 answer
Mysql drop trigger
SQL
1 vote271 views1 answer
Minus vs intersect in sql
SQL
4 votes271 views2 answers
Oracle set date format
SQL
0 vote245 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL