为什么我在oa的公告管理里发布了公告，却没办法查看到

诸葛钢铁

在公告管理中发布了公告，也在公告发布管理中通过了发布审核，但是在公告查看页面一条数据也查不出来

诸葛钢铁

后台也没有报错

诸葛钢铁

为什么数据都查不出来

jishuang

参考http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035把执行的sql打出来到数据库中看看是否有满足条件的数据

诸葛钢铁

jishuang 发表于 2016-9-23 17:17
参考http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost&ptid=33524&pid=165004035把执行的sql打出 ...

sql:SELECT count(*) FROM OA_KM_Knowledge OA_KM_Knowledge  WHERE  ( (OA_KM_Knowledge.fID IN (SELECT  OA_KM_Rights.fKWID AS fKWID FROM OA_KM_Rights OA_KM_Rights  WHERE  ( ?  LIKE concat_ws('',OA_KM_Rights.FORGFID, ?)) AND (OA_KM_Rights.FCANREADKW = ?) )) AND (OA_KM_Knowledge.fID IN (SELECT  OA_KM_READERS.fKWID AS OA_KM_READERS_fKWID FROM OA_KM_READERS OA_KM_READERS  WHERE OA_KM_READERS.FREADERID =  ? )) ) AND ( ( (OA_KM_Knowledge.FFOLDERID = ?) OR (OA_KM_Knowledge.FFOLDERFULLID LIKE ?) ) AND (OA_KM_Knowledge.FRELEASESTATUSNAME = ?) )
--> binds:[/d318QDys9LySQTAMMzU.ogn/UJS5A1HW65rWgsZCNIq.dpt/6od0TCabqGg2cW7RWf2.pos/GQTeh5xeVjLqiXh30RB@6od0TCabqGg2cW7RWf2.psm, %, 1, GQTeh5xeVjLqiXh30RB, notice, public/notice%, 已发布]

jishuang

到数据库中执行语句看看能查到数据吗？