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

1 vote110 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote96 views1 answer
Sqlite closes value
SQL
2 votes110 views1 answer
Mysql change data type of column
SQL
0 vote114 views1 answer
Mysql get first 2 characters of string
SQL
0 vote113 views1 answer
Set engine to innodb
SQL
0 vote134 views1 answer
Mysql best varchar length size
SQL
20 votes95 views2 answers
Counting in sql
SQL
0 vote112 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote100 views1 answer
Sql update table remove spaces
SQL
0 vote104 views1 answer
Postgres drop type
SQL