无法使用Mongoose找到objective搜索的文档

时间:2022-09-11 19:27:45
  Campaign.find {client_id:req.param('client_id')}, (error, campaigns) ->
    if error
      response =
        error: error.message
    else
      for campaign in campaigns
        query =
          campaign_id: campaign._id
        console.log query
        CampaignResponse.find query, (err, campaignResponsesCount) ->
          console.log campaignResponsesCount

      response = campaigns

    res.json response

For some reason, this returns no results. However, there are items in CampaignResponse with that specific campaign._id. I'm pretty sure this is an issue with types and casting, but I can't figure out what to do.

出于某种原因,这不会返回任何结果。然而,在活动响应中有一些特定的活动。我很确定这是一个类型和类型的问题,但我不知道该怎么做。

Any help?

任何帮助吗?

3 个解决方案

#1


104  

A couple tips:

几个建议:

  • Try running the same query from mongodb at the command line, see if you get any results.
  • 尝试在命令行上从mongodb运行相同的查询,看看是否得到任何结果。
  • Is the "campaign_id" defined as an ObjectId in your schema? If so, try searching using the ObjectId type.
  • “campaign n_id”是否定义为您的模式中的一个objective ?如果有,尝试使用ObjectId类型搜索。

For example:

例如:

var ObjectId = require('mongoose').Types.ObjectId; 
var query = { campaign_id: new ObjectId(campaign._id) };

#2


31  

Just to improve the previous (correct) answer, i use on my projects :

为了改进之前的(正确的)答案,我在我的项目中使用:

String.prototype.toObjectId = function() {
  var ObjectId = (require('mongoose').Types.ObjectId);
  return new ObjectId(this.toString());
};

// Every String can be casted in ObjectId now
console.log('545f489dea12346454ae793b'.toObjectId());

#3


6  

Instead of using ObjectId to find by comparing your parameters simply use Campaign.findById {req.param('client_id'),function(err,docs)}....

不要通过比较参数来使用objective - find,只需使用Campaign。findById { req.param(client_id)、功能(呃,文档)} ....

when finding docs using objectId findById is the most efficient way of all...

使用objectId findById查找文档是最有效的方法。

#1


104  

A couple tips:

几个建议:

  • Try running the same query from mongodb at the command line, see if you get any results.
  • 尝试在命令行上从mongodb运行相同的查询,看看是否得到任何结果。
  • Is the "campaign_id" defined as an ObjectId in your schema? If so, try searching using the ObjectId type.
  • “campaign n_id”是否定义为您的模式中的一个objective ?如果有,尝试使用ObjectId类型搜索。

For example:

例如:

var ObjectId = require('mongoose').Types.ObjectId; 
var query = { campaign_id: new ObjectId(campaign._id) };

#2


31  

Just to improve the previous (correct) answer, i use on my projects :

为了改进之前的(正确的)答案,我在我的项目中使用:

String.prototype.toObjectId = function() {
  var ObjectId = (require('mongoose').Types.ObjectId);
  return new ObjectId(this.toString());
};

// Every String can be casted in ObjectId now
console.log('545f489dea12346454ae793b'.toObjectId());

#3


6  

Instead of using ObjectId to find by comparing your parameters simply use Campaign.findById {req.param('client_id'),function(err,docs)}....

不要通过比较参数来使用objective - find,只需使用Campaign。findById { req.param(client_id)、功能(呃,文档)} ....

when finding docs using objectId findById is the most efficient way of all...

使用objectId findById查找文档是最有效的方法。