Functionality of 'Get Next ID Fill With Pad Char' Step

SivaKumar

I am using 'Get Next ID Fill With Pad Char' step in my flow and the current setup for the length is 2. For example my data is already at 99. Will the next ID reset to 00? Below is the screenshot of the current setup.

Also, can we reset the numbering to go back to 00? For example we want to reset the number each month.

bharathkumarneeli

Hi,

The IDs should continue past 99 without any problems. (The number will be three digits long instead of 2) If you would still like to reset the number each month, you are required to use an SQL query to do so:

ALTER SEQUENCE <Prefix_sequence>

RESTART WITH <Number to reset to>

For example, if the prefix is "ID", and you're trying to reset the IDs to 0, the query would be:

ALTER SEQUENCE ID_sequence

RESTART WITH 0

You can run this query as a scheduled job every month using the Raw SQL Step.

Let me know if you have any other questions.