nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Database tables for contents and documents/files

jaka_prana

Hi guys,

I was wondering, to which table does Alfresco WCM stores our documents/files and web contents? I need to know because I need to index these files and contents from another web app which is using the WCM repository. And do these tables have a date columns? I need this column to know the last modified date of the files/content.

Thanks.

Find more posts tagged with

Comments

pawel_rzeszowsk

Hello jaka_prana,
Alfresco doesn't store content in relational database. Alfresco uses it's own propetriary file system to store it. You can take a look in the folder ALFRESCO_INSTALATION\alf_data\contentstore. It is the place when after default installation content files are stored.
Best Regards,
Pawel Rzeszowski.

mrogers

The content store is irrelevant.

However the database implementation is private to Alfresco.

There's various APIs available to list files and modification dates.

sara

Hello,
I have three question:
1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
2.How can I find a specially content versions?
3.How can I get back up from versions of the contents?
Thanks

mrogers

Could you have a go at rewording
"specially content versions"
"How can I get back up from versions of the contents?"

1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
Database and File system. The implemention should not concern you,

You probably need to use the version service.

sara

Could you have a go at rewording
"specially content versions"
"How can I get back up from versions of the contents?"

1.Do the versions of the file is stored in the file system?(alf_data\contentstore)
Database and File system. The implemention should not concern you,

You probably need to use the version service.

Thanks for your reply
1.In which directory do versions of folders store?
2.How can I find the version of a specified folder ?
3.How can I back up from versions of folders? I want to move our alfresco in another computer I should be able to back up from current and restore in new one,I did it but there is no versions of folder in new system, that's why I made these question?
thanks in advance

imed

hey i m just new with alfresco please is there a way to store a database schema and it's content in the repository of alfresco