creating table in database alfresco and Querying Data File Creation

[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