Searching Meteor Collections by the IDs obtained from a different collection

Question

Searching Meteor Collections by the IDs obtained from a different collection

I am currently managing 2 collections.

ItemList = new Mongo.Collection('items');
BorrowerDetails = new Mongo.Collection('borrow');

ItemList.insert({
    brand: "brand-Name",
    type: "brand-Type",
    ._id: id
});

BorrowerDetails.insert({
    key: "ItemList.id", //equals to .id of the ItemList Collection
    name : "borrowerName"
});

Here's my question:
I want to know how I can retrieve records from the BorrowerDetails Collection based on a specific type from the ItemList Collection.

For example, fetching all records from the BorrowerDetails Collection where the key is equal to the id of a record in the ItemList Collection with a type of "Desktop".

return BorrowerDetails.find(
    { key : 
        ItemList.find(
            { type : 'Desktop' },
            { fields: {'_id':1 } }
        )
    }
); //error!

javascript mongodb meteor

Answer 1

Answer №1

Please note that currently nodejs is not installed on my laptop, therefore there may be errors in the following code as I am unable to test it.

Firstly, create a publication file (e.g. server\publications\borrowPub.js). Within this file, you will need to define a publication method. The concept here is straightforward - retrieve the itemid array first and then use it as a parameter in Mongo select $in.

Meteor.publish('queryBorrowerTypeDesktop', function(criteria)
{

   var itemArr = ItemList.find( { type : 'Desktop' },
                             { fields: {'_id':1 } });
   if(itemArr){
    //itemArr found, so do a select in using the array of item  id we retrieved earlier
    var borrowers = BorrowerDetails.find({ key: { $in: itemArr } });
    return borrowers;
   }else{
     //found nothing- so return nothing
     return [] 
   }
});

Secondly, in the router:

Router.route('/test', {
  name: 'test',
 action: function()
 {
   //change accordingly.
 },
 waitOn: function()
 {//subscribe from publisher that we just created...
  return [
    Meteor.subscribe('queryBorrowerTypeDesktop') 
  ];
 },
 data: function() {
 if(Meteor.userId())
 {
     // also include the sorting and limit so your page will not crash. change accordingly. 
     return {
       borrowerDetails: BorrowerDetails.find({},{sort: {name: -1},        limit: 30}),
  }
  }
 }
});

Keep in mind that in the data section, BorrowerDetails.find() does not require filtering because it has already been filtered during the subscribe process and cached in MiniMongo within your browser.

Answer 2

Please note that currently nodejs is not installed on my laptop, therefore there may be errors in the following code as I am unable to test it.

Firstly, create a publication file (e.g. server\publications\borrowPub.js). Within this file, you will need to define a publication method. The concept here is straightforward - retrieve the itemid array first and then use it as a parameter in Mongo select $in.

Meteor.publish('queryBorrowerTypeDesktop', function(criteria)
{

   var itemArr = ItemList.find( { type : 'Desktop' },
                             { fields: {'_id':1 } });
   if(itemArr){
    //itemArr found, so do a select in using the array of item  id we retrieved earlier
    var borrowers = BorrowerDetails.find({ key: { $in: itemArr } });
    return borrowers;
   }else{
     //found nothing- so return nothing
     return [] 
   }
});

Secondly, in the router:

Router.route('/test', {
  name: 'test',
 action: function()
 {
   //change accordingly.
 },
 waitOn: function()
 {//subscribe from publisher that we just created...
  return [
    Meteor.subscribe('queryBorrowerTypeDesktop') 
  ];
 },
 data: function() {
 if(Meteor.userId())
 {
     // also include the sorting and limit so your page will not crash. change accordingly. 
     return {
       borrowerDetails: BorrowerDetails.find({},{sort: {name: -1},        limit: 30}),
  }
  }
 }
});

Keep in mind that in the data section, BorrowerDetails.find() does not require filtering because it has already been filtered during the subscribe process and cached in MiniMongo within your browser.

Searching Meteor Collections by the IDs obtained from a different collection

Answer №1

Similar questions

Parameters for both index and value must be included when passing a function to the .attr() method

How to automatically disable a button in reactjs when the input field is blank

What exactly happens behind the scenes when utilizing the React hook useEffect()? Is an effect set up with useEffect able to halt the main thread

The production server is unable to successfully complete the npm run build command

Node-inspector actively searching for the specified <module>.js upon execution of the 'require' function

Utilizing jQuery to submit the form

What is the best way to replace a double quotation mark within a string that is already enclosed in double quotation marks using JavaScript

Simply input the data into the fields of the weekly tds

Tips on destructuring an object property from a Pinia getter that may return an object based on a condition

Customized Grafana dashboard with scripted elements

Is it feasible in Angular2 to add CSS to a component using a service?

Prevent duplicate entries in a JavaScript key-value data structure

What is the process of changing a number to the double data type in JavaScript or TypeScript?

What is the best way to merge and nest connected JSON elements?

You are currently logged in as 'not specified'

Deleting query strings from the URL - HashRouter

How to use image blob in Angular JS?

Exploring the Power of D3.js: Loading and Visualizing Multiple Networks using JSON Files and the Force

Measuring the pixel distance of scrolling on a page with overflow hidden

Shattered raw emotion