Hi Team,
I have a custom table u_sip with a custom String field u_invoice_no (Invoice No.).
Requirement:
When searching using the value of 'Invoice No. (e.g., 14567)' in the Global Search, the corresponding SIP record should be returned.
Current Behavior:
Searching by the record Number (e.g., SIP0001002) returns the record successfully.
Searching by the custom field value (e.g., 14567) returns no results.
What I have verified:
The custom field type is String.
A database index has been created for the field.
The index exists in the sys_index table.
However, the index is not visible in the table's Database Indexes related list.
I also could not find any Searchable or Text Search option on the dictionary entry for this field.
Environment:
ServiceNow Zurich
Custom table: u_sip
Questions:
What configuration is required to make a custom String field searchable in Global Search?
Is creating a database index sufficient, or are additional configurations (such as text indexing or search source configuration) required?
Why would an index appear in the sys_index table but not in the table's Database Indexes related list?
Is there any step required to rebuild or regenerate the search index after creating the database index?
Any guidance or best practices would be greatly appreciated.
@Ankur Bawiskar
