I want to create a operational data store in mongo database. The source data is available in oracle database.The problem is while migration there are chances, where the data in source db may get updated. How can i reconcile between…
I am updating a finance application built on node.js, mongodb and ```mongoose`` and I am currently facing a challenge with the logic to process fund withdrawals from the system. The problem is that a user can request an amount greater…
i am build nextjs project and creating table from material ui and fetching data from mongoDB. how to manipulate the data from the table. i want # columns auto increment start from 1,2,3,4,5 etc. every row. and this is my…
I have the following function in my database layer: public async findByFilter(filter: Partial<InterfaceMongooseModel>): Promise<InterfaceMongooseModel> { return MongooseModel.findOne(filter); } This works for most cases. However, if I have the following filter: { property: value, createdDate: { $gte: oneDayAgo }, } I…
I really don't understand how to improve the performance of my query using index. db.Vendite.aggregate([{$group: { _id: { anno: "$anno", mese: "$mese", cod_age: "$cod_age", cod_int: "$cod_int", cod_cli: "$cod_cli", cod_linea_comm: "$cod_linea_comm", cod_sett_comm: "$cod_sett_comm", _art: "$cod_art"}, vendite_quantita: { $sum: { $add: […
While working on a MERN project, i am stuck on a problem while i try to get data from the register page from the form, the Axios is giving error. I am trying to send data to the database but…
Somehow, there is a document without an _id in my database. It can be pulled, but cannot be saved or deleted. The document looks something like the following: { name: 'John Smith', key: 'abc123', data: [ 'Lorem ipsum', 'dolor sic…
I have a collection which stores information about sirens - notifications. I need to get summarized user statistic by (long) userid: A count of owned sirens; A count of subscriptions; A count of sirens that the user is responsible for…
Here is a snapshot of my code. exports.getTestCases = async (bucketName, startTimeStamp, endTimeStamp) => { let results = []; let startTime = parseInt(startTimeStamp); let endTime = parseInt(endTimeStamp); const maxDataLimit = 1500; const maxYearsBack = 10; const oneYearInMilliseconds = 31536000000; let…
I have mongodb version 3.6 on server. And my server sources are in nodeJS I have some documents like this: {"title": "test1", sort: 1, parent: 1}, {"title": "test2", sort: 7, parent: 1}, {"title": "test3", sort: 5, parent: 1}, {"title": "test4",…