|
楼主 |
发表于 2019-4-26 18:10:20
|
显示全部楼层
本帖最后由 sandgia 于 2019-4-26 18:20 编辑
是orgDialogPC,这个公式没有问题,选择后试过了,但是还有个限制展现范围的有问题,rootFilter属性设置为SA_OPOrg.sParent='100034' or SA_OPOrg.sParent='100033' 有问题,选择不到 100034的部门,写得有错吗?
附上打印的信息:
2019-04-26 18:11:21 [SQL Time]sql 执行时间:43ms, exec KSQL:
--> sql:SELECT count(*) FROM SA_OPOrg SA_OPOrg WHERE (SA_OPOrg.SVALIDSTATE >= ?) AND ( ( (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) OR (SA_OPOrg.sFID LIKE ?) ) AND ( (UPPER(SA_OPOrg.SCODE) LIKE ?) OR (UPPER(SA_OPOrg.SNAME) LIKE ?) ) AND (SA_OPOrg.SVALIDSTATE = ?) )
--> binds:[0, /100000.ogn/100033.dpt/200187@100033.psm%, /100000.ogn/100033.dpt/200361@100033.psm%, /100000.ogn/100033.dpt/200439@100033.psm%, /100000.ogn/100033.dpt/200621@100033.psm%, /100000.ogn/100033.dpt/200637@100033.psm%, /100000.ogn/100033.dpt/J200686@100033.psm%, /100000.ogn/100033.dpt/200751@100033.psm%, /100000.ogn/100033.dpt/200855@100033.psm%, /100000.ogn/100033.dpt/200908@100033.psm%, /100000.ogn/100033.dpt/200914@100033.psm%, /100000.ogn/100033.dpt/200916@100033.psm%, /100000.ogn/100033.dpt/200974@100033.psm%, /100000.ogn/100033.dpt/201224@100033.psm%, /100000.ogn/100033.dpt/201245@100033.psm%, /100000.ogn/100033.dpt/201322@100033.psm%, /100000.ogn/100033.dpt/201452@100033.psm%, /100000.ogn/100033.dpt/201567@100033.psm%, /100000.ogn/100033.dpt/888924@100033.psm%, /100000.ogn/100033.dpt/888933@100033.psm%, /100000.ogn/100033.dpt/889065@100033.psm%, %吴%, %吴%, 1]
这个问题出在什么地方?
|
|