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

book

Article ID: 107055

calendar_today

Updated On:

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>

User-added image

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

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

<Please see attached file for image>

User-added image

<Please see attached file for image>

User-added image

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

<Please see attached file for image>

User-added image

<Please see attached file for 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.

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>

User-added image

<Please see attached file for 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

Attachments

1558699202119000107055_sktwi1f5rjvs16jmp.png get_app
1558699200300000107055_sktwi1f5rjvs16jmo.png get_app
1558699198664000107055_sktwi1f5rjvs16jmn.png get_app
1558699197036000107055_sktwi1f5rjvs16jmm.png get_app
1558699195112000107055_sktwi1f5rjvs16jml.png get_app
1558699193270000107055_sktwi1f5rjvs16jmk.png get_app
1558699191561000107055_sktwi1f5rjvs16jmj.png get_app
1558699189694000107055_sktwi1f5rjvs16jmi.png get_app
1558699142536000107055_sktwi1f5rjvs16jmh.png get_app