4***@qq.com
4***@qq.com
  • 发布:2021-05-15 02:16
  • 更新:2021-05-15 21:19
  • 阅读:732

unicloud子集合去重统计

分类:uniCloud

unicloud的子集合去重统计到底要怎么整呢,太困惑的,请懂的大侠指教一下,如下面集合,统计每个分组userid的实有个数,mongodb实在没怎么学,见笑了

{
"requestId": "1796c10f5b6_1",
"data": [{
"_id": "28ee4e3e6096568b16e8dd363856cedd",
"title": "测试问题一大堆",
"status": 1,
"djsl": 259,
"userid": ["o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "081AfE0w3AmplW2Agq0w3es9nq3AfE0F",
"081AfE0w3AmplW2Agq0w3es9nq3AfE0F", "001lFKFa1bN31B0HymJa1tjO5o3lFKFg",
"001lFKFa1bN31B0HymJa1tjO5o3lFKFg", "001lFKFa1bN31B0HymJa1tjO5o3lFKFg",
"041ZRZ0004pMFL1sX1200ZbtJh4ZRZ0a", "041ZRZ0004pMFL1sX1200ZbtJh4ZRZ0a",
"041ZRZ0004pMFL1sX1200ZbtJh4ZRZ0a", "041ZRZ0004pMFL1sX1200ZbtJh4ZRZ0a",
"041ZRZ0004pMFL1sX1200ZbtJh4ZRZ0a", "0519djGa1O5t0B0iYHFa1pX5XV09djGE",
"011sMa000xyBGL1gwn300MIoDs3sMa0D", "011sMa000xyBGL1gwn300MIoDs3sMa0D",
"011sMa000xyBGL1gwn300MIoDs3sMa0D", "02199LFa12111B0c0HJa1ZrMZN099LFF",
"02199LFa12111B0c0HJa1ZrMZN099LFF", "",
"", "031PZLFa1ff21B0nHMFa1pCNNe0PZLFN",
"051DOJ000Fp4GL1BzT000fuoGz1DOJ09", "00109MFa15p01B07jVIa1UHsYX209MFa",
"00109MFa15p01B07jVIa1UHsYX209MFa", "00109MFa15p01B07jVIa1UHsYX209MFa",
"00109MFa15p01B07jVIa1UHsYX209MFa", "00109MFa15p01B07jVIa1UHsYX209MFa",
"00109MFa15p01B07jVIa1UHsYX209MFa", "021YrvFa1uBh1B09DCIa1Inwqd2YrvF7",
"021YrvFa1uBh1B09DCIa1Inwqd2YrvF7", "021YrvFa1uBh1B09DCIa1Inwqd2YrvF7",
"021YrvFa1uBh1B09DCIa1Inwqd2YrvF7", "071OxMFa1no01B0BT4Ha1Au7rE4OxMFJ",
"071OxMFa1no01B0BT4Ha1Au7rE4OxMFJ", "071OxMFa1no01B0BT4Ha1Au7rE4OxMFJ",
"0213AvFa1E2i1B0YCyGa1766ta33AvFw", "0213AvFa1E2i1B0YCyGa1766ta33AvFw",
"0515NBGa1gho2B0oU5Ja1RZQvr35NBGa", "0515NBGa1gho2B0oU5Ja1RZQvr35NBGa",
"0515NBGa1gho2B0oU5Ja1RZQvr35NBGa", "0415ACGa1c9v2B0kOPFa1N8Yqi35ACGa",
"001jbu000R6rGL16B9200BEvWr4jbu0r", "001jbu000R6rGL16B9200BEvWr4jbu0r",
"001bGlGa1vwA0B0Wt3Ga1zMnkI0bGlGa", "041cX4Ga1kMQ0B0kAsGa1uycnq3cX4GG",
"081GZVGa1N492B0khnGa1mtTRR1GZVGq", "081GZVGa1N492B0khnGa1mtTRR1GZVGq",
"081GZVGa1N492B0khnGa1mtTRR1GZVGq", "061hAh1w3XG2nW2h484w3Ji6U82hAh1Q",
"091hSyFa13Xj1B0o31Ia15UtbH0hSyFw", "091hSyFa13Xj1B0o31Ia15UtbH0hSyFw",
"091hSyFa13Xj1B0o31Ia15UtbH0hSyFw", "001v3rll2JkI074SFKnl2fJhIV2v3rli",
"001v3rll2JkI074SFKnl2fJhIV2v3rli", "001v3rll2JkI074SFKnl2fJhIV2v3rli",
"001v3rll2JkI074SFKnl2fJhIV2v3rli", "001v3rll2JkI074SFKnl2fJhIV2v3rli",
"031f8rll2goI074HrUol2t3M8A2f8rld", "061MPzFa13il1B06qlFa1YV02B4MPzFS",
"061MPzFa13il1B06qlFa1YV02B4MPzFS", "061MPzFa13il1B06qlFa1YV02B4MPzFS",
"071Fso100a8EHL197N3008i8zS0Fso1F", "071Fso100a8EHL197N3008i8zS0Fso1F",
"071Fso100a8EHL197N3008i8zS0Fso1F", "071Fso100a8EHL197N3008i8zS0Fso1F",
"071Fso100a8EHL197N3008i8zS0Fso1F", "071Fso100a8EHL197N3008i8zS0Fso1F",
"071Fso100a8EHL197N3008i8zS0Fso1F", "0114crGa1OAB2B0WlhGa15gg5h04crGE",
"051Jhdll2BqV074D8fnl2SuYpi3JhdlU", "051Jhdll2BqV074D8fnl2SuYpi3JhdlU",
"051Jhdll2BqV074D8fnl2SuYpi3JhdlU", "051Jhdll2BqV074D8fnl2SuYpi3JhdlU",
"051Jhdll2BqV074D8fnl2SuYpi3JhdlU", "051Jhdll2BqV074D8fnl2SuYpi3JhdlU",
"051Jhdll2BqV074D8fnl2SuYpi3JhdlU", "051Jhdll2BqV074D8fnl2SuYpi3JhdlU",
"051Jhdll2BqV074D8fnl2SuYpi3JhdlU", "051Jhdll2BqV074D8fnl2SuYpi3JhdlU",
"051Jhdll2BqV074D8fnl2SuYpi3JhdlU", "001MQ20001hRGL1C45000Vchu01MQ20f",
"001CBq100BIEHL1CQy200VmV5X0CBq1t", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4gD90B26j3hwfDtqvk8Zvc8", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY",
"o9YyG4ufnusetxpmnS51WR9dRw28", "o9YyG4ufnusetxpmnS51WR9dRw28", "o9YyG4ufnusetxpmnS51WR9dRw28",
"o9YyG4ufnusetxpmnS51WR9dRw28", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY"
]
}, {
"_id": "79550af2609ca8fe165ca0374a321283",
"title": "测试主题11111",
"status": 1,
"djsl": 5,
"userid": ["o9YyG4ufnusetxpmnS51WR9dRw28", "o9YyG4ufnusetxpmnS51WR9dRw28",
"o9YyG4ufnusetxpmnS51WR9dRw28",
"o9YyG4ufnusetxpmnS51WR9dRw28", "o9YyG4lHDMbXn4RhgBLrj7ZQzEnY"]
}, {
"_id": "b00064a7609ca90416f8c51811c6cf6c",
"title": "测试主题222",
"status": 1,
"djsl": 3,
"userid": ["o9YyG4ufnusetxpmnS51WR9dRw28", "o9YyG4ufnusetxpmnS51WR9dRw28",
"o9YyG4ufnusetxpmnS51WR9dRw28"]
}, {
"_id": "28ee4e3e609d1be11852251a58b49349",
"title": "测试发卷",
"djsl": 0,
"userid": []
}]
}

2021-05-15 02:16 负责人:无 分享
已邀请:
4***@qq.com

4***@qq.com (作者)

有没有懂行的兄弟,我的项目简要来说,就是有一个 试卷库,一个答题库,一个人可能对同一份卷重复提交多次,然后需要分组统计每一份的 试卷名称,答卷数量,参与答卷用户数量,在unicloud的组表查询里只会 统计 试卷名,答卷数量,不会统计用户数量,想请教下这个怎么整

该问题目前已经被锁定, 无法添加新回复