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 vote340 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote306 views1 answer
Sql run multiple updates in one query
SQL
0 vote314 views1 answer
Mysql get only the field names in a table
SQL
0 vote291 views1 answer
Disableforiegn key check
SQL
2 votes307 views1 answer
Oracle list grants on package
SQL
0 vote315 views1 answer
Sql examples from framework
SQL
17 votes312 views6 answers
MySQL ORDER BY
SQL
0 vote323 views1 answer
Mysql a from on this page has
SQL
0 vote314 views3 answers
Delete in SQL SERVER
SQL
6 votes332 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL