ECM

how to update custom metadata field from another look up table at UCM?

select did ,XCIVILRECORDNUMBER, lookup.CIVILNUMBER,XEMPNAME,name from DEV_OCS.DOCMETA , EMPLOYEEANDCIVILNUMBERS2 lookup where lookup.CIVILNUMBER=DOCMETA.XCIVILRECORDNUMBER and XEMPNAME is null create table DOCMETA_bckup as select * from DOCMETA commit update DOCMETA dm set XEMPNAME=(select name from EMPLOYEEANDCIVILNUMBERS2 where CIVILNUMBER=dm.XCIVILRECORDNUMBER) where XEMPNAME is null commit

ECM · idoc script

slider with idoc script

<div id=”da-slider” class=”da-slider”> <!–$loop SearchResults–> <div class=”da-slide”> <h2><a class=”<!–$ssClassName–>-result” <!–$ssColorExtra–> <!–$ssMouseExtra–> href=”<!–$SearchResults.ssUrl–>”><!–$eval(ssRowLink)–></a></h2> <p> <!–$xComments–> </p> <a href=”<!–$SearchResults.ssUrl–>” class=”da-link”>إقرأ المزيد</a> <div class=”da-img”><img src=”<!–$SearchResults.URL–>” width=”592″ height=”230″ alt=”image01″ /></div> </div> <!–$endloop–> <nav class=”da-arrows”> <span class=”da-arrows-prev”></span> <span class=”da-arrows-next”></span> </nav> </div>

ECM · ODC · ODDC

create ODC folder View with folder framework at dev_ocs schema

create view ODC_FOLDER_VIEW as select “FFOLDERGUID”,”FPARENTGUID”,”FFOLDERNAME”,”FINHIBITPROPAGATION”,”FPROMPTFORMETADATA”,”FISCONTRIBUTION”,”FTARGETGUID”,”FAPPLICATION”,”FOWNER”,”FCREATOR”,”FLASTMODIFIER”,”FCREATEDATE”,”FLASTMODIFIEDDATE”,”FSECURITYGROUP”,”FDOCACCOUNT”,”FCLBRAUSERLIST”,”FCLBRAALIASLIST”,”FCLBRAROLELIST” from FOLDERFOLDERS where FPARENTGUID=’451979EEE81E7B427F69F8998787BE3F’   check with select * from ODC_FOLDER_VIEW  

DAM

What is the digital asset management?

What is the digital asset management? Oracle WebCenter Content’s digital asset management capability allows organizations to store, find, view, and use digital assets and rich media quickly and easily. Content, collateral, and individual asset items can be made available instantly in the appropriate formats for use on Web sites, in print materials, or in other… Continue reading What is the digital asset management?

ECM · UCM

How to Update Metadata of documents through DB at UCM(webcenter Content) ?

let’s imagine the following scenario you have different employee profile for different Document types of each employee such sanctions,vacations, services,certificate ,.. etc and every UCM profile has 2 metadata “civil number of employee” , and ” employee name” and title which have specific signature as follow “type of Documnet of ********** ” where the position… Continue reading How to Update Metadata of documents through DB at UCM(webcenter Content) ?