用户显示名称app_sql_extend.json

维数据

 "userBasis": {
      //"allSql": "select nike_name name,0 parent_id,user_id id,user_id value from bo_user where user_status=1     and user_id in @_fromPrimaryIds    order by user_id", 
      "allSql": "select u.user_id id,u.user_id value,ifnull(ifnull(ifnull(ifnull(real_name,ua.nike_name),ua.user_name),email),telephone) name,0 parent_id from bo_user  u left join bo_user_account ua on(ua.user_id=u.user_id) where u.user_status is not null     and u.user_id in @_fromPrimaryIds    order by u.user_id",
      //"sql": {
      //  "oracle": null,
      //  "mysql": null,
      //  "sqlserver": null,
      //  "sqlite": null,
      //  "postgresql": null
      //},
      "connName": "ConnBo",
      "dimCacheKey": "dim-bo-user",
      "name": "用户信息",
      "fromExtend": true
    },

字段读取顺序

      //{
      //  "name": "push_name",
      //  "path": "real_name",
      //  "sortId": 1
      //},
      //{
      //  "key": "user_id", //主键别名  使用于  1对1
      //  "path": "account:nike_name", // : 前面为主表列 ，  后面为1对1里面表列
      //  "value": "-",
      //  "sortId": 2
      //},
      //{
      //  "path": "email",
      //  "sortId": 3
      //},
      //{
      //  "path": "telephone",
      //  "value": "-",
      //  "sortId": 4
      //},