天道酬勤,学无止境

filenet-content-engine

如何将 DB2/Oracle 中的 FileNet ID ID 转换为友好的 GUID?(How can I translate the FileNet ID ID in DB2/Oracle into friendly GUID?)

问题 IBM 技术说明“如何转换 FileNet Enterprise Manager 中显示的唯一标识符,使其与存储在 Oracle 和 DB2 数据库中的内容相匹配”概述了 DB2 和 Oracle 如何以字节相反的顺序存储 guid。 如何将它们转换为友好的 guid? 回答1 假设 object_id char(16) for bit data是char(16) for bit data ,则以下表达式返回相同。 '{'||translate( 'GHEFCDAB-KLIJ-OPMN-QRST-UVWXYZ012345' , hex(F.object_id) , 'ABCDEFGHIJKLMNOPQRSTUVWXYZ012345')||'}' as object_id 回答2 以下代码在 DB2 中发挥了作用,遵循 IBM Technote 中的秘诀: ‘{’ concat upper(VARCHAR_FORMAT_BIT( cast(substring(F.Object_id, 4, 1) concat substring(F.Object_id, 3, 1) concat substring(F.Object_id, 2, 1) concat substring(F.Object_id, 1, 1) concat substring(F.Object_id, 6, 1)

2021-10-24 01:44:29    分类:技术分享    sql   oracle   db2   guid   filenet-content-engine

How can I translate the FileNet ID ID in DB2/Oracle into friendly GUID?

The IBM Technote "How to translate the unique identifier as displayed within FileNet Enterprise Manager so that it matches what is stored in the Oracle and DB2 databases" outlines how DB2 & Oracle store guids in a byte reversed order. How can I convert them into a friendly guid?

2021-10-23 17:08:40    分类:问答    sql   oracle   db2   guid   filenet-content-engine

Filenet - Get Email Id out of user id in Filenet Workflow

I am new to Filenet BPM and I am working on an approval system workflow where an attached document is either approved Or rejected based on the response. I have to send an email to Originator that the document is approved Or rejected and I am able to fetch the userId/AliasId of a person who launched the workflow but I am unable to get the emailId out of a userid. We already had an LDAP configuration settings at domain level but I don't know what should I do to achieve this functionality. Please help.

2021-09-27 02:48:12    分类:问答    filenet-content-engine   filenet-process-engine   content-platform-engine