'aggregations select does not work in mongodb compass window tool

All of a sudden Select doesn't work Your query doesn't seem to be wrong Select doesn't work and it's hard to insert a pipeline I need it for debugging Why doesn't it work?

Windows mongodb compass management tool Aggregations -> Select query add does not work

image link https://i.stack.imgur.com/z609k.png

mycode enter image description here

[
    {'$match':{'month':202202}},        
    {
        '$lookup':{
            'from':'stat_ad_conversion',
            'let':{'master_id':'$master_id','campaign_id':'$campaign_id','biz_id':'$biz_id','yyyy':'$yyyy','mm':'$mm'},
            'pipeline':[
                {
                    '$match':{
                        '$expr':{
                            '$and':[
                                {'$eq':['$master_id','$$master_id']},
                                {'$eq':['$campaign_id','$$campaign_id']},
                                {'$eq':['$biz_id','$$biz_id']},
                                {'$eq':['$yyyy','$$yyyy']},
                                {'$eq':['$mm','$$mm']}
                            ]
                        }
                    }
                }               
            ],
            'as':'t1'
        }
    },
    {'$unwind':{'path':'$t1','preserveNullAndEmptyArrays':true}},
    {
        '$group':{
            '_id':{'master_id':'$master_id','campaign_id':'$campaign_id','biz_id':'$biz_id','yyyy':'$yyyy','mm':'$mm'},
            'exposecount':{'$sum':'$exposecount'},
            'clickcount':{'$sum':'$clickcount'},
            'cost':{'$sum':'$cost'},
            'mm':{'$first':'$mm'}
        }
    },
    {
        '$group':{
            '_id':{'master_id':'$t1.master_id','campaign_id':'$t1.campaign_id','biz_id':'$t1.biz_id','keyword_id':'$t1.keyword_id','yyyy':'$t1.yyyy','mm':'$t1.mm'},
            'count':{'$sum':'$conversion_count'},
            'keywordcount':{'$sum':1},
            'conversioncost':{'$sum':'$t1.conversion_count'},
            'directcount':{'$sum':{'$switch':{'branches':[{'case':{'$eq':['$t1.conversion_method',1]},'then':'$t1.conversion_count'}],'default':0}}},
            'indirectcount':{'$sum':{'$switch':{'branches':[{'case':{'$eq':['$t1.conversion_method',2]},'then':'$t1.conversion_count'}],'default':0}}},
            'conversioncost':{'$sum':'$t1.sales_conversion'},
            'conversiondirectcost':{'$sum':{'$switch':{'branches':[{'case':{'$eq':['$t1.conversion_method',1]},'then':'$t1.sales_conversion'}],'default':0}}},
            'conversionindirectcost':{'$sum':{'$switch':{'branches':[{'case':{'$eq':['$t1.conversion_method',2]},'then':'$t1.sales_conversion'}],'default':0}}}
        }
    },
    {
        '$merge':{
            'into':'finish_period_month_1',
            'on':'_id',
            'whenMatched':'replace',
            'whenNotMatched':'insert'
        }
    }
]

Creating and executing a normal pipeline query Select does not work Only No Preview Documents no results are coming out

mongodb


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions