What is the best way to query for a mongoose ObjectId within feathers?

Question

What is the best way to query for a mongoose ObjectId within feathers?

With two feathers services at hand, one for handling profiles and another for labels, the possibilities are endless.

In a profile, you can have an array of ObjectId labels from other collections. Imagine the depth of connections!

Now, picture this scenario: a user enters "linux" in the search input field.

The profile named foo should be retrieved because it contains the ID "594ceeff6905e622425f523b" in its labels array.

Is this kind of search query, involving ObjectIDs between objects, feasible using Feathers?

Profiles

Mongoose model

{
    name: { type: String, trim: true, required: true },
    labels: [{ type: ObjectId, ref: 'Labels' }],
}

Feathers API response for profiles

Accessible via: http://localhost:3030/profiles

{
    "name": "foo",
    "labels": [
        "594ceeff6905e622425f523b",
        "594ceeff6905e622425f523c",
        "594ceeff6905e622425f523d"
    ],
}

{
    "name": "bar",
    "labels": [
        "594ceeff6905e622425f523e",
        "594ceeff6905e622425f523d"
    ],
}

Labels

Mongoose model

{
    name: { type: String, trim: true, unique: true, required: true },
}

Feathers API response for labels

Accessed through: http://localhost:3030/labels

{
    "_id": "594ceeff6905e622425f523b",
    "name": "linux"
},
{
    "_id": "594ceeff6905e622425f523c",
    "name": "systemd"
},
{
    "_id": "594ceeff6905e622425f523d",
    "name": "mongodb"
},
{
    "_id": "594ceeff6905e622425f523e",
    "name": "javascript"
}

But as the list of labels grows, populating all labels into the profiles response, sending them all to filter on the frontend based on the search value might not be the most efficient approach.

There must be a better way to handle this as the database expands. Any ideas?

javascript mongodb mongoose feathersjs

Answer 1

Answer №1

If you want to implement a search functionality, you can use code similar to the following:

Profile.find({}).populate({
    path: 'labels',
    match: {
        name: { 
            $regex: new RegExp(searchText, 'i'); 
            //searchText is passed from the front end.
        }
    } 
}).then(function(profiles){
  var filteredProfiles = profiles.forEach(function(profile){
    return profile.labels; //will be null for items that don't match the searching regex.
    //resolve the filtered profiles to the front end.
  })
},function(error){
  //Handle any errors here
})

Answer 2

If you want to implement a search functionality, you can use code similar to the following:

Profile.find({}).populate({
    path: 'labels',
    match: {
        name: { 
            $regex: new RegExp(searchText, 'i'); 
            //searchText is passed from the front end.
        }
    } 
}).then(function(profiles){
  var filteredProfiles = profiles.forEach(function(profile){
    return profile.labels; //will be null for items that don't match the searching regex.
    //resolve the filtered profiles to the front end.
  })
},function(error){
  //Handle any errors here
})

Answer 3

Answer №2

Feathers allows you to utilize all the features of Mongoose itself, and if you have specific requirements, you can make use of the Mongoose query population functionality.

The feathers-mongoose adapter facilitates this by supporting the $populate query parameter for querying purposes.

http://localhost:3030/labels?$populate=labels

This should meet your requirements effectively.

Answer 4

Feathers allows you to utilize all the features of Mongoose itself, and if you have specific requirements, you can make use of the Mongoose query population functionality.

The feathers-mongoose adapter facilitates this by supporting the $populate query parameter for querying purposes.

http://localhost:3030/labels?$populate=labels

This should meet your requirements effectively.

Answer 5

Answer №3

In the conclusion, I simplified the process by making just two calls to the API:

computed: {
    ...mapState('profiles', { profiles: 'keyedById' }),
    ...mapState('labels', { labels: 'keyedById' }),
},

methods: {
    ...mapActions('profiles', { findProfiles: 'find' }),

    async fetchData() {
        const labels = this.labels;
        const searchTerm = this.search_input.toLowerCase();

        // Create an array of matched labels per profile
        const labelIds = Object.keys(labels).filter(label => {
            const name = labels[label].name.toLowerCase();
            return name.includes(searchTerm);
        });

        // Search for profiles based on name or labels
        this.findProfiles({
            query: {
                $or: [
                    {
                        name: { $regex: searchTerm, $options: 'igm' },
                    },
                    { labels: { $in: labelIds } },
                ],
                $populate: ['user'],
                $sort: { updatedAt: -1 },
            },
        });
    },
},

Answer 6

In the conclusion, I simplified the process by making just two calls to the API:

computed: {
    ...mapState('profiles', { profiles: 'keyedById' }),
    ...mapState('labels', { labels: 'keyedById' }),
},

methods: {
    ...mapActions('profiles', { findProfiles: 'find' }),

    async fetchData() {
        const labels = this.labels;
        const searchTerm = this.search_input.toLowerCase();

        // Create an array of matched labels per profile
        const labelIds = Object.keys(labels).filter(label => {
            const name = labels[label].name.toLowerCase();
            return name.includes(searchTerm);
        });

        // Search for profiles based on name or labels
        this.findProfiles({
            query: {
                $or: [
                    {
                        name: { $regex: searchTerm, $options: 'igm' },
                    },
                    { labels: { $in: labelIds } },
                ],
                $populate: ['user'],
                $sort: { updatedAt: -1 },
            },
        });
    },
},

What is the best way to query for a mongoose ObjectId within feathers?

Profiles

Mongoose model

Feathers API response for profiles

Labels

Mongoose model

Feathers API response for labels

Answer №1

Answer №2

Answer №3

Similar questions

Customizing Electron Protocol with oAuth redirection

An illustration of the fundamental concepts of require.js

Retrieving HTML file from server directory within extjs HTML editor

What are some ways to make session variables available for sub applications?

What is the method for adding <option> tags to a <select> statement using a for loop?

Issue with Material UI tool tip not closing upon clicking on an element is persistent

Methods for transferring data to controller in Angular Modal service

Enhance the functionality of a form by dynamically adding or deleting input rows using

`Inability to remove item from array in Vue.js`

Pass the initial value from a parent component to a child component in ReactJS without the need for state management

"Encountering issue with componentDidMount() not functioning as expected, despite debugger being

Enhancing the aesthetic appeal of a form

Querying for a referenced item using Mongoose

Updating the columns in a row by clicking the refresh button with ajax in a JSP file

Utilizing React Native for seamless deep linking with automatic fallback to a webpage, including the ability to pass

Is it possible to only make the text in a Bootstrap button act like a link, instead of the whole button itself?

When a HTML table is generated from imported XML, DataTables will be applied

Exploring the combination of Holder.js and Rails routes

What is the best way to use ajax for uploading multiple images at once?

Using Ajax to transmit a model from a list traversed by a foreach loop to a controller