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 vote185 views1 answer
SQL get max per id
SQL
4 votes201 views2 answers
Mysql alter table set column unique
SQL
4 votes153 views3 answers
Create table if not exists postgresql
SQL
0 vote190 views1 answer
Alter owner in PostgreSQL
SQL
32 votes194 views6 answers
Sql count where
SQL
0 vote212 views1 answer
Grant privileges of databse to user
SQL
0 vote183 views1 answer
Not equal to blank in mysql
SQL
2 votes220 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote183 views1 answer
Login phpmyadmin without password
SQL
0 vote198 views1 answer
Sqlite to csv statement
SQL