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

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Done
    • Priority: Unknown
    • 2.24.0
    • Affects Version/s: 2.22.0
    • Component/s: LINQ3
    • None
    • 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.
    • None
    • None
    • None
    • None
    • None
    • None

      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 Stam
              Reporter:
              Robert Stam
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: