Can you help me with a situation... I Have this Json but I would like to format the field trackingID like "TR000000012345BR". How can I pad a trackingId with letters and zeros on the left and letter on the rigth…
I want to find products that are most popular sort by quantity of amount sold. I have the following data: db={ orders: [ { "_id": "63f37d1ac3dff5dd6d8cd156", "cartItems": [ { "qty": 1, "product": { "_id": "63515ad7d5f84ecbaac38f1e", "code": "1", "name": "Coca-Cola", "pricePerItem":…
Please someone help me! I can't find the solution in documentation or other topics. I'm using mongodb aggregation in Mongoose/Nest.js project to return the document data with some formatting and filtering. I have the structure of the mongo document like…
i've got a table that's kinda like this id account 111111 333-333-2 111111 333-333-1 222222 444-444-1 222222 555-555-1 222222 555-555-2 and i'm trying to aggregate everything up to look like this id account 111111 333-333-1, -2 222222 444-444-1, 555-555-1, -2…
I have a collection of say questions like below - { question: "what's the question?", answer: "some answer", points: 10 }, { question: "what's the question again?", answer: "some answer again", points: 40 }, ... The questions which are answered…
I want to sum of values inside array of objects which have another array of objects. In my case; how can I count 'url' values in all documents inside 'urls' array under 'iocs' array; Mongo playground: open Here is document…
I use PostgreSQL 14 to work on a student_books table which manages books borrowed by students. Each student can have zero or more books borrowed at any point in time. The table look like this (the order of rows doesn't…
I have a collection where I want to find one data based on another object data: const data = [ { _id :0, name:"jane", joined : ISODate("2011-03-02"), likes : 30, dislikes: 9}, { _id :1, name: "joe", joined : ISODate("2012-07-02"),…
I wanted to delete all records except the one with the highest value so I did CREATE TABLE code ( id SERIAL, name VARCHAR(255) NOT NULL , value int NOT NULL ); INSERT INTO code (name,value) VALUES ('name',1); INSERT INTO…
I'm trying to join 2 tables and count the number of entries for unique variables in one of the columns. In this case I'm trying to join 2 tables - patients and trials (patients has a FK to trials) and…