Why can’t I find tickets when searching a numeric custom field with a very large value?

Question

Why search does not return expected results when I search using a very large value in a numeric custom ticket field?

Answer

Zendesk search supports numeric custom field values only within the following range:

-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

If a numeric field contains a value outside this range, search for that value may not return expected ticket results.

This limit is a numeric value limit, not a character limit. This behavior is due to a limitation of the search backend.

For example, if you need to store and search identifiers larger than this range, consider a text field instead of a numeric field.

Use numeric fields for values that fit within the supported 64-bit signed integer range. Use text fields for very large numeric identifiers that you must search.

To learn more about searching for tickets, see Searching Zendesk Support data.