create dynamic query in spring data

Question

How to Create Dynamic Queries When Parameters are Listed, If We Have Multiple Comboboxes, For each Combobox to be Selected, an and must be added to the query that does not work in jpql enter image description here

please upload your code too, so we can see if what you want clearly! — sovannarith cheav, Oct 16 '19 at 08:30

score 0 · Answer 1 · answered Oct 16 '19 at 08:29

0

The proper JPA query format would be:

SELECT t FROM table_name t WHERE t.val IN :list;

where :list is your list of values.

answered Oct 16 '19 at 08:29

sovannarith cheav

743
1
6
19

Sometimes the user does not enter anything as input There is an error – fariba Oct 16 '19 at 09:53
@fariba I mean to use datatype List, ex: List atmTypeIdList . And you should write you code to prevent error from user input too. – sovannarith cheav Oct 16 '19 at 09:59

score 0 · Answer 2 · answered Oct 16 '19 at 10:35

You won't be able to do it directly, for that you need to use JPA specification using it you can achieve dynamic parametric query.

Refer this link from Specification: https://spring.io/blog/2011/04/26/advanced-spring-data-jpa-specifications-and-querydsl/

create dynamic query in spring data

2 Answers2