How to use lookup in mongodb-driver
found it
cursor = Mongo.aggregate(:mongo, "sales_dtl", [%{"$lookup" => %{"from" => "target_dtl", "localField" => "Finyr", "foreignField" => "Finyr", "as" => "fFinyr"}}], limit: 1)
cursor |> Enum.to_list
found it
cursor = Mongo.aggregate(:mongo, "sales_dtl", [%{"$lookup" => %{"from" => "target_dtl", "localField" => "Finyr", "foreignField" => "Finyr", "as" => "fFinyr"}}], limit: 1)
cursor |> Enum.to_list