列表自定义SQL

  //用户权限控制
    "popedom": {
      "need": "userId",
      "show": "user_id,real_name,null account,head_icon,telephone,'00000000000000000' name",
      "selectSql": {
        "detail": ""
      },
      "where": "{s-if:userName} and (real_name like CONCAT('%',@userName,'%') or user_id in (select user_id from bo_user_account where nike_name like CONCAT('%',@userName,'%') or telephone_suffix like  CONCAT('%',@userName,'%'))){e-if:userName}",
      "field": {
        //多名字情况，按优先基本有数据展示
        "doName": {
          "name": [
            {
              "name": "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
            },
            {
              "key": "user_id", //主键别名  使用于  1对1
              "value": "-",
              "sortId": 5
            }
          ]
        }
      },
      "fieldChild": {
        "account": {
          "moduleKey": "bo-user-account",
          "responseField": "popedom",
          "showMethod": "childobject"
        }
      }
    }

多库自定义语句

{
  "columns": {
    "parentName": {
      "fieldSort": 9999,
      "tableId": 1,
      "dataType": "varchar",
      "title": "上级行政区",
      "remark": "用于搜索",
      "guidMethod": "None",
      "isRequired": true,
      "isSearch": true,
      "isData": false,
      "editPropertie": {
        "showMethod": "text"
      },
      "pagePropertie": {
        "showMethod": "text"
      },
      "filter": {
        "method": "custom",
        "isMust": false,
        //"sql": " and parent_id in (select menu_id from bo_sys_menu where menu_name like CONCAT('%',@parentName,'%'))",
        //如果 sqlCustom 没找到,使用 sql     sqlserver   mysql  oracle sqlite  SqlCustom
        "sqlCustom": {
          "mysql": " and parent_code in (select area_code from bo_sys_area where area_name like CONCAT('%',@parentName,'%'))",
          "oracle": " and parent_code in (select area_code from bo_sys_area where area_name like '%'||@parentName||'%')",
          "sqlserver": " and parent_code in (select area_code from bo_sys_area where area_name like '%'+@parentName+'%')"
        }
      },
      "field": "parentName",
      "name": "parent_name",
      "alias": "parent_name",
      "isDate": false,
      "isPrimary": false,
      "isIdentity": false,
      "maxLength": 50
    }
  }
}