How to use Mongodb v3 index search in Parse Server?

[codetycon]

Hi All,

I am using Parse Server with Mlab. I have created a Multikey index from mlab dashboard. Now I wan to use search in Cloud Function of Parse Server, but I didn't found any option in Parse Server to run Query and order by on a specific field.

Anyone have idea how we can perform Search and other MOngo V3 queries in parse server?

Thanks

[mtrezza]

In the docs you can find examples:

// Sorts the results in ascending order by the score field
query.ascending("score");

// Sorts the results in descending order by the score field
query.descending("score");

MongoDB will automatically choose an appropriate index. You can find more infos regarding indexing in the docs.

[codetycon]

In the docs you can find examples:

// Sorts the results in ascending order by the score field
query.ascending("score");

// Sorts the results in descending order by the score field
query.descending("score");

MongoDB will automatically choose an appropriate index. You can find more infos regarding indexing in the docs.

I already implemented this but this searching on only one column , I want to apply search on all columns like firstname, lastname and description and want to order by firstname. I have achieved this by OR query but this query taking long execution time on my 175K records.

ANy solution?

[mtrezza]

I want to apply search on all columns like firstname, lastname and description and want to order by firstname.

let query = new Parse.Query("_User");
query.equalTo("firstname", "John");
query.equalTo("lastname", "Doe");
query.equalTo("description", "example");
query.descending("firstname");

If this is not what you mean, please provide an example data set, your current code, the current multikey index, the expected results and the actual results. You may find it helpful to use the issue template for better overview.

[codetycon]

I don't want an exact match of firstname and lastname I have a class "Artists". In this class I have few fields (firstname, lastname, description). Now I want to search Artist based on the string, Example: User type `paint` ina front end form, this will be search in firstname, lastname and description to see if any entry have "paint" in any of the three column and want to order on a firstname.

…

On Thu, Jul 9, 2020 at 10:26 AM Manuel ***@***.***> wrote: I want to apply search on all columns like firstname, lastname and description and want to order by firstname. let query = new Parse.Query("_User");query.equalTo("firstname", "John");query.equalTo("lastname", "Doe");query.descending("firstname"); If this is not what you mean, please provide an example data set, your current code, the expected results and the actual results. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#6781 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AH2FCRGEAVDLLESKNKLXJG3R2VEYHANCNFSM4OUXNWJQ> .

[mtrezza]

You would have to create a text index manually in the DB:

db.Artists.createIndex({
    firstname: "text",
    lastname: "text",
    description: "text"
})

Then do a text search as described in the docs:

let query = new Parse.Query("Artists");
query.fullText("firstname", "paint");
query.ascending("firstname");
let results = await query.find();

If a text index is a compound index, then the search will automatically cover all fields of the text index. This is expected behavior by MongoDB but not explicitly mentioned in the Parse Server docs.

It makes sense to add this to the docs, a PR would be very welcome.

[codetycon]

Yes I have the custom index, so I just need to write a fulltext query with the first key (firstname) in the compound index, right?

…

On Thu, Jul 9, 2020 at 8:11 PM Manuel ***@***.***> wrote: You would have to create the index manually in the DB: db.Artists.createIndex({ firstname: "text", lastname: "text", description: "text"}) Then do a text search as described in the docs <https://docs.parseplatform.org/js/guide/#queries-on-string-values>: let query = new Parse.Query("Artists");query.fullText("firstname", "paint");query.ascending("firstname");let results = await query.find(); If a text index is a compound index, then the search will automatically cover all fields of the text index. This is expected behavior by MongoDB but not explicitly mentioned in the Parse Server docs. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#6781 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AH2FCRD3CBCTFNM7PPITLXLR2XJKTANCNFSM4OUXNWJQ> .

[codetycon]

You would have to create a text index manually in the DB:

db.Artists.createIndex({
    firstname: "text",
    lastname: "text",
    description: "text"
})

Then do a text search as described in the docs:

let query = new Parse.Query("Artists");
query.fullText("firstname", "paint");
query.ascending("firstname");
let results = await query.find();

If a text index is a compound index, then the search will automatically cover all fields of the text index. This is expected behavior by MongoDB but not explicitly mentioned in the Parse Server docs.

It makes sense to add this to the docs, a PR would be very welcome.

I have applied this but the search does not returning all the match result in a sorting (firstname ascending) and also lot of search saying no records but we have an search string in the description field.

[mtrezza]

You can try to execute the query directly against MongoDB without using Parse and see if you get the expected results. If you also don't get the expected results from a direct query, then you may look at the data and index and maybe consult the MongoDB docs on how to get your expected results.

If you get the correct results from MongoDB but not from Parse, then we need to look at the details:

• Parse query code
• records in DB
• index in DB
• expected results
• actual results
• Parse Server log entries
• MongoDB log entries (executed query)

[codetycon]

It seems to be working, I think indexing was under processing..

[mtrezza]

Great, would you want to create a PR for the docs and add an example for compound text index? That could certainly help others.

[codetycon]

Yes, that would be a great to have an detailed documentation, MongoDb have an well described documentation but this is missing in the Parse.