Hello
I´m a collection of document like this:
{
"_id" : ObjectId("62d59f2bd6f3809e6588fda4"),
"ClientNavision" : "51",
"Version" : 18,
"Fields" : [
{
"I18List" : [
{
"I18Code" : "es-ES",
"I18Name" : "Cargo"
},
"I18Code" : "en-US",
"I18Name" : "Occupation"
}
],
"Id" : "1",
"Description" : "Descripcion de Cargo",
"ParentId" : "4",
"Type" : "text",
"Size" : NumberLong("100"),
"Default" : true,
"Order" : 3,
"Members" : null
},
"I18Name" : "Extension"
"Id" : "2",
"Description" : "Descripcion de Extension",
"Order" : 1,
}
],
"Clients" : [
"Active" : true,
"ClientName" : "Giuseppe Pepponi",
"ClientI18" : "es-ES",
"Fields" : [
"Id" : "1",
"Value" : [ "Supervisor" ]
"Id" : "2",
"Value" : [ "234" ]
"Modified" : ISODate("2022-03-24T16:29:28.656+01:00"),
"Created" : ISODate("2021-09-03T12:50:11.000+02:00"),
"ClientFolder" : "",
"ClientPhone" : ""
"Cif" : "f98765422",
"ClientName" : "Puigdémont Indultos S.L.",
"Value" : [ "Jefe" ]
"Value" : [ "123" ]
"Created" : ISODate("2021-09-09T19:01:31.758+02:00"),
"Modified" : ISODate("2021-09-09T19:01:31.758+02:00"),
]
}
I need recover the collection of Fields into the Clients.Fields collection by the Field.Id and recover the especific value selected by the clients (clients.Fields.Value)
I tried with graphlookup, but i´m not find the correct solution
This is and example of the desired result:
// collection: Customers
{
"_id" : ObjectId("62d59f2bd6f3809e6588fda4"),
"ClientNavision" : "51",
"Version" : 18,
"Clients" : [
{
"Id" : "1",
"Active" : true,
"ClientName" : "Giuseppe Pepponi",
"ClientI18" : "es-ES",
"Fields" : [
{
"I18List" : [
{
"I18Code" : "es-ES",
"I18Name" : "Cargo"
},
"I18Code" : "en-US",
"I18Name" : "Occupation"
}
],
"Id" : "1",
"Description" : "Descripcion de Cargo",
"ParentId" : "4",
"Type" : "text",
"Size" : NumberLong("100"),
"Default" : true,
"Order" : 3,
"Members" : null,
"Value" : [ "Supervisor" ]
},
"Id" : "2",
"Value" : [ "234" ],
"I18Name" : "Extension"
"Description" : "Descripcion de Extension",
"Order" : 1,
"Members" : null
}
],
"Modified" : ISODate("2022-03-24T16:29:28.656+01:00"),
"Created" : ISODate("2021-09-03T12:50:11.000+02:00"),
"ClientFolder" : "",
"ClientPhone" : ""
},
"Id" : "2",
"Cif" : "f98765422",
"ClientName" : "Puigdémont Indultos S.L.",
"Value" : [ "Jefe" ],
"Value" : [ "123" ],
"Created" : ISODate("2021-09-09T19:01:31.758+02:00"),
"Modified" : ISODate("2021-09-09T19:01:31.758+02:00"),
}
]
}
thanks in advance