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

Document ID : KB000107055
Last Modified Date : 19/07/2018
Show Technical Document Details
Issue:
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#.

User-added image

User-added image

User-added image

Searching of NexusString# (value is: 100102) works:
User-added image

User-added image

Searching for Nexus# (value is: 100101) does not work:
User-added image
User-added 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.
Resolution:
1. The easier solution is a workaround. You can use the Work Views where the search for Integer does work, take a look:

User-added image
User-added 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