【结】附件问题

pangshaowei

能否通过代码自定义附件的查询条件

我通过跟踪ＳＱＬ，跟踪到以下类似的

select V_APH_TDOCRELEVANCY.*, 0 AS FCONTENTCHANGED
from V_APH_TDOCRELEVANCY
where ((FKEY0 = 'BIZ:\JTMPS\JTMPSSJK.DATABASE\V_APH_MPS_PROJECTNODE.TABLE\FPROJECTID.FIELD'
and FKEY1 = 'BIZ:\JTMPS\JTMPSSJK.DATABASE\V_APH_MPS_PROJECTNODE.TABLE\FNODEID.FIELD'))


declare @p1 int
set @p1=3
exec sp_prepare @p1 output,N'@P0 nvarchar(4000),@P1 nvarchar(4000)',N'Declare @A0 nvarchar(32) Select @A0 = @P0  
Declare @A1 nvarchar(32) Select @A1 = @P1  
SELECT * FROM (
select V_APH_TDOCRELEVANCY .* , 0 AS FCONTENTCHANGED
from V_APH_TDOCRELEVANCY
where ( ( FKEY0 = ''BIZ:\MPSPROJECT\MPSPROJECTDATABASE.DATABASE\MPS_PROJECTNODE.TABLE\FPROJECTID.FIELD''
and FKEY1 = ''BIZ:\MPSPROJECT\MPSPROJECTDATABASE.DATABASE\MPS_PROJECTNODE.TABLE\FNODEID.FIELD'' ) ) ) A76545165727349F6998BFDD54CFC8
WHERE FKEYVALUE1 = @A0  AND FKEYVALUE0 = @A1',1
select @p1


我想修改FKEY0 FKEY1 的查询条件
由于业务场景比较特殊，用标准配置出来的这两个条件不能用

业务模型\协同系统\文档\关联\文档关联信息

我看了半天，没找到地方