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

    XMLWordPrintableJSON

Details

    • Icon: New Feature New Feature
    • Resolution: Done
    • Icon: Unknown Unknown
    • 2.24.0
    • 2.22.0
    • LINQ3
    • 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.

    Description

      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"]] }
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: