Agile Central - Search: can not search custom fields of type Integer

Products

• CA Agile Central On Premise (Rally)
• CA Agile Central SaaS (Rally)

Issue/Introduction

Agile Central's main search function does not work for custom fields of type "Integer".

Here are two fields:
Nexus# - Type is: Integer
NexusString# - Type is: String.

We have a Feature that has both these fields populated whereas Nexus# = 100101 and NexusString# = 100102.

You can see that we can search for the NexusString# but we can not search for Nexus#.

<Please see attached file for image>

<Please see attached file for image>

<Please see attached file for image>

Searching of NexusString# (value is: 100102) works:

<Please see attached file for image>

<Please see attached file for image>

Searching for Nexus# (value is: 100101) does not work:

<Please see attached file for image>

<Please see attached file for image>

 

Cause

Agile Central's main search function uses: Elastic Search. 
This search works on Strings and Texts , but does not work on Integer fields.

Environment

Release:
Component: ACSAAS

Resolution

1. The easier solution is a workaround. You can use the Work Views where the search for Integer does work, take a look:

<Please see attached file for image>

<Please see attached file for image>

2. If you must get the main search function (on the main Agile Central screen) to work then you'll need to use a String field instead of the Integer. If you already have the Integer field in place then you'll need to create a new String field, then copy the data from the Integer to the new String field, then hide the Integer field and not use it any longer.

You can use the Field-Copier community app to copy the data from the Integer to the String field:
https://github.com/RallyTechServices/field-copier

Additional Information

More on custom fields: https://help.rallydev.com/create-custom-fields
More on types of fields: https://help.rallydev.com/create-custom-fields#types