Re: problem updating nested arrays

16 views
Skip to first unread message

Asya Kamsky

unread,
May 26, 2013, 5:51:00 PM5/26/13
to mongod...@googlegroups.com
I don't believe you can do what you want without https://jira.mongodb.org/browse/SERVER-831 being implemented first.

On Friday, May 24, 2013 3:22:36 PM UTC-4, Freddy Martinez wrote:
hi to everybody

i'm new using mongo and I need to know if exist any way to update one array nested into other array which nested into another one.

being more clear, I have this patient collection:

{
    "_id" : ObjectId("519c3c99398dbd9fcabe2042"),
    "(0010,0010)" : {
        "VR" : "PN",
        "VM" : 1,
        "value" : "ADARBE^NELFI"
    },
    "(0010,0020)" : {
        "VR" : "LO",
        "VM" : 1,
        "value" : "22758387"
    },
    "(0010,0030)" : {
        "VR" : "DA",
        "VM" : 1,
        "value" : "19481007"
    },
    "(0010,0040)" : {
        "VR" : "CS",
        "VM" : 1,
        "value" : "F"
    },
    "studies" : [
        {
            "(0008,0020)" : {
                "VR" : "DA",
                "VM" : 1,
                "value" : "20061122"
            },
            "(0008,0030)" : {
                "VR" : "TM",
                "VM" : 1,
                "value" : "144905"
            },
            "(0008,0050)" : {
                "VR" : "SH",
                "VM" : 0
            },
            "(0008,0090)" : {
                "VR" : "PN",
                "VM" : 0
            },
            "(0008,1030)" : {
                "VR" : "LO",
                "VM" : 0
            },
            "(0020,000d)" : {
                "VR" : "UI",
                "VM" : 1,
                "value" : "1.2.840.113663.1500.1.218819862.1.1.20061122.144905.562"
            },
            "(0020,0010)" : {
                "VR" : "SH",
                "VM" : 1,
                "value" : "20061122.144905"
            },
            "series" : [
                {
                    "(0008,0021)" : {
                        "VR" : "DA",
                        "VM" : 1,
                        "value" : "20061122"
                    },
                    "(0008,0031)" : {
                        "VR" : "TM",
                        "VM" : 1,
                        "value" : "144905"
                    },
                    "(0008,0060)" : {
                        "VR" : "CS",
                        "VM" : 1,
                        "value" : "US"
                    },
                    "(0008,0070)" : {
                        "VR" : "LO",
                        "VM" : 1,
                        "value" : "Philips Medical Systems"
                    },
                    "(0008,0080)" : {
                        "VR" : "LO",
                        "VM" : 1,
                        "value" : "CMDAT  Dr. S. ALLENDE"
                    },
                    "(0008,1010)" : {
                        "VR" : "SH",
                        "VM" : 1,
                        "value" : "eco3d"
                    },
                    "(0008,1090)" : {
                        "VR" : "LO",
                        "VM" : 1,
                        "value" : "iE33"
                    },
                    "(0020,000e)" : {
                        "VR" : "UI",
                        "VM" : 1,
                        "value" : "1.2.840.113663.1500.1.218819862.2.1.20061122.144905.562"
                    },
                    "(0020,0011)" : {
                        "VR" : "IS",
                        "VM" : 1,
                        "value" : "1"
                    },
                    "instances" : [
                        {
                            "(0008,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 552
                            },
                            "(0008,0008)" : {
                                "VR" : "CS",
                                "VM" : 3,
                                "value" : [
                                    "ORIGINAL",
                                    "PRIMARY",
                                    "CARDIOLOGY"
                                ]
                            },
                            "(0008,0012)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0013)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145416"
                            },
                            "(0008,0016)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.10008.5.1.4.1.1.6.1"
                            },
                            "(0008,0018)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.113663.1500.1.218819862.3.2.20061122.145416.265"
                            },
                            "(0008,0023)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0033)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145416"
                            },
                            "(0008,1070)" : {
                                "VR" : "PN",
                                "VM" : 1,
                                "value" : "TORNES"
                            },
                            "(0008,2111)" : {
                                "VR" : "ST",
                                "VM" : 1,
                                "value" : "Uncompressed"
                            },
                            "(0010,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 70
                            },
                            "(0010,4000)" : {
                                "VR" : "LT",
                                "VM" : 0
                            },
                            "(0018,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 460
                            },
                            "(0018,1000)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "218819862"
                            },
                            "(0018,1020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "PMS1.1 Ultrasound iE33_2.0.2.428"
                            },
                            "(0018,1030)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "Free Form"
                            },
                            "(0018,1088)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "0"
                            },
                            "(0018,5010)" : {
                                "VR" : "LO",
                                "VM" : 3,
                                "value" : [
                                    "S2",
                                    "",
                                    ""
                                ]
                            },
                            "(0018,5020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "CARD_ADULT_GEN_CV"
                            },
                            "(0020,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 172
                            },
                            "(0020,0013)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "2"
                            },
                            "(0028,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 152
                            },
                            "(0028,0002)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 3
                            },
                            "(0028,0004)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "RGB"
                            },
                            "(0028,0006)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0010)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 768
                            },
                            "(0028,0011)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1024
                            },
                            "(0028,0014)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1
                            },
                            "(0028,0100)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0101)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0102)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 7
                            },
                            "(0028,0103)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0301)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "YES"
                            },
                            "(0028,1050)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "127.0"
                            },
                            "(0028,1051)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "254.0"
                            },
                            "(0028,2110)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "00"
                            },
                            "(0040,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 230
                            },
                            "(0040,0241)" : {
                                "VR" : "AE",
                                "VM" : 1,
                                "value" : "ECO-3D"
                            },
                            "(0040,0242)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "eco3d"
                            },
                            "(0040,0243)" : {
                                "VR" : "SH",
                                "VM" : 0
                            },
                            "(0040,0244)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0245)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "144905"
                            },
                            "(0040,0250)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0251)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150836"
                            },
                            "(0040,0252)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "COMPLETED"
                            },
                            "(0040,0253)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "20061122.144905"
                            },
                            "(2050,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 16
                            },
                            "(2050,0020)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "IDENTITY"
                            },
                            "filename" : "/home/freddy/tmp/move/1.2.840.113663.1500.1.218819862.3.2.20061122.145416.265.dcm"
                        },
                        {
                            "(0008,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 552
                            },
                            "(0008,0008)" : {
                                "VR" : "CS",
                                "VM" : 3,
                                "value" : [
                                    "ORIGINAL",
                                    "PRIMARY",
                                    "CARDIOLOGY"
                                ]
                            },
                            "(0008,0012)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0013)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145716"
                            },
                            "(0008,0016)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.10008.5.1.4.1.1.6.1"
                            },
                            "(0008,0018)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.113663.1500.1.218819862.3.4.20061122.145716.671"
                            },
                            "(0008,0023)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0033)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145716"
                            },
                            "(0008,1070)" : {
                                "VR" : "PN",
                                "VM" : 1,
                                "value" : "TORNES"
                            },
                            "(0008,2111)" : {
                                "VR" : "ST",
                                "VM" : 1,
                                "value" : "Uncompressed"
                            },
                            "(0010,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 70
                            },
                            "(0010,4000)" : {
                                "VR" : "LT",
                                "VM" : 0
                            },
                            "(0018,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 484
                            },
                            "(0018,1000)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "218819862"
                            },
                            "(0018,1020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "PMS1.1 Ultrasound iE33_2.0.2.428"
                            },
                            "(0018,1030)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "Free Form"
                            },
                            "(0018,1088)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "0"
                            },
                            "(0018,5010)" : {
                                "VR" : "LO",
                                "VM" : 3,
                                "value" : [
                                    "S2",
                                    "",
                                    ""
                                ]
                            },
                            "(0018,5020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "CARD_ADULT_GEN_CV"
                            },
                            "(0020,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 172
                            },
                            "(0020,0013)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "4"
                            },
                            "(0028,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 152
                            },
                            "(0028,0002)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 3
                            },
                            "(0028,0004)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "RGB"
                            },
                            "(0028,0006)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0010)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 768
                            },
                            "(0028,0011)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1024
                            },
                            "(0028,0014)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1
                            },
                            "(0028,0100)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0101)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0102)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 7
                            },
                            "(0028,0103)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0301)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "YES"
                            },
                            "(0028,1050)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "127.0"
                            },
                            "(0028,1051)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "254.0"
                            },
                            "(0028,2110)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "00"
                            },
                            "(0040,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 230
                            },
                            "(0040,0241)" : {
                                "VR" : "AE",
                                "VM" : 1,
                                "value" : "ECO-3D"
                            },
                            "(0040,0242)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "eco3d"
                            },
                            "(0040,0243)" : {
                                "VR" : "SH",
                                "VM" : 0
                            },
                            "(0040,0244)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0245)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "144905"
                            },
                            "(0040,0250)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0251)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150836"
                            },
                            "(0040,0252)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "COMPLETED"
                            },
                            "(0040,0253)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "20061122.144905"
                            },
                            "(2050,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 16
                            },
                            "(2050,0020)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "IDENTITY"
                            },
                            "filename" : "/home/freddy/tmp/move/1.2.840.113663.1500.1.218819862.3.4.20061122.145716.671.dcm"
                        },
                        {
                            "(0008,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 552
                            },
                            "(0008,0008)" : {
                                "VR" : "CS",
                                "VM" : 3,
                                "value" : [
                                    "ORIGINAL",
                                    "PRIMARY",
                                    "CARDIOLOGY"
                                ]
                            },
                            "(0008,0012)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0013)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145328"
                            },
                            "(0008,0016)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.10008.5.1.4.1.1.6.1"
                            },
                            "(0008,0018)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.113663.1500.1.218819862.3.1.20061122.145328.703"
                            },
                            "(0008,0023)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0033)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145328"
                            },
                            "(0008,1070)" : {
                                "VR" : "PN",
                                "VM" : 1,
                                "value" : "TORNES"
                            },
                            "(0008,2111)" : {
                                "VR" : "ST",
                                "VM" : 1,
                                "value" : "Uncompressed"
                            },
                            "(0010,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 70
                            },
                            "(0010,4000)" : {
                                "VR" : "LT",
                                "VM" : 0
                            },
                            "(0018,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 460
                            },
                            "(0018,1000)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "218819862"
                            },
                            "(0018,1020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "PMS1.1 Ultrasound iE33_2.0.2.428"
                            },
                            "(0018,1030)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "Free Form"
                            },
                            "(0018,1088)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "0"
                            },
                            "(0018,5010)" : {
                                "VR" : "LO",
                                "VM" : 3,
                                "value" : [
                                    "S2",
                                    "",
                                    ""
                                ]
                            },
                            "(0018,5020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "CARD_ADULT_GEN_CV"
                            },
                            "(0020,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 172
                            },
                            "(0020,0013)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "1"
                            },
                            "(0028,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 152
                            },
                            "(0028,0002)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 3
                            },
                            "(0028,0004)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "RGB"
                            },
                            "(0028,0006)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0010)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 768
                            },
                            "(0028,0011)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1024
                            },
                            "(0028,0014)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1
                            },
                            "(0028,0100)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0101)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0102)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 7
                            },
                            "(0028,0103)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0301)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "YES"
                            },
                            "(0028,1050)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "127.0"
                            },
                            "(0028,1051)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "254.0"
                            },
                            "(0028,2110)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "00"
                            },
                            "(0040,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 230
                            },
                            "(0040,0241)" : {
                                "VR" : "AE",
                                "VM" : 1,
                                "value" : "ECO-3D"
                            },
                            "(0040,0242)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "eco3d"
                            },
                            "(0040,0243)" : {
                                "VR" : "SH",
                                "VM" : 0
                            },
                            "(0040,0244)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0245)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "144905"
                            },
                            "(0040,0250)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0251)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150836"
                            },
                            "(0040,0252)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "COMPLETED"
                            },
                            "(0040,0253)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "20061122.144905"
                            },
                            "(2050,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 16
                            },
                            "(2050,0020)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "IDENTITY"
                            },
                            "filename" : "/home/freddy/tmp/move/1.2.840.113663.1500.1.218819862.3.1.20061122.145328.703.dcm"
                        },
                        {
                            "(0008,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 550
                            },
                            "(0008,0008)" : {
                                "VR" : "CS",
                                "VM" : 3,
                                "value" : [
                                    "ORIGINAL",
                                    "PRIMARY",
                                    "CARDIOLOGY"
                                ]
                            },
                            "(0008,0012)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0013)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145524"
                            },
                            "(0008,0016)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.10008.5.1.4.1.1.6.1"
                            },
                            "(0008,0018)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.113663.1500.1.218819862.3.3.20061122.145524.62"
                            },
                            "(0008,0023)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0033)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "145524"
                            },
                            "(0008,1070)" : {
                                "VR" : "PN",
                                "VM" : 1,
                                "value" : "TORNES"
                            },
                            "(0008,2111)" : {
                                "VR" : "ST",
                                "VM" : 1,
                                "value" : "Uncompressed"
                            },
                            "(0010,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 70
                            },
                            "(0010,4000)" : {
                                "VR" : "LT",
                                "VM" : 0
                            },
                            "(0018,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 484
                            },
                            "(0018,1000)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "218819862"
                            },
                            "(0018,1020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "PMS1.1 Ultrasound iE33_2.0.2.428"
                            },
                            "(0018,1030)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "Free Form"
                            },
                            "(0018,1088)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "0"
                            },
                            "(0018,5010)" : {
                                "VR" : "LO",
                                "VM" : 3,
                                "value" : [
                                    "S2",
                                    "",
                                    ""
                                ]
                            },
                            "(0018,5020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "CARD_ADULT_GEN_CV"
                            },
                            "(0020,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 172
                            },
                            "(0020,0013)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "3"
                            },
                            "(0028,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 152
                            },
                            "(0028,0002)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 3
                            },
                            "(0028,0004)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "RGB"
                            },
                            "(0028,0006)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0010)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 768
                            },
                            "(0028,0011)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1024
                            },
                            "(0028,0014)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1
                            },
                            "(0028,0100)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0101)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0102)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 7
                            },
                            "(0028,0103)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0301)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "YES"
                            },
                            "(0028,1050)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "127.0"
                            },
                            "(0028,1051)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "254.0"
                            },
                            "(0028,2110)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "00"
                            },
                            "(0040,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 230
                            },
                            "(0040,0241)" : {
                                "VR" : "AE",
                                "VM" : 1,
                                "value" : "ECO-3D"
                            },
                            "(0040,0242)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "eco3d"
                            },
                            "(0040,0243)" : {
                                "VR" : "SH",
                                "VM" : 0
                            },
                            "(0040,0244)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0245)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "144905"
                            },
                            "(0040,0250)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0251)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150836"
                            },
                            "(0040,0252)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "COMPLETED"
                            },
                            "(0040,0253)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "20061122.144905"
                            },
                            "(2050,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 16
                            },
                            "(2050,0020)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "IDENTITY"
                            },
                            "filename" : "/home/freddy/tmp/move/1.2.840.113663.1500.1.218819862.3.3.20061122.145524.62.dcm"
                        },
                        {
                            "(0008,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 550
                            },
                            "(0008,0008)" : {
                                "VR" : "CS",
                                "VM" : 3,
                                "value" : [
                                    "ORIGINAL",
                                    "PRIMARY",
                                    "CARDIOLOGY"
                                ]
                            },
                            "(0008,0012)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0013)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150057"
                            },
                            "(0008,0016)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.10008.5.1.4.1.1.6.1"
                            },
                            "(0008,0018)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.113663.1500.1.218819862.3.5.20061122.150057.62"
                            },
                            "(0008,0023)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0033)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150057"
                            },
                            "(0008,1070)" : {
                                "VR" : "PN",
                                "VM" : 1,
                                "value" : "TORNES"
                            },
                            "(0008,2111)" : {
                                "VR" : "ST",
                                "VM" : 1,
                                "value" : "Uncompressed"
                            },
                            "(0010,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 70
                            },
                            "(0010,4000)" : {
                                "VR" : "LT",
                                "VM" : 0
                            },
                            "(0018,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 460
                            },
                            "(0018,1000)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "218819862"
                            },
                            "(0018,1020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "PMS1.1 Ultrasound iE33_2.0.2.428"
                            },
                            "(0018,1030)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "Free Form"
                            },
                            "(0018,1088)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "0"
                            },
                            "(0018,5010)" : {
                                "VR" : "LO",
                                "VM" : 3,
                                "value" : [
                                    "S2",
                                    "",
                                    ""
                                ]
                            },
                            "(0018,5020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "CARD_ADULT_GEN_CV"
                            },
                            "(0020,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 172
                            },
                            "(0020,0013)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "5"
                            },
                            "(0028,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 152
                            },
                            "(0028,0002)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 3
                            },
                            "(0028,0004)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "RGB"
                            },
                            "(0028,0006)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0010)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 768
                            },
                            "(0028,0011)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1024
                            },
                            "(0028,0014)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1
                            },
                            "(0028,0100)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0101)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0102)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 7
                            },
                            "(0028,0103)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0301)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "YES"
                            },
                            "(0028,1050)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "127.0"
                            },
                            "(0028,1051)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "254.0"
                            },
                            "(0028,2110)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "00"
                            },
                            "(0040,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 230
                            },
                            "(0040,0241)" : {
                                "VR" : "AE",
                                "VM" : 1,
                                "value" : "ECO-3D"
                            },
                            "(0040,0242)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "eco3d"
                            },
                            "(0040,0243)" : {
                                "VR" : "SH",
                                "VM" : 0
                            },
                            "(0040,0244)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0245)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "144905"
                            },
                            "(0040,0250)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0251)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150836"
                            },
                            "(0040,0252)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "COMPLETED"
                            },
                            "(0040,0253)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "20061122.144905"
                            },
                            "(2050,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 16
                            },
                            "(2050,0020)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "IDENTITY"
                            },
                            "filename" : "/home/freddy/tmp/move/1.2.840.113663.1500.1.218819862.3.5.20061122.150057.62.dcm"
                        },
                        {
                            "(0008,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 552
                            },
                            "(0008,0008)" : {
                                "VR" : "CS",
                                "VM" : 3,
                                "value" : [
                                    "ORIGINAL",
                                    "PRIMARY",
                                    "CARDIOLOGY"
                                ]
                            },
                            "(0008,0012)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0013)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150247"
                            },
                            "(0008,0016)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.10008.5.1.4.1.1.6.1"
                            },
                            "(0008,0018)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.113663.1500.1.218819862.3.6.20061122.150247.390"
                            },
                            "(0008,0023)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0033)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150247"
                            },
                            "(0008,1070)" : {
                                "VR" : "PN",
                                "VM" : 1,
                                "value" : "TORNES"
                            },
                            "(0008,2111)" : {
                                "VR" : "ST",
                                "VM" : 1,
                                "value" : "Uncompressed"
                            },
                            "(0010,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 70
                            },
                            "(0010,4000)" : {
                                "VR" : "LT",
                                "VM" : 0
                            },
                            "(0018,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 484
                            },
                            "(0018,1000)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "218819862"
                            },
                            "(0018,1020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "PMS1.1 Ultrasound iE33_2.0.2.428"
                            },
                            "(0018,1030)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "Free Form"
                            },
                            "(0018,1088)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "0"
                            },
                            "(0018,5010)" : {
                                "VR" : "LO",
                                "VM" : 3,
                                "value" : [
                                    "S2",
                                    "",
                                    ""
                                ]
                            },
                            "(0018,5020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "CARD_ADULT_GEN_CV"
                            },
                            "(0020,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 172
                            },
                            "(0020,0013)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "6"
                            },
                            "(0028,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 152
                            },
                            "(0028,0002)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 3
                            },
                            "(0028,0004)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "RGB"
                            },
                            "(0028,0006)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0010)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 768
                            },
                            "(0028,0011)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1024
                            },
                            "(0028,0014)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 1
                            },
                            "(0028,0100)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0101)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 8
                            },
                            "(0028,0102)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 7
                            },
                            "(0028,0103)" : {
                                "VR" : "US",
                                "VM" : 1,
                                "value" : 0
                            },
                            "(0028,0301)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "YES"
                            },
                            "(0028,1050)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "127.0"
                            },
                            "(0028,1051)" : {
                                "VR" : "DS",
                                "VM" : 1,
                                "value" : "254.0"
                            },
                            "(0028,2110)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "00"
                            },
                            "(0040,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 230
                            },
                            "(0040,0241)" : {
                                "VR" : "AE",
                                "VM" : 1,
                                "value" : "ECO-3D"
                            },
                            "(0040,0242)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "eco3d"
                            },
                            "(0040,0243)" : {
                                "VR" : "SH",
                                "VM" : 0
                            },
                            "(0040,0244)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0245)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "144905"
                            },
                            "(0040,0250)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0251)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150836"
                            },
                            "(0040,0252)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "COMPLETED"
                            },
                            "(0040,0253)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "20061122.144905"
                            },
                            "(2050,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 16
                            },
                            "(2050,0020)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "IDENTITY"
                            },
                            "filename" : "/home/freddy/tmp/move/1.2.840.113663.1500.1.218819862.3.6.20061122.150247.390.dcm"
                        }
                    ]
                },
                {
                    "(0008,0021)" : {
                        "VR" : "DA",
                        "VM" : 1,
                        "value" : "20061122"
                    },
                    "(0008,0031)" : {
                        "VR" : "TM",
                        "VM" : 1,
                        "value" : "144905"
                    },
                    "(0008,0060)" : {
                        "VR" : "CS",
                        "VM" : 1,
                        "value" : "SR"
                    },
                    "(0008,0070)" : {
                        "VR" : "LO",
                        "VM" : 1,
                        "value" : "Philips Medical Systems"
                    },
                    "(0008,0080)" : {
                        "VR" : "LO",
                        "VM" : 1,
                        "value" : "CMDAT  Dr. S. ALLENDE"
                    },
                    "(0008,1010)" : {
                        "VR" : "SH",
                        "VM" : 1,
                        "value" : "eco3d"
                    },
                    "(0008,1090)" : {
                        "VR" : "LO",
                        "VM" : 1,
                        "value" : "iE33"
                    },
                    "(0020,000e)" : {
                        "VR" : "UI",
                        "VM" : 1,
                        "value" : "1.2.840.113663.1500.1.218819862.7.1.20061122.144905.562"
                    },
                    "(0020,0011)" : {
                        "VR" : "IS",
                        "VM" : 1,
                        "value" : "2"
                    },
                    "instances" : [
                        {
                            "(0008,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 468
                            },
                            "(0008,0016)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.10008.5.1.4.1.1.88.33"
                            },
                            "(0008,0018)" : {
                                "VR" : "UI",
                                "VM" : 1,
                                "value" : "1.2.840.113663.1500.1.218819862.8.3.20061122.150837.906"
                            },
                            "(0008,0023)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0008,0033)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150837"
                            },
                            "(0008,1070)" : {
                                "VR" : "PN",
                                "VM" : 1,
                                "value" : "TORNES"
                            },
                            "(0010,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 70
                            },
                            "(0010,4000)" : {
                                "VR" : "LT",
                                "VM" : 0
                            },
                            "(0018,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 76
                            },
                            "(0018,1000)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "218819862"
                            },
                            "(0018,1020)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "PMS1.1 Ultrasound iE33_2.0.2.428"
                            },
                            "(0018,1030)" : {
                                "VR" : "LO",
                                "VM" : 1,
                                "value" : "Free Form"
                            },
                            "(0020,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 172
                            },
                            "(0020,0013)" : {
                                "VR" : "IS",
                                "VM" : 1,
                                "value" : "3"
                            },
                            "(0040,0000)" : {
                                "VR" : "UL",
                                "VM" : 1,
                                "value" : 40906
                            },
                            "(0040,0241)" : {
                                "VR" : "AE",
                                "VM" : 1,
                                "value" : "ECO-3D"
                            },
                            "(0040,0242)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "eco3d"
                            },
                            "(0040,0243)" : {
                                "VR" : "SH",
                                "VM" : 0
                            },
                            "(0040,0244)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0245)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "144905"
                            },
                            "(0040,0250)" : {
                                "VR" : "DA",
                                "VM" : 1,
                                "value" : "20061122"
                            },
                            "(0040,0251)" : {
                                "VR" : "TM",
                                "VM" : 1,
                                "value" : "150836"
                            },
                            "(0040,0252)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "COMPLETED"
                            },
                            "(0040,0253)" : {
                                "VR" : "SH",
                                "VM" : 1,
                                "value" : "20061122.144905"
                            },
                            "(0040,a040)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "CONTAINER"
                            },
                            "(0040,a050)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "SEPARATE"
                            },
                            "(0040,a491)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "PARTIAL"
                            },
                            "(0040,a493)" : {
                                "VR" : "CS",
                                "VM" : 1,
                                "value" : "UNVERIFIED"
                            },
                            "filename" : "/home/freddy/tmp/move/1.2.840.113663.1500.1.218819862.8.3.20061122.150837.906.dcm"
                        }
                    ]
                }
            ]
        }
    ]
}

how can I execute this king of query????

db.patients.update(
{
    "(0010,0010).value":{$regex:"ada", $options:"i"},
    "studies.(0020,000d).value":{$regex:"1",$options:"i"},
{
    $push : {"studies.$.(0020,000d).series.$.(0020,000e).value": "cambiando dato"}
})

best regards

freddy
Reply all
Reply to author
Forward
0 new messages