creating table in database alfresco and Querying Data File Creation

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.

caiuafranca

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 know how to help me?

afaust

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