Requête médicosocial

requete_medicosocial.js

db.getCollection('simulations').mapReduce(function() {
    var propAnswer1 = this.answers.current.find(function(e) {
        return e.fieldName === "_formationSanitaireSocial"
    })
    var propAnswer2 = this.answers.current.find(function(e) {
        return e.fieldName === "_interetAidesSanitaireSocial"
    })
    var group = this.dateDeValeur.toISOString().slice(0,4)
    var v1 = propAnswer1 ? propAnswer1.value : "#N/A"
    var v2 = propAnswer2 ? propAnswer2.value : "#N/A"
    emit(group + ";" + v1 + ";" + v2, 1)
}, function(k,v) {
    return Array.sum(v);
}, {
    query: {
        //dateDeValeur: { $gt: ISODate('2022-04-10') },
    },
    out: { inline: 1 },
}).results.map(function(o) {
    return o._id + ";" + o.value;
}).join('\n')

result.md

periode	_formationSanitaireSocial	_interetAidesSanitaireSocial	nombre
2021	#N/A	#N/A	117076
2022	#N/A	#N/A	184061
2022	#N/A	false	11299
2022	#N/A	true	4922
2022	false	#N/A	71
2022	false	false	9568
2022	false	true	2374
2022	true	#N/A	1256