db.idm.aggregate

执行数据库聚合查询获取数据

• 请求路由: db.idm.aggregate
• 交互模型: Request Stream
• 访问限制: SPI

请求

RSocket.rs({
  "route" : "db.idm.aggregate",
  "args" : {
    "collection" : "tauAction",
    "pipeline" : [
      "{ $match : { endpoint : 'auth.wx } }",
      "{ $unwind : { path : '$tags' } }",
      "{ $sort : { upDate : -1 } }",
      "{ $limit : 10 }"
    ]
  }
});

请求参数

名称	类型	必须	说明
collection	String	否	集合名称
pipeline	String	否	聚合查询语句

返回

查询结果

[
  {
    "username" : "13510486135@mzd",
    "tenantId" : "mzd",
    "fullname" : "杨师傅",
    "userTypes" : [
      1,
      3
    ],
    "domain" : "mzd",
    "endpoint" : "auth.wx",
    "tags" : "auth",
    "title" : "微信认证",
    "targetId" : "ofZFZ42AFxEKOBW_9rl1cV-KkO04",
    "ts" : "2021-10-21T02:12:54.447+00:00",
    "args" : {
      "body" : {
        "session_key" : "+HkvtrxuEwKy3Ek30SP1gQ==",
        "openid" : "ofZFZ42AFxEKOBW_9rl1cV-KkO04",
        "unionid" : "o6ZuW6D3LitJnSLWP-y0dIjdmuXk",
        "appId" : "wx67e073a40661299c",
        "gender" : 0,
        "language" : "zh_CN",
        "city" : "",
        "province" : "",
        "country" : "",
        "userType" : 3,
        "nickname" : "Yang",
        "headimgurl" : "https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwG......YNRQ/132",
        "scope" : "cbv-driver",
        "avatarUrl" : "https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwG......NRQ/132",
        "fullname" : "Yang"
      }
    },
    "id" : "6170cca673eaf40903a5a8b7"
  },
  {
    "username" : "13510486135@mzd",
    "tenantId" : "mzd",
    "fullname" : "杨师傅",
    "userTypes" : [
      1,
      3
    ],
    "domain" : "mzd",
    "endpoint" : "auth.wx",
    "tags" : "auth",
    "title" : "微信认证",
    "targetId" : "oKQgr43aPZkI8iohcodsxTa2G_yM",
    "ts" : "2021-10-25T02:42:01.568+00:00",
    "args" : {
      "body" : {
        "session_key" : "a/WFnQSZAy6ADfiykKnjpg==",
        "openid" : "oKQgr43aPZkI8iohcodsxTa2G_yM",
        "unionid" : "o6ZuW6D3LitJnSLWP-y0dIjdmuXk",
        "appId" : "wxd0be3263c2bdd6bf",
        "gender" : 0,
        "language" : "zh_CN",
        "city" : "",
        "province" : "",
        "country" : "",
        "userType" : 1,
        "customerInfo" : {
          "agentId" : "1207629997569892352",
          "partnerId" : "0",
          "customerType" : "1"
        },
        "nickname" : "Yang",
        "headimgurl" : "https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4T......IA6g/132",
        "scope" : "cbv-mzd",
        "avatarUrl" : "https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4T......IA6g/132",
        "fullname" : "Yang"
      }
    },
    "id" : "6176197937f9d800cb23b71e"
  }
]