creating auto-increment data for any table, there is a gap in the increment term.

Sandeep _
Tera Contributor

‎02-26-2024 07:50 PM

Whenever we are creating auto-increment data for any table, there is a gap in the increment term. For example, if a 001 record has been created, then after that 003 record has been created but a 002 record has not been created there, so what will be the solution for this, in the current table on which auto increment is done is Software Entitlement table.

0 Helpfuls
  • 288 Views
1 REPLY 1

AakashG2703
Mega Guru

‎04-02-2024 02:20 AM

Hi @Sandeep _,

Hope you are doing well.

 

Proposed Solution

As you are currently using or referring to "Software Entitlement (alm_license)" Table. So, I chose the same table and enable the checkbox of an "Auto-Increment" option on the table to enable the feature of an Auto-Increment the Number on my Personal Developer Instance and created 3 Demo Records and It seems to be working fine for me. Attaching screenshots for the reference.

 

AakashG2703_1-1712048981696.png

 

Suggestions: -

  1. Please be advised to double check or make sure that the 2nd record that you are referring was not deleted by any chance. To check, you can navigate to All > System Definition > Deleted Records(sys_audit_delete) Table and search for that particular record. If this is so, you will be having an option to Rollback from the same table.
  2. While creating any new record in any table, a new Number Field gets added and visible on the form as mentioned below. From where you can check and validate before and after record gets saved.

AakashG2703_0-1712048803886.png

 

If you find this information/knowledge/solution helpful, please don't forget to mark my solution and reply as helpful and accepted.

 

Thanks ‌‌:)

Aakash Garg

ServiceNow Developer

0 Helpfuls