creating a custom query in Springboot mongodb(using crudRepository)

Question

I want to Create custom query which will depend on number of Fields will get from @RequestParam Like

public List<User> method(
  @RequestParam("key") String []key,
  @RequestParam("value") String [] value){}

Then I have to create a query in Service layer according to number of element I'll get in key and value

For example in first array(in key) element is "UserName" then in value array I'll get (value of username)

In these arrays, the number of fields will be dynamic. After that I have to pass that whole query String in Repository of Springboot & retrieve data from mongodb database.

docs.spring.io/spring-data/data-document/docs/current/reference/… — Shiva
– Shiva, Commented Nov 23, 2018 at 7:24
@secretsuperstar i want to genrate the query and want to pass. i don't think that link is helpfull . but thanks sir — RAHUL GUPTA
– RAHUL GUPTA, Commented Nov 23, 2018 at 7:44

aurelius · Accepted Answer · 2018-11-23 09:37:13Z

1

Firstly, I would use a map instead of two arrays to map the request params.

For dynamic queries you have to use query criteria or HQL.

Then based on the map entries I would build the query criteria from JPA.

There is already a lot of material on how to build a criteria.

answered Nov 23, 2018 at 9:37

aurelius

4,1149 gold badges43 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

RAHUL GUPTA Over a year ago

can you tell me example of query criteria for this problem or code snippet with atleaset 2 key value pair ,Because i'm totally new in Mongo & query criteria

RAHUL GUPTA Over a year ago

And i thing JPA is only for Rdbms not for NoSql

aurelius Over a year ago

query criteria and mongo db baeldung.com/queries-in-spring-data-mongodb

aurelius Over a year ago

map as request param is here: stackoverflow.com/questions/47418489/…

RAHUL GUPTA Over a year ago

can anyone tell me logic as in code of this because i'm not able to get the solution of this problem

|

Collectives™ on Stack Overflow

creating a custom query in Springboot mongodb(using crudRepository)

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related