报表设计过滤条件中填写或条件时，逻辑有误PTM5+PT101835
添加人员性别为男或者婚姻状态为未婚的过滤条件，查看SQL语句为如下，查询结果为不管选择哪个组织，只要满足性别为男或者未婚的都会导出所有组织。
WHERE (( ( ( ( "PERSON".FGender= 1 or "WED".FName_l2 like '%未婚%' and ( "ADMINORGUNIT".FLongNumber= '@adminOrg' or "ADMINORGUNIT".FLongNumber like '@adminOrg!%' ) and "ADMINORGUNIT".FHistoryRelateID in (SELECT FOrgID FROM T_PM_OrgRange WHERE FUserID = '@ExtRptCurrentUserInfoID' AND FType = 20) ) ) and ( "PERSON".FEFFDT<= {ts'@baseDate'} and "PERSON".FLEFFDT>= {ts'@baseDate'} and "PP".FEFFDT<= {ts'@baseDate'} and "PP".FLEFFDT>= {ts'@baseDate'} and "EMPORGRELATION".FEFFDT<= {ts'@baseDate'} and "EMPORGRELATION".FLEFFDT>= {ts'@baseDate'} ) ) and ( "EMPORGRELATION".FIsIncount= 1 and "EMPTYPE".FIsInCount= 1 ) ) and ( "EMPORGRELATION".FIsEnrolled= 1 and "EMPTYPE".FIsOnTheStrength= 1 ) ) ) tempTT
逻辑应当是在"PERSON".FGender= 1 or "WED".FName_l2 like '%未婚%' 外增加小括号
请提单 解决此问题，谢谢。
报表设计过滤条件中填写或条件时，逻辑有误PTM5+PT101835
本文2024-09-17 00:59:42发表“s-hr cloud知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-shr-64578.html
