Want to add a field in Database Index. Unable to find it in Slush bucket.

[Abeer-khan]

Hello Experts,

I have created a custom table and custom fields in that table and I wanted to add indexes in that same table. I was able to get all the required indexes (as they were custom) expect the created field which is ootb. How to get this Created field in the Database indexes, Index creator Slush bucket in the Available options?  Please advise. Thank you.

[Community Alums · Accepted solution]

The Created field is an out-of-the-box (OOTB) field that is automatically created on all ServiceNow tables. It is a system-managed field, which means that you cannot create an index on it yourself. However, you can request that ServiceNow create an index on the Created field for you.

To do this, you need to contact ServiceNow Support and ask them to create an index on the Created field for your custom table. They will need the following information from you:

• The name of your custom table
• The name of the Created field
• The reason why you need an index on the Created field

Once you have provided this information to ServiceNow Support, they will create an index on the Created field for your custom table.

Here are the steps on how to request an index on the Created field:

1. Go to ServiceNow Support: https://support.servicenow.com/.
2. Click on the "Contact Us" button.
3. Select the "Technical Support" option.
4. Select the "Indexing" option.
5. Enter the following information:
   • Your ServiceNow username
   • Your ServiceNow password
   • The name of your custom table
   • The name of the Created field
   • The reason why you need an index on the Created field
6. Click on the "Submit" button.

ServiceNow Support will then create an index on the Created field for your custom table.

Here are the steps on how to check if the index has been created:

1. Go to System Definition > Tables & Columns.
2. Find the table that you created the index for.
3. In the Index creator Slush bucket, look for the Created field.
4. If the Created field is listed in the Index creator Slush bucket, then the index has been created.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,

Kaustubh Kulkarni