drfaustusfade / ngm-reportDesk

The workdesk for ReportHub
0 stars 1 forks source link

missing organization name and type attributes on old users #49

Open drfaustusfade opened 3 years ago

drfaustusfade commented 3 years ago
fakhrihawari commented 3 years ago

Link PR https://github.com/drfaustusfade/ngm-reportHub/pull/95

drfaustusfade commented 3 years ago

thanks, also script to update users in db could be useful

fakhrihawari commented 3 years ago

db.user.find({ $or: [{ "organization_type": { $exists: false } }, { "organization_name": { $exists: false } }] }).forEach(function (u) { if(u.organization_tag !== null && u.organization_tag !== undefined){ var find_org = db.organizations.findOne({ "organization_tag": u.organization_tag }); if (find_org !== null) { u.organization_type = find_org.organization_type; u.organization_name = find_org.organization_name};print(u.organization_type, u.organization_name)}});

But if I try to use the ObjectId(u.organization_id) not working db.user.find({ $or: [{ "organization_type": { $exists: false } }, { "organization_name": { $exists: false } }] }).forEach(function (u) { var find_org = db.organizations.findOne({ "_id": ObjectId(u.organization_id) }); if (find_org) { u.organization_type = find_org.organization_type; u.organization_name = find_org.organization_name }; print(u.organization_type, u.organization_name) }) ???