Is there any way to reset sequential value (i.e,to 1) for every process execution.
I agree with Pavan: the Sequential Values are intended to be an ever-increasing counter.
If your counter only needs to live within the context of a map, I would recommend using the Line Item Increment function as you observed. If you need the counter elsewhere or across branches, I would recommend maintaining your own counter using a Process Property. You can use a little scripting or Get Property > Math Add > Set Property functions to increment as needed.
There is no direct way for sure.
I am not aware of doing it through any scripting methods. May be someone from the boomi team can better update on this.
Unfortunately counters are not available through API to reset this values for each execution.
You can reset this counter if needed by editing the value in the Atom Counters dialog on the Atom. This value is also stored in the counter file in the counter directory on the Atom.
Built-in counter that automatically increments for each occurrence of the source record. The Key Name entity stores the latest value so future process executions will continue to increment by 1 from the last result. Each counter is an ever-increasing value. Counter values are stored per Atom. If a given process is attached and deployed to a different Atom, the next sequential value will be different. Counters can be viewed and reset in the Atom Counters dialog.
thank you for your suggestions. one way to achieve this by using Line Item Increment. so for every execution it starts with initial value.please suggest if we can have any other alternatives.
Please note this involved a locally installed Atom.
I had a customer request that email subjects and their attached files contain sequential, increasing ID values, with the expectation that they reset every day.
I was able to do this by calling a batch file via the system command shape that deleted the 2 specific .ctr files in the counter folder of the Atom install directory used in the process during the first execution of every day (determined by a decision against the last run date)
This caused the sequential value counter files to be regenerated and start counting from 1.
Correct! I have faced the same issue earlier and later on resolved by a batch script on place in system command to delete counter files of Atom directory.
This info is really helpful. I tried some hit and trials to achieve this but couldn't make it work. Can you please guide how to achieve this using the batch and program command shape?
The batch file simply changes the directory to the appropriate atom/counter directory you need to work with and deletes the specific .ctr files created for the process.
cd "C:\Program Files\Boomi AtomSphere\Atom - ATOM01_Production\counter"del 945DocID.ctrdel 945MailID.ctr
cd "C:\Program Files\Boomi AtomSphere\Atom - ATOM01_Production\counter"
del 945DocID.ctrdel 945MailID.ctr
The program command simply calls the batch file with the full file path on the local Atom.
thanks a lot for your help on this.
Retrieving data ...