Support Left Outer Joins

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: LINQ
    • None
    • None
    • Hide

      1. What would you like to communicate to the user about this feature?
      2. Would you like the user to see examples of the syntax and/or executable code and its output?
      3. Which versions of the driver/connector does this apply to?

      Show
      1. What would you like to communicate to the user about this feature? 2. Would you like the user to see examples of the syntax and/or executable code and its output? 3. Which versions of the driver/connector does this apply to?
    • None
    • None
    • None
    • None
    • None
    • None

      example:

          var query = from p in Db.GetCompanyCollection<AwardProviderProduct>(companyIdentifier).AsQueryable()
                join o in Db.GetGlobalCollection<Product>() on p.Sku equals o.Sku
                where p.Reference[ProductReferenceType.AwardchoiceSource.ToString()] == "NORC"
                select new AwardProviderProduct()
                {
                  
                    Sku = p.Sku,
                  
                };

      creates

      
db['terryberry-AwardProviderProduct'].aggregate(
[
{ "$lookup" : { "from" : "Product", "localField" : "Sku", "foreignField" : "Sku", "as" : "o" } }, 
{ "$unwind" : "$o" },
{ "$project" :
{
     "Sku" : "$Sku"
}
}       
,
{"$match" : { "Reference.AwardchoiceSource" : "NORC" }} ])

      The query does not work because of the seemingly useless unwind statement

      Unknown macro: { "$unwind" }

      ,

            Assignee:
            Robert Stam (Inactive)
            Reporter:
            Dan Cumings
            Votes:
            7 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: