Does anyone know what table they are in, I need to reset them once a year.
We, when a record is generated with Autonumber, we add to the Autonumber field, the year. So we need each year to have a new numbering, starting with 1.
The AutoNumber value is stored in a Sequence in the database (Postgres Sequence for cloud instances). For example, you can get the last value of a sequence using this query: SELECT last_value FROM "Contact_RId_seq".
To reset a sequence, you can use the following query: ALTER SEQUENCE "seq_name"
RESTART WITH 0;
I have not visible this table from a Creatio Cloud instance, I've enabled an autonumber field in contacts, for example, and not available the table mentioned by @Mohamed, see it
1- You can run a custom SQL query from a Task Script. 2- No, you don't have access to the sequences. 3- The sequence name is identical to the column UId. You find it in the source code tab of the Object in Advanced settings.
Once you add the autonumber column, you'll need to get the UId for the column. You can open the object then select "Open metadata" under the Actions menu, the find the column and get the Guid for the UId.
That is the name of the sequence in the database. If needed, you can use that to get the next sequence value using this where the guid is the UId for the column (for Postgresql):
Yes, for now to reset the value it requires the database update (either by Clio, SQL Executor, or asking support to update the value). I do hope we'll get a UI to manage that at some point. The prefix is also set at the object level now, instead of a system setting - so that now requires an object publish to change rather than updating a setting.
Yes, unfortunately at this moment there is no possibility to reset sequence using No Code. But you can always contact support, and we will be happy to do it for you. We have created a request to the responsible development team to add this functionality in future releases.
There's no direct way to reset the auto number field.
It's based on the Sequence object in the DB, you can run the script that will restart the sequence. For example, you could create a business process that will execute a script that will restart the sequence.