Rally: Jira Adapter - Need assistance passing a null value from cfg_obj_fld_map

Products

• Rally SaaS

Issue/Introduction

We are trying to achieve the following behavior in our Rally/Jira mapping for the Preliminary Estimate field, we are planning on having distinct values for Feature sizing and Epic sizing, but only want to sync Feature values:

Rally                            Jira
-------                            ----
F - XS                          XS
F - S                            S
F - M                           M
F - L                            L
F - XL                          XL
F - XXL                       XXL
E - XS                        (null)
E - S                           (null)
...

When we try to use the cfg_obj_fld_map table to do this, leaving the target value column empty or not including an entry for the target value results in the integration trying to push the exact value of the field, which ultimately fails. If we put any text in that box it tries to push the text in quotes, we have tried all of the following potential values that we thought could result in a null value and haven't seen success, below are the values tested and what they were mapped to in our dev environment.

XREF ID: caagc-57497

ReactionID - Epic Size - Value Used

87821 - XXL - " "
87822 - XL  - null
87823 - L   - "None"
87824 - M   - -1
87825 - S   - ""
87826 - XS  - None
87827 - (CLEARED FROM JIRA TO VERIFY NULL EXPECTED)
87828 - XXL - null field
87829 - XL  - \x0
87830 - L   - \0
87831 - M   - "defaultValue"
87832 - S   - defaultValue
87833 - XS  - \z
87834  - XXL - 'null'
87835 - XL  - $null
87836 - L   - \null
87837 - M   - \$null
87838 - S   - value removed from cfg_fld_obj_map

How would we go about mapping a set of values to null on this table?

Environment

Release : SAAS

Component : AGILE CENTRAL

Resolution

The user used nil as the value to pass