Advertisement
Bobrovozka

Untitled

Jun 12th, 2021
435
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. db.getCollection('callTask').aggregate(
  2. {
  3. $match: {campaign: {$in:["60c42cf6f4ed78000188d078","60c43226f4ed78000188d07a","60c434c3f4ed78000188d07c",
  4. "60c435f9f4ed78000188d07d", "60c43686f4ed78000188d07e","60c43c40f4ed78000188d083", "60c4389bf4ed78000188d080"]}},
  5. },
  6. {
  7. $group : {_id:"$state", total : {$sum:1}}
  8. }
  9. );
  10.  
  11.  
  12. db.getCollection('callTask').aggregate(
  13. {
  14. $match : {state : "FAILED",campaign: {$in:["60c42cf6f4ed78000188d078","60c43226f4ed78000188d07a","60c434c3f4ed78000188d07c",
  15. "60c435f9f4ed78000188d07d", "60c43686f4ed78000188d07e","60c43c40f4ed78000188d083", "60c4389bf4ed78000188d080"]}}
  16. },
  17. {
  18. $group : {_id : "$failComment", total : { $sum : 1 }}
  19. }
  20. );
  21.  
  22.  
  23. db.getCollection('campaign').find({name:/12.06.2021/})
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement