Hi,
I already delete record in list view but ID(automate number) doesn’t reset.
Is there any ways to reset automate number/
Best answer by TinTex
View original
Could you provide some additional detail?
Perhaps the delete button was only configured to remove the record in the list view, but that change was not deleted or saved to the backend. You can try creating a simple SmartObject, generating a editable list view, and looking at the rules to understand how it is usually implemented.
+3
Could you provide some additional detail?
Perhaps the delete button was only configured to remove the record in the list view, but that change was not deleted or saved to the backend. You can try creating a simple SmartObject, generating an editable list view, and looking at the rules to understand how it is usually implemented.
I had SmartObject, List view, editable list view. But I haven’t set the rules in editable list view. Could you provide rules I should set in the editable list view?
Please see below:
This tutorial will walk you through generating an editable list view, of which you can inspect the rules generated to understand how it is implemented on an editable list view.
If this is SmartBox the number will continue to increment as it is an Identity field in the database https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql-identity-property?view=sql-server-ver16
To reset the auto number you will need to ask a dba to truncate the SmartBox table in the K2 database and then call
DBCC CHECKIDENT('TableName', RESEED, 0)
Userlevel 5
+20
Hi
Did any of these replies resolve your question?
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.