how to show query while using query annotations with MongoRepository with spring data how to show query while using query annotations with MongoRepository with spring data spring spring

how to show query while using query annotations with MongoRepository with spring data


I add the line (below) in application.properties and works fine:

logging.level.org.springframework.data.mongodb.core.MongoTemplate=DEBUG

for query:

@Query("{$and: [{'$or' : [{ 'name': {$regex : ?0, $options: 'i'}}, {'description': {$regex : ?1, $options: 'i'}}]}, { 'deleted' : ?2 }]}")

obtain this log:

2016-09-27 10:53:26.245 DEBUG 13604 --- [nio-9090-exec-3] o.s.data.mongodb.core.MongoTemplate      : find using query: { "$and" : [ { "$or" : [ { "name" : { "$regex" : "c" , "$options" : "i"}} , { "description" : { "$regex" : "c" , "$options" : "i"}}]} , { "deleted" : false}]} fields: null for class: class com.habber.domain.Entity in collection: entities


Also, you can use a yml config file, put it in your application.yml file.

logging:  level:    org.springframework.data.mongodb.core.MongoTemplate: DEBUG


For ReactiveMongo add this property to your .properties file

logging.level.org.springframework.data.mongodb.core.ReactiveMongoTemplate=DEBUG