根据Query的名字查找是那个CLF逻辑中使用
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;
最新文章
- 如何用openvr api打开vive前置摄像头
- Ubuntu gmake: command not found
- java_stack
- python selenium下载电子书
- webqq协议请求交互过程
- 44、自定义仿IOS对话框
- linux磁盘及分区详解
- 异常-----freemarker.template.TemplateException: The only legal comparisons are between two numbers, two strings, or two dates
- C#/AutoCAD 2018/ObjectArx/二次开发再说实体（六）
- asp.net mvc前台显示带htm标签的解决办法(Razor —@Html.Raw())
- shiro授权测试
- SDL 库 无法解析的外部符号 __imp__fprintf
- 【Finchley】【升级变更】Spring Cloud 升级到Finchley版本后需要注意的地方
- IDEA分享项目到GitHub出现Could not read from remote repository
- 使maven2在下载依赖包的同时下载其源代码包。
- linux stat 命令查看文件信息
- 三、redis系列之事务
- IT运维流程 — ITIL
- NetBeans启动Tomcat报“'127.0.0.1' 不是内部或外部命令”启动失败的解决办法
- Windows下使用CMake进阶