Use $addToSet condition vise in mongodb

Asked Jan 08 '19 at 06:26

Active Jan 08 '19 at 06:26

Viewed 1,061 times

I have below mongodb query, in which i am using $addToSet, Now i want to use it condition vise.

Worksheet.aggregate([
    {
     "$group": {
        "_id": null,
        "todayBilling": {
          "$sum": {
            "$cond": [{ "$and" : [ { "$eq": [ "$isBilling", true] }, { $eq: [ "$date",new Date(moment().format('l'))]}] },"$hours",0 ] 
          }
        },
        "todayProjects": { "$addToSet": "$projectId" }
      },
    },
    { "$addFields": { "todayProjects": { "$size": "$todayProjects" }}},
    {
      "$lookup":{
        "from": "projects",
        "let": {},
        "pipeline": [
          { 
            "$group": { "_id": null, "count": { "$sum": 1 } }
          }
        ],
        "as": "totalProjects"
      }
    },
    {'$unwind':'$totalProjects'}
  ])

Now, I want to get the count of todayProjects field if got result today date vise. means where "todayProjects": { "$addToSet": "$projectId" } exists, i want to use $cond with below condition:

{ $eq: [ "$date",new Date(moment().format('l'))]}

asked Jan 08 '19 at 06:26

Rajat

use `$match` after the `$group` stage. `{ $match: { todayProjects: { $ne: [] }}}` – Ashh Jan 08 '19 at 16:41
@AnthonyWinzlet, I need to get the todayProjects with the condition of current date. – Rajat Jan 08 '19 at 17:11
What is the format of the date Field? – Ashh Jan 08 '19 at 17:13
It is of "Date" type. – Rajat Jan 08 '19 at 17:14
What you do is correct, I just want to use $addToSet with condition vise. So that i can get result of the current date, not of previous date. – Rajat Jan 08 '19 at 17:16
You want the data filter with date? – Ashh Jan 08 '19 at 17:17
$match after $group is giving me error. – Rajat Jan 08 '19 at 17:17
yes, Below is my condition which i want to use: "$cond": [ { "$eq":["$date", new Date(moment().format('l'))] }] – Rajat Jan 08 '19 at 17:18
Have you used $lte $gte with the date Field? – Ashh Jan 08 '19 at 17:21
No, I dont want to use. I just want to get the data current date vise. – Rajat Jan 08 '19 at 17:22
No I am not getting you please try explain it with some sample collection and the output – Ashh Jan 08 '19 at 17:24
{ "$addFields": { "todayProjects": { "$size": "$todayProjects" }}} – Rajat Jan 08 '19 at 17:26
This expression is getting the size of the todayProjects, Right? – Rajat Jan 08 '19 at 17:27
Okay, If you are not getting it, I will edit my question shortly. – Rajat Jan 08 '19 at 17:33
https://stackoverflow.com/questions/54097090/get-count-of-distinct-field-values-condition-vise-in-mongodb, please have a look at above question, it includes what i want with proper explanation. – Rajat Jan 08 '19 at 17:47
@AnthonyWinzlet, Are you checking it? – Rajat Jan 08 '19 at 17:56
Post the expected output as well – Ashh Jan 08 '19 at 18:00
okay, will post within 2 minutes. – Rajat Jan 08 '19 at 18:02
done, please check. – Rajat Jan 08 '19 at 18:04
What does current date wise means? Still unclear what you are asking – Ashh Jan 08 '19 at 18:08
i just need to sum only one time for same project Id. – Rajat Jan 08 '19 at 18:12
As my new posted question contains the documents with the same project Id, But when i count, It should be give 1 not 2. – Rajat Jan 08 '19 at 18:13
@AnthonyWinzlet, Can you please help me in my one more query? – Rajat Jan 23 '19 at 10:35
Sure you can ask – Ashh Jan 23 '19 at 10:36
Okay thanks, Should i ask a new question? – Rajat Jan 23 '19 at 10:48
Yes please do.. – Ashh Jan 23 '19 at 15:04
@AnthonyWinzlet, Please have a look at below question: https://stackoverflow.com/questions/54360321/how-to-handle-find-if-collection-not-exists-in-mongodb – Rajat Jan 25 '19 at 06:54

Use $addToSet condition vise in mongodb

0 Answers0