报表开发问题：一主表，多从表，从信息表重复问题

叫我银垚就好了

在报表开发中，页面设置了4个bizData：mainData（概念1）、detailData（概念2）、WPGLYData（概念3）和HQCData（概念3）
其中detailData、WPGLYData和HQCData都关联了mainData。设置从表detailData正常显示没有问题。

在设置WPGLYData或者HQCData时（这两个data用的是同一个概念和同一个查询动作），如果只设置一个，也正常。但是同时设置两个，就出现问题了，无论我怎么分别设置过滤条件，第一个data和第二个data的数据始终一样，不能正常过滤。
然后第一data中原本应该过滤掉的数据但还是出现了，第二个data中原本过滤掉的数据还是出现了，sql信息单独拿到工具中查询是正常的：

2025-06-06 18:08:15 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT tab_L_ApprovalOpinions.*  FROM tab_L_ApprovalOpinions tab_L_ApprovalOpinions WHERE ((tab_L_ApprovalOpinions.sValidState = 1 and tab_L_ApprovalOpinions.sApprovalModule = '后勤管理' and tab_L_ApprovalOpinions.sApprovalForm = '库存入库' and tab_L_ApprovalOpinions.sApprovalNode = '物品管理员') AND (tab_L_ApprovalOpinions.sAssociationID='3BE17D9347074887A0F53AA4C5C4BB25')) LIMIT 0, -1

  --> sql:SELECT  tab_L_ApprovalOpinions.SAPPROVALFORM AS sApprovalForm, tab_L_ApprovalOpinions.SAPPROVALMODULE AS sApprovalModule, tab_L_ApprovalOpinions.SAPPROVALNODE AS sApprovalNode, tab_L_ApprovalOpinions.SAPPROVALTYPE AS sApprovalType, tab_L_ApprovalOpinions.SASSOCIATIONID AS sAssociationID, tab_L_ApprovalOpinions.SCREATEPERSON AS sCreatePerson, tab_L_ApprovalOpinions.SCREATEPERSONID AS sCreatePersonID, tab_L_ApprovalOpinions.SCREATETIME AS sCreateTime, tab_L_ApprovalOpinions.SINDEX AS sIndex, tab_L_ApprovalOpinions.SREMARKS AS sRemarks, tab_L_ApprovalOpinions.SSIGNDEPT AS sSignDept, tab_L_ApprovalOpinions.SSIGNDEPTID AS sSignDeptID, tab_L_ApprovalOpinions.SSIGNOPINION AS sSignOpinion, tab_L_ApprovalOpinions.SSIGNPERSON AS sSignPerson, tab_L_ApprovalOpinions.SSIGNPERSONID AS sSignPersonID, tab_L_ApprovalOpinions.SSIGNTIME AS sSignTime, tab_L_ApprovalOpinions.SUPDATEPERSON AS sUpdatePerson, tab_L_ApprovalOpinions.SUPDATEPERSONID AS sUpdatePersonID, tab_L_ApprovalOpinions.SUPDATETIME AS sUpdateTime, tab_L_ApprovalOpinions.SVALIDSTATE AS sValidState, tab_L_ApprovalOpinions.fID AS tab_L_ApprovalOpinions, tab_L_ApprovalOpinions.VERSION AS version FROM TAB_L_APPROVALOPINIONS tab_L_ApprovalOpinions  WHERE  ( (tab_L_ApprovalOpinions.SVALIDSTATE = ?) AND (tab_L_ApprovalOpinions.SAPPROVALMODULE = ?) AND (tab_L_ApprovalOpinions.SAPPROVALFORM = ?) AND (tab_L_ApprovalOpinions.SAPPROVALNODE = ?) ) AND (tab_L_ApprovalOpinions.SASSOCIATIONID = ?)

--> binds:[1, 后勤管理, 库存入库, 物品管理员, 3BE17D9347074887A0F53AA4C5C4BB25]

2025-06-06 18:08:15 [SQL Time]sql 执行时间：3ms, exec KSQL: SELECT tab_L_ApprovalOpinions.*  FROM tab_L_ApprovalOpinions tab_L_ApprovalOpinions WHERE ((tab_L_ApprovalOpinions.sValidState = 1 and tab_L_ApprovalOpinions.sApprovalModule = '后勤管理' and tab_L_ApprovalOpinions.sApprovalForm = '库存入库' and tab_L_ApprovalOpinions.sApprovalNode = '后勤处') AND (tab_L_ApprovalOpinions.sAssociationID='3BE17D9347074887A0F53AA4C5C4BB25')) LIMIT 0, -1

  --> sql:SELECT  tab_L_ApprovalOpinions.SAPPROVALFORM AS sApprovalForm, tab_L_ApprovalOpinions.SAPPROVALMODULE AS sApprovalModule, tab_L_ApprovalOpinions.SAPPROVALNODE AS sApprovalNode, tab_L_ApprovalOpinions.SAPPROVALTYPE AS sApprovalType, tab_L_ApprovalOpinions.SASSOCIATIONID AS sAssociationID, tab_L_ApprovalOpinions.SCREATEPERSON AS sCreatePerson, tab_L_ApprovalOpinions.SCREATEPERSONID AS sCreatePersonID, tab_L_ApprovalOpinions.SCREATETIME AS sCreateTime, tab_L_ApprovalOpinions.SINDEX AS sIndex, tab_L_ApprovalOpinions.SREMARKS AS sRemarks, tab_L_ApprovalOpinions.SSIGNDEPT AS sSignDept, tab_L_ApprovalOpinions.SSIGNDEPTID AS sSignDeptID, tab_L_ApprovalOpinions.SSIGNOPINION AS sSignOpinion, tab_L_ApprovalOpinions.SSIGNPERSON AS sSignPerson, tab_L_ApprovalOpinions.SSIGNPERSONID AS sSignPersonID, tab_L_ApprovalOpinions.SSIGNTIME AS sSignTime, tab_L_ApprovalOpinions.SUPDATEPERSON AS sUpdatePerson, tab_L_ApprovalOpinions.SUPDATEPERSONID AS sUpdatePersonID, tab_L_ApprovalOpinions.SUPDATETIME AS sUpdateTime, tab_L_ApprovalOpinions.SVALIDSTATE AS sValidState, tab_L_ApprovalOpinions.fID AS tab_L_ApprovalOpinions, tab_L_ApprovalOpinions.VERSION AS version FROM TAB_L_APPROVALOPINIONS tab_L_ApprovalOpinions  WHERE  ( (tab_L_ApprovalOpinions.SVALIDSTATE = ?) AND (tab_L_ApprovalOpinions.SAPPROVALMODULE = ?) AND (tab_L_ApprovalOpinions.SAPPROVALFORM = ?) AND (tab_L_ApprovalOpinions.SAPPROVALNODE = ?) ) AND (tab_L_ApprovalOpinions.SASSOCIATIONID = ?)

--> binds:[1, 后勤管理, 库存入库, 后勤处, 3BE17D9347074887A0F53AA4C5C4BB25]

错误报表信息：

叫我银垚就好了

添加了is-master-dataset:true和master-dataset:mainData。

叫我银垚就好了

这是data的xml

1.   <div component="$UI/system/components/justep/model/model" xid="model" style="height:auto;top:50px;left:38px;">
   
2.   <div component="$UI/system/components/justep/data/bizData" autoLoad="false" xid="mainData" concept="proc_Logistics" limit="-1" confirmRefresh="false"><reader xid="default1" action="/DrcProjManagement/logisticsManagement/logic/action/queryProc_LogisticsAction"></reader></div>
   
3.   <div component="$UI/system/components/justep/data/bizData" autoLoad="true" xid="detailData" concept="TAB_L_INVENTORYINFO" limit="-1" orderBy="FITEMNAME asc,FSPECS asc,FUNIT asc,FINBOUNDQTY desc,FINBOUNDPRICE desc,FINBOUNDAMOUNT desc" confirmRefresh="false" confirmDelete="false"><reader xid="default2" action="/DrcProjManagement/logisticsManagement/logic/action/queryTAB_L_INVENTORYINFOAction"></reader>
   
4.   <master xid="default3" data="mainData" relation="PPARENTID1"></master>
   
5.   <filter name="filter0" xid="filter1"><![CDATA[TAB_L_INVENTORYINFO.SVALIDSTATE = 1]]></filter></div><div component="$UI/system/components/justep/data/bizData" autoLoad="true" xid="WPGLYData" concept="tab_L_ApprovalOpinions" limit="-1" confirmRefresh="false"><filter name="filterWPGLY" xid="filter2"><![CDATA[tab_L_ApprovalOpinions.sValidState = 1
   
6. and tab_L_ApprovalOpinions.sApprovalModule = '后勤管理'
   
7. and tab_L_ApprovalOpinions.sApprovalForm = '库存入库'
   
8. and tab_L_ApprovalOpinions.sApprovalNode = '物品管理员']]></filter>
   
9.   <reader xid="default4" action="/DrcProjManagement/logisticsManagement/logic/action/queryTab_L_ApprovalOpinionsAction"></reader>
   
10.   <master xid="default6" data="mainData" relation="sAssociationID"></master></div>
    
11.   <div component="$UI/system/components/justep/data/bizData" autoLoad="true" xid="HQCData" concept="tab_L_ApprovalOpinions" limit="-1" confirmRefresh="false">
    
12.    <filter name="filterHQC" xid="filter3"><![CDATA[tab_L_ApprovalOpinions.sValidState = 1
    
13. and tab_L_ApprovalOpinions.sApprovalModule = '后勤管理'
    
14. and tab_L_ApprovalOpinions.sApprovalForm = '库存入库'
    
15. and tab_L_ApprovalOpinions.sApprovalNode = '后勤处']]></filter>
    
16.    <reader xid="default5" action="/DrcProjManagement/logisticsManagement/logic/action/queryTab_L_ApprovalOpinionsAction"></reader>
    
17.   <master xid="default7" data="mainData" relation="sAssociationID"></master></div></div>

复制代码

jishuang

看是不是数据的字段名一样，如果一样要把两个一个的字段名as一个不一样的别名