Uploaded image for project: 'C# Driver'
  1. C# Driver
  2. CSHARP-4858

Provide a way to test if a field exists or is missing in a LINQ query

    • Type: Icon: New Feature New Feature
    • Resolution: Done
    • Priority: Icon: Unknown Unknown
    • 2.24.0
    • Affects Version/s: 2.22.0
    • Component/s: LINQ3
    • Labels:
      None
    • Fully Compatible
    • Needed
    • 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?

      Document Mql Exists, IsMissing and IsNullOrMissing methods.

      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? Document Mql Exists, IsMissing and IsNullOrMissing methods.

      Possible API is:

      Mql.Exists(<field expression>) 
      // and 
      Mql.IsMissing(<field expression>)
      // and
      Mql.IsNullOrMissing(<field expression>)
       

      Possible translations are:

      { $ne : [{ $type : "$field" }, "missing"] }
      // and
      { $eq : [{ $type : "$field" }, "missing"] }
      // and
      { $in : [{ $type : "$field" }, ["null", "missing"]] }
      

            Assignee:
            robert@mongodb.com Robert Stam
            Reporter:
            robert@mongodb.com Robert Stam
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: