Count MongoDB subjects

count_good_missing.js

// count good

let demographs;
let count=0;
let incl;
let csv;
let coll;

demographs=db.toc.find({"assessment":"form_sociodemographics"})
// print(demographs.length())

for (let i=0; i<demographs.length(); i++) {
    
    d=demographs[i];
    
    s=d['subject'];
    // print(s);
    
    
    coll=db[d['collection']].findOne();
    if ( ! coll ){ continue; }
        
    if (! 'chdemo_sexassigned' in coll) {
        continue;
    }
    
    incl=db.toc.findOne({"assessment":"form_inclusionexclusion_criteria_review","subject":s});
    if (! incl) { continue; }
        
    csv=db[incl['collection']].findOne();

    if (csv) {
    
        if ( ('chrcrit_part' in csv) && ('included_excluded' in csv) ) {
            
            count++;
        }    
    }
    
}

print(count)






// count missing
let demographs;
let count=0;
let incl;
let csv;
let coll;

demographs=db.toc.find({"assessment":"form_sociodemographics"})
// print(demographs.length())

for (let i=0; i<demographs.length(); i++) {
    
    d=demographs[i];
    
    s=d['subject'];
    // print(s);
    
    
    coll=db[d['collection']].findOne();
    if (! coll){ continue; }
        
    if (! 'chdemo_sexassigned' in coll) {
        continue;
    }
    
    incl=db.toc.findOne({"assessment":"form_inclusionexclusion_criteria_review","subject":s});
    if (! incl) { continue; }
        
    csv=db[incl['collection']].findOne();
    if (csv) {
    
        // if ( ('chrcrit_part' in csv) && ('included_excluded' in csv) ) {
        if ('chrcrit_part' in csv && 'included_excluded' in csv && csv['included_excluded']==='') {
            
            count++;
        }    
    }
    
}

print(count)