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 vote229 views1 answer
Psql client write to bash variable
SQL
0 vote240 views2 answers
How to get json data mysql
SQL
2 votes226 views1 answer
Mariadb select multiple rows into one column
SQL
2 votes242 views1 answer
Mariadb json select
SQL
0 vote236 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote181 views1 answer
Oracle last user logon
SQL
0 vote243 views1 answer
Insert set mysql
SQL
0 vote237 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
5 votes235 views1 answer
Minecraft java port number
SQL
0 vote252 views1 answer
Bidirectional outer join sql
SQL