升级到4.1版本后，公共资源预约的预约时间不显示，可以预约成功，页面无数据

现象：发起预约的时候，选择时间段后，预约时间不显示任何数据，发起不会有提示，最后数据管理页面同样无法查看到数据，但是在预约列表页可以看到数据

配置需修改如下：预约信息数据源联动参数保留如下图所示，如果之前是直接粘贴的通用查询里面的语句，参数为resInfoId.strarr，需要去掉 .strarr ，否则数据源联动无法带出数据

以上方法还不行，请替换此sql

SELECT
    rr. ID AS resInfo#ID,
    rr.res_name AS resInfo#ZYMC,
    to_char(ri.res_date,'yyyy-MM-dd') AS resInfo#YYRQ,
    rt.start_time || ' - ' || rt.end_time AS resInfo#SJQJ,
    rr.campus_name AS resInfo#XQ,
    rr.buildings_name AS resInfo#JZW,
    rr.res_address AS resInfo#XXDZ,
    ri.res_status AS resInfo#YYZT,
    ri.create_time AS resInfo#CJSJ,
    rr.flow_id AS resInfo#LCID,
    ri.remark AS resInfo#BZ,
    ri.res_status AS resInfo#ZT
FROM
    HT_RES_RECORD ri
    INNER JOIN HT_RES_RESOURCE rr ON rr. ID = ri.res_id
    INNER JOIN HT_RES_TIME_RANGE rt ON rt. ID = ri.time_id
WHERE
    1 = 1
    AND ri. ID IN (${resInfoId.strarr})

公共资源预约的预约时间只显示6条，想多条显示，表单控件找到resInfoId这个控件，在html下，把他的maxlength字段改成10000

公共资源预约，日期和时间乱序，可调整预约SQL，增加排序：order by ri.res_date,rt.start_time asc

SELECT
rr. ID AS resInfo#ID,
rr.res_name AS resInfo#ZYMC,
to_char(ri.res_date,'yyyy-MM-dd') AS resInfo#YYRQ,
rt.start_time || ' - ' || rt.end_time AS resInfo#SJQJ,
rr.campus_name AS resInfo#XQ,
rr.buildings_name AS resInfo#JZW,
rr.res_address AS resInfo#XXDZ,
ri.res_status AS resInfo#YYZT,
ri.create_time AS resInfo#CJSJ,
rr.flow_id AS resInfo#LCID,
ri.remark AS resInfo#BZ,
ri.res_status AS resInfo#ZT
FROM
HT_RES_RECORD ri
INNER JOIN HT_RES_RESOURCE rr ON rr. ID = ri.res_id
INNER JOIN HT_RES_TIME_RANGE rt ON rt. ID = ri.time_id
WHERE
1 = 1
AND ri. ID IN (${resInfoId.strarr}) order by ri.res_date,rt.start_time asc