Questions tagged [mongodb-atlas-search]

MongoDB Atlas Search is a cloud product based on Apache Lucene which allows relevance based search for MongoDB Atlas users.

131 questions
0
votes
1 answer

MongoDB Atlas Search Stage for newsfeed with GoogleRating, CurrentDate, LikeCount & CommentCount

I'm working on social media platform and I need to fetch posts for newsfeed with mongodb search query. currently I'm using dynamic index on my post collection, Let say this my post collection { _id : ObjectId('123'), GoogleRating : 4.5, LikeCount…
0
votes
0 answers

Mongo atlas search on two fields in documents by a search string and get the list of matching documents grouped by its fields

eg. Need to search on two fields - "name" and "text" for a string "Mercedes" in the given documents {"_id":{"$oid":"5a9427648b0beebeb69579e7"},"name":"Mercedes Tyler","text":"Mercedes…
dman
  • 1
  • 1
0
votes
1 answer

$search mustNot using synonyms

I have an Atlas Search index that covers multiple fields and also uses a couple synonyms. I am getting an error when I try to use synonyms in the mustNot. Is this error telling me I am not able to use synonyms in the mustNot part of the compound?…
eurodollars
  • 47
  • 1
  • 8
0
votes
1 answer

How to use Atlas search on multiple collections

I have two collections, that are store on Atlas. I want to be able to search for a text, using the regex operator of Mongo Atlas Search on these two collections, but with only one aggregation. These two collections have nothing in common, so I can't…
0
votes
1 answer

atlas search: How to index UUID field and query by UUID

I have mapped UUID column(_id is UUID in mongo) to string and set the anylyzer to keyword like this in atlas search index mapping "_id": { "analyzer": "lucene.keyword", "type": "string" }, and when I am…
Sameer
  • 3,124
  • 5
  • 30
  • 57
0
votes
1 answer

MongoDB Atlas Search index on normalized/indexed model

I'd like to use the fresh Atlas search index feature to perform search through my models. It seems to me that the data model that I used can't be coupled with this mongo feature. It seems to work really fine on embedded models, but for consistency…
Axiome
  • 695
  • 5
  • 18
0
votes
3 answers

How to search for multiple ObjectIds using MongoDB Atlas Search

I have documents in a MongoDB collection that reference ObjectIds in a different collection. For example, my Orders collection has documents with a CustomerId. Using MongoDB Atlas search, I've defined an index that allows me to search the CustomerId…
dthrasher
  • 40,656
  • 34
  • 113
  • 139
0
votes
1 answer

MongoDB, which tier has more than three indexes for atlas search?

my application needs about 10 indexes in atlas search, but the default/free tier only allows me to create three. It says: Indexes Used: 3 of 3. You have reached the index limit for your cluster tier. Now the question is, which tier I should choose,…
juliushuck
  • 1,398
  • 1
  • 11
  • 25
0
votes
1 answer

Search query through all collections in mongodb

I'm using mongodb Realm functions and want to run this query for all my collections in the database. I have to write a collection name; otherwise, I get this error: '(AtlasError) Pipeline can only have no collection if the first stage is…
0
votes
1 answer

MongoDB get total count aggregation pipeline with $search

I have to implement search using search indexes in MongoDB Atlas as well as normal browse feature. This includes filtering, match, sort, skip, limit (pagination). I have made an aggregation pipeline to achieve all this. First I push the search query…
0
votes
2 answers

Date range in mongodb atlas search using queryString is not working

I tried this but with no success (I got an empty result): { queryString: { defaultPath: 'anyfield', query: 'createdAt:["2000-01-30T20:19:53.123Z" TO *]' } } I tried with no quotes too. And I tried the range operator directly and…
0
votes
0 answers

Search in mongodb for text and integer

I have a app which will need to perform search for both string and integer type. I tried analysing and got the solution to use full text search feature for mongodb( atlas) which is working fine, but i need to do a integer search also for the same in…
0
votes
1 answer

MongoDB Atlas multiple range search

Is there a way to search multiple ranges for collections in mongo database?. I have tried the following but doesn't work although it works for a single range db.collection(collection) .aggregate([ { $search: { compound: { …
0
votes
0 answers

How to get total count of query result on large dataset?

I've a collection of 10 million docs on which I ran queries with $search from atlas-search, I want to display the total count of the result but it takes to much time to return the result. I've tried this :- { '$search': { // index: 'default', …
0
votes
2 answers

Aggregate Pipeline Atlas Search Stage using C#

I need to make this query using C#: { $search:{ { range:{ path:"canvasAi.publication_date", gte:ISODate("2021-04-01T00:00:00Z"), lte:ISODate("2021-10-11T19:11:16.1928297Z") } } } } I have this so far: var query = new JObject( …
1 2 3
8 9