/查询所有彭晓燕下属的roleid List<CCObject> roleList = cs.cquery("role", " parentrole_id__c='"+ 彭晓燕的roleid +"' and gap__c > 0 "); String roleIds = ""; for(CCObject obj : roleList){ if(!"".equals(obj.get("roleid"))){ roleIds += "'" + obj.get("roleid") + "',"; } } if(roleIds.length() > 0){ roleIds = "(" + roleIds.substring(0, roleIds.length() - 1) + ")"; }else{ roleIds = "('')"; } //根据下属roleid,查询对应的用户 List<CCObject> userList=cs.cquery("User", "role__c in " + roleIds ;); String userIds=””; for(CCObject obj1 : userList){ if(!"".equals(obj1.get("id"))){ userIds += "'" + obj1.get("id") + "',"; } } if(userList.length() > 0){ userIds = "(" + userIds.substring(0, userIds.length() - 1) + ")"; }else{ userIds = "('')"; } 上述方法就把彭晓燕下属的用户id,都拼成userIds这个参数了 然后在写查询业务数据的的sql,在查询条件里用业务员字段 in userIds,就能查询出下属人员的数据了