MongoDB wildcard in the key of a query

by

As asked, this is not possible. The server issue you linked to is still under “issues we’re not sure of”.

MongoDB has some intelligence surrounding the use of arrays, and I think that’s part of the complexity surrounding such a feature.

Take the following query db.foo.find({ 'a.b' : 4 } ). This query will match the following documents.

{ a: { b: 4 } }
{ a: [ { b: 4 } ] }

So what does “wildcard” do here? db.foo.find( { a.* : 4 } ) Does it match the first document? What about the second?

Moreover, what does this mean semantically? As you’ve described, the query is effectively “find documents where any field in that document has a value of 4”. That’s a little unusual.

Is there a specific semantic that you’re trying to achieve? Maybe a change in the document structure will get you the query you want.

More Related Contents:

  1. Group result by 15 minutes time interval in MongoDb
  2. Random record from MongoDB
  3. Moongoose aggregate $match does not match id’s
  4. Find in Double Nested Array MongoDB
  5. MongoDB: upsert sub-document
  6. How to join multiple collections with $lookup in mongodb
  7. Check if every element in array matches condition
  8. MongoDB nested lookup with 3 levels
  9. How can I get a random record from MongoDB?
  10. Include all existing fields and add new fields to document
  11. Matching ObjectId to String for $graphLookup
  12. mongodb count num of distinct values per field/key
  13. Difference between count() and find().count() in MongoDB
  14. Mongodb aggregation lookup with conditions
  15. How to get back the Original document back after aggregation
  16. MongoDB lookup when foreign field is an array of objects
  17. Get the latest record from mongodb collection
  18. mongoDB prefix wildcard: fulltext-search ($text) find part with search-string
  19. What is a Cursor in MongoDB?
  20. Get n-th element of an array in MongoDB
  21. Pull and addtoset at the same time with mongo
  22. How do I rename fields when performing search/projection in MongoDB?
  23. How does MongoDB order their docs in one collection? [duplicate]
  24. mongodb aggregation framework match by nested documents
  25. Efficient paging in MongoDB using mgo
  26. How to get back the new value after an update in a embedded array?
  27. count array occurrences across all documents with mongo
  28. Mongodb concat int and string
  29. MongoDB $lookup on nested document
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment