spring-data-mongo – optional query parameters?

by

To implement this in Boolean logic I do the following and the conversion to operations that are available in programming languages

:query != null -> field == :query
!(:query != null) || (field == :query)
(:query == null) || (field == :query)

In plain SQL, this is done as 

where (null = :query) or (field = :query)

In MongoDB this is done through the $where

{ $where: '?0 == null || this.field == ?0' }

We can speed this up a little by using Mongo Operations rather than building everything to the function at the expense of some readability. does not work unfortunately.

{ $or : [ { $where: '?0 == null' } , { field : ?0 } ] }

So what you have is

@Query("{ $or : [ { $where: '?0 == null' } , { field : ?0 } ] }")
List<Something> findAll(String query, Pageable pageable);

This can be further expanded to handle arrays for in/all clauses

@Query("{ $or : [ { $where: '?0.length == 0' } , { field : { $in : ?0 } } ] }")
List<Something> findAll(String query, Pageable pageable);

More Related Contents:

  1. What’s the difference between Spring Data’s MongoTemplate and MongoRepository?
  2. Making spring-data-mongodb multi-tenant
  3. How to do a Mongo aggregation query in Spring Data?
  4. How To Configure MongoDb Collection Name For a Class in Spring Data
  5. Spring data mongodb – The ‘cursor’ option is required
  6. MongoDB $aggregate $push multiple fields in Java Spring Data
  7. Dynamic spring data jpa repository query with arbitrary AND clauses
  8. How are Spring Data repositories actually implemented?
  9. What is this spring.jpa.open-in-view=true property in Spring Boot?
  10. setMaxResults for Spring-Data-JPA annotation?
  11. ‘Field required a bean of type that could not be found.’ error spring restful API using mongodb
  12. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  13. Handling soft-deletes with Spring JPA
  14. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  15. Implementing custom methods of Spring Data repository and exposing them through REST
  16. Spring-Data FETCH JOIN with Paging is not working
  17. Java SE + Spring Data + Hibernate
  18. Why use returned instance after save() on Spring Data JPA Repository?
  19. How to use @Transactional with Spring Data?
  20. How do I properly do a background thread when using Spring Data and Hibernate?
  21. Spring Data JPA: query ManyToMany
  22. Set MongoDb converter programmatically
  23. How to store @Query sql in external file for CrudRepository?
  24. Missing CrudRepository#findOne method
  25. How to disable spring-data-mongodb autoconfiguration in spring-boot
  26. Best way of handling entities inheritance in Spring Data JPA
  27. com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces
  28. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  29. Spring Data JPA – Is it possible to sort on a calculated property?
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment