Hey, since i’m new using Mongo (python driver) i have a problem using look up in pipeline when i try to join 2 collections by a field it return an empty list although the fields have similar value So after checking i think because the field that i want to join isn’t an ObjectId so how can I make i…

[image] Mohamed_Habib: then grouping by job_id to have the count and the length thank you This is what you get with [image] steevej: _size_OpenIOC = { "$project" : { "_id" : 1 , "count" : 1 , "_size_OpenIOC" : { "$size" : "$ioc" } } } and this is the result on the shared data set: …

Join return an empty array

Working with Data

steevej (Steeve Juneau) November 22, 2021, 7:17pm 9

Your documents cannot be inserted in our installation because the quotes are all wrong. Like

and as already mention please

Updating a collection