Mongodb nested documents count how to realize the record of the latest date of each classification or the maximum value of a field in the array. - Codes Helper - Programming Question Answer

Mongodb nested documents count how to realize the record of the latest date of each classification or the maximum value of a field in the array.

problem description

there are the following collection,. I need to group statistics according to the name quote.sign field, fetch the latest record according to the last_updated time, or extract the data in the existing format according to the maximum value of quote.price in the whole table.

{
    "_id" : ObjectId("5bfd20dc8e01a44a64c9a455"),
    "name" : "test",
    "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
    "quote" : [ 
        {
            "price" : 0.00362,
            "volume" : 172.952,
            "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
            "sign" : "CNY"
        }, 
        {
            "price" : 0.0000346,
            "volume" : 1.6559,
            "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
            "sign" : "USD"
        }, 
        {
            "price" : 0.00369,
            "volume" : 176.591,
            "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
            "sign" : "USDT"
        }
    ]
},
{
    "_id" : ObjectId("5bfd20dc8e01a44a64c9a455"),
    "name" : "test1",
    "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
    "quote" : [ 
        {
            "price" : 0.00362,
            "volume" : 172.952,
            "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
            "sign" : "CNY"
        }, 
        {
            "price" : 0.0000346,
            "volume" : 1.6559,
            "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
            "sign" : "USD"
        }, 
        {
            "price" : 0.00369,
            "volume" : 176.591,
            "last_updated" : ISODate("2018-11-27T10:47:03.000Z"),
            "sign" : "USDT"
        }
    ]
}

Dec.20,2021

Previous: Jenkins blueocean multiple General SCM??

Next: Js project var a = require ('.. / hello'); require is not defined is reported if you write like this

How to use mongodb for ifelse Operation in spring boot
data stores a field type (as an enumeration). When querying, it needs to be processed separately by using ifelse or switch, for example, 1 is converted to normal. I ve implemented it with the MongoDB statement, but how do I handle it in the springboot ...

Java mongodb spring

Feb.28,2021
The problem of multithreading accessing mongodb
in java, mongodb is operated by multiple threads. uses mongoTemplate as an operation. then, there are more than five hundred threads to operate on the mongodb. then, it was found that none of the 500-plus threads had to create a new mongodb connection...

Java mongodb3.x

Mar.13,2021
Mongodb queried the collection of latitude and longitude coordinates within the region, and found that some of the coordinates of the query results were outside the region.
I queried a collection of coordinates within a region and found that when the range was particularly large (> 300km), I looked up some coordinates outside the range. Is this because the radius error is too large, or is there something wrong with the co...

Java mongodb spring

Mar.16,2021
Implementation of java Code for embedded Array query in mongodb
I use the following code on Robo 3T (a mongodbGUI software) db.getCollection( json ).find({"time":{$gte:1528771648859,$lte:1528771698869}},{"data":{$elemMatch :{"deviceid":456789123}}}) can get the results I want, but I...

Windows intellij-idea java mongodb

Mar.20,2021
Dubbo reported to message can not send, because channel is closed
2018-07-05 16 virtual 17 dispatcherServlet 02.005 ERROR 28380-[nio-9002-exec-4] o.a.c.c.C. [ ]. [dispatcherServlet]: Servlet.service () for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested excepti...

Java mongodb dubbo

Mar.23,2021
How does mongodb combine several collections to query together
there are two tables in the database with different names and the same data format. if I want to check the data in both tables that meet the criteria at the same time, except that I check them separately and return a collection. Is there any other way...

Java mongodb

Mar.23,2021
Spring-data-mongodb uses MongoTemplate to realize paging query and error report
1 you can output query information during unit test, use swagger2 to test the following errors, debug can also output results normally. ...

Java mongodb

Mar.24,2021
Using Java to manipulate mongoDB how to manipulate document embedded collection paging using the aggregate function Aggregate,?
{ "_id" : { "$oid" : "5b8e1d485d30a6499820cfc5" }, "id" : 5, "lessonCount" : 5, "userCount" : 6, "users" : [{ "phone" : "1301111000", &q...

Java mongodb

May.27,2021
Java implements nested query of mongodb data, preferably using springdata mongodb
there are two record: entries as follows query condition is type=gz--> detai is a List, there is an obj, query condition in this obj, and this filed is a List, depending on whether the value in it conforms to . query the entire document of all type ...

Spring-data-mongo springboot spring java mongodb

Sep.30,2021
How to correctly design the library table of monogo
there is a function that often needs to query data according to the factory id. Which of the following designs is more reasonable? or is the efficiency the same? scenario 1: { { "_id" : 1, "product" : "...

Python php java mongodb

Nov.19,2021
Mongodb template query data
mongodb template query data is the time difference of field 1 minus field 2 by more than 30 minutes, and it is data within three days. Fields 1 and 2 are timestamps, how to write ...

Java mongodb

Nov.23,2021
Java implements mongodb multi-condition query. It is best to take the request parameters dynamically.
query conditions are composed of String and List, such as: (List < String > id, String location, String status,.) The exact number of fields in the parameter is not certain. There may be more than one . how to implement this situation? you d better ...

Java mongodb mongoose spring-data-jpa springboot

Dec.01,2021

Menu