AnsweredAssumed Answered

Collaboration Documents and External File Store:  How can you tell if a doc is in the external file store versus the database?

Question asked by JennRinella on Jul 14, 2014
Latest reply on Jul 14, 2014 by navzjoshi00

As an OnDemand customer, I know that I have an external filestore.

 

However, I also have a large set of custom attachment attributes.

 

How do I figure out where the items are stored?

 

I am already using this query to see what is the CLB:

 

select files.created_date,

            files.name,

            files.mime_type,

            files.file_created_date,

            folders.path_name||'/'||folders.name,

            ver.version_number,

            (select first_name||last_name from cmn_sec_users where id=history.last_updated_by) modified_by

from     clb_dms_files files,

            clb_dms_folders folders ,

            clb_dms_versions ver,

            clb_dms_histories history

where folders.id=files.parent_folder_id

and   ver.file_id=files.id

and   ver.id=history.version_id

order by file_created_date desc

 

Thank you,

Jenn

 

JENN RINELLA
Technology Architect III
RNAM OP PST&M BUS TRANSFORMATION TOOLS

 

Ericsson

Office:  +1 972-583-6091 | Mobile:  +1 972-330-9797
jenn.rinella@ericsson.com | www.ericsson.com

Outcomes