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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s