How to reset to first number of using sequential text pattern?

Dear DHIS2 member,
I use sequential function in text pattern, it is working fine.
and i want to reset to first number sequence. any way to make it work?

thanks
channara

Hi @Channara ,

I am not sure I understand what you mean by reseting the first number sequence. Do you have a sequence that has already been used, and you want to start it over from 0? That would not be possible assuming you have used any of the values already, since these values needs to be unique.

Hope that clears it up

2 Likes

HI @Stian ,
even I removed TEI? so we cannot reset it?
thank you
channara

If you want to reset it, without encountering issues, you would have to remove all the values for the attribute first :slight_smile: You can do this in the database, but unless you are sure this is what you want to do, I would not do it :slight_smile:

In the database, you can delete from trackedentityattributevalue where trackedentityattributeid = <id of the attribute).

1 Like