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 vote308 views1 answer
Select from 3 tables one is empty
SQL
2 votes318 views2 answers
Mysql date range
SQL
0 vote336 views2 answers
Psql commande \gset
SQL
4 votes319 views1 answer
Sql delete where in select
SQL
0 vote376 views1 answer
Remove mysql from centos 7
SQL
3 votes344 views1 answer
APEX elapsed time
SQL
1 vote350 views1 answer
Postgresql substring last
SQL
9 votes309 views3 answers
Where in sql
SQL
0 vote338 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote393 views1 answer
Selecting specific day in colum sql
SQL