I want to make a text search case insensitive with regex query with spring-data mongo . For example in SQL: SELECT * FROM Customers WHERE CustomerName LIKE 'a%'; How can i make this query with spring-data mongo using MongoRepository Query…
I have three classes in my Java project: @Document(collection = "foos") public class Foo { @Id private String id; private String foo_name; private Set<Bar> bars; } @Document(collection = "bazs") public class Baz { @Id private String id; private String baz_name;…
I'm using the query bellow to get max date (field named extractionDate) in a collection called KPI, and since I'm only interested in the field extractionDate: @Override public Mono<DBObject> getLastExtractionDate(MatchOperation matchOperation,ProjectionOperation projectionOperation) { return Mono.from(mongoTemplate.aggregate( newAggregation( matchOperation, projectionOperation, group().max(EXTRACTION_DATE).as("result"), project().andExclude("_id")…
I'm trying to find all the documents with first name starting with Ram or Shyam. I tried the following which actually worked in mongoDb db.collection.find({ $or: [ { name: { $regex: "^Ram" } }, { "name": { "$regex": "^Shyam" }…
I have encountered an issue in the application that I'm working with where in a single transaction I am trying to update a document in one collection, and use the updated value in another document when creating it as I…
I'm a learner and new at mongo. I'm trying to fetch the last records according to particular field. In SQL select * from powerandlevel group by deviceId order by desc limit 1. So in this SQL query based on deviceId…
We are working on a project to get data from mongoDB. We have created repository class as below @Repository public interface CustomerRepository extends MongoRepository<Customer,String>{ List<Customer> customers = findByCustomerId(final String customerId); } We are looking to add skip/offset and limit parameters…
I cannot connect to a mongodb instance running in a local docker container from my spring boot application. When the application tries to connect to the database the error below is thrown: 2022-04-03 22:45:57.243 ERROR 14559 --- [nio-5000-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] :…