根据Query的名字查找是那个CLF逻辑中使用/Fileds在CLFs和CDOs中的位置

select cdodefinition.cdoname
, CLFeventMap.Name "Method"
, CLFDefinition.CLFNAME CLF
--, CLFSource.CLFNAME CLFCopySource
, functiondefinition.NAME FunctionName
, funparmdef.name ParmName
, CLFFunParm.ValueExpression
from CLFeventMap
left outer join CLFDefinition on CLFDefinition.CLFID = CLFEventMap.CLFID
left outer join CLFDefinition CLFSource on CLFSource.CLFID = CLFDefinition.SOURCECLFID
join CLFEvents on CLFEvents.CLFEVENTID = CLFEventMap.CLFEVENTID
left outer join CLFFunParm on CLFFunParm.clfeventmapid = CLFeventMap.clfeventmapid
right outer join cdodefinition on cdodefinition.cdodefid = CLFeventMap.cdodefid
join clffunctions on clffunctions.CLFFUNCTIONID = clffunparm.CLFFUNCTIONID
join functiondefinition on functiondefinition.FUNCTIONID = clffunctions.FUNCTIONID
join funparmdef on funparmdef.functionparmid = clffunparm.FUNCTIONPARMID
where UPPER(valueexpression) like UPPER('%OrderStatus%')
and CLFEvents.CALLERTYPE = 1 --CDO Events Only
and cdodefinition.cdoname like '%%'
and funparmdef.name like '%%'
and UPPER(functiondefinition.NAME) like UPPER('%%')
and UPPER(CLFDefinition.CLFNAME) like UPPER('%%')
and CLFeventMap.Name like '%%'
Order by cdodefinition.cdoname,CLFeventMap.Name;