creating table in database alfresco and Querying Data File Creation

caiuafranca — Tue, 04 Feb 2014 14:25:26 GMT

good day, I am using version 4 of alfresco community, and I need to do the following thing: create a table in database alfresco with sequential numbers; when you create a document or drag it to the folder and file will be renamed by the sequential numbering of the table; anyone ever needed it or kno

Re: creating table in database alfresco and Querying Data File Creation

afaust — Wed, 05 Feb 2014 01:00:00 GMT

Hello,

you actually do not need to create a new table in the Alfresco database for a sequential number generator. You can use the global attribute storage exposed via the AttributeService to manage the trivial data for this.
We have implemented a couple of customer projects using the AttributeService as a basis for unique / sequential ID generators.

Also, it can be quite an effort to add a new table properly (with all the transaction handling, update / version management). I only ever once (on an older Alfresco version) had the need to do this in all the projects I worked on. (<a href="https://issues.alfresco.com/jira/browse/ALF-10838">the JIRA ticket of ye olde use case</a>)

Regards
Axel

topic Re: creating table in database alfresco and Querying Data File Creation in Alfresco Archive

creating table in database alfresco and Querying Data File Creation

Re: creating table in database alfresco and Querying Data File Creation