330 views

Description

Using a special character (such as a comma, or an at symbol @) in the value field of a sys_choice record prevents templates from being applied to a form successfully.

Catalog UI policy conditions are not saved if the condition value includes a comma.

This problem is specifically in regard to CHOICE fields in templates. It does not apply to or fix issues with commas appearing in display values for items being added to a watch list.

Steps to Reproduce

  1. Create a new sys_choice record and set the following:
    • table = [incident]
    • element = subcategory
    • label = Cisco Systems, Inc.
    • value = Cisco Systems, Inc.
  2. Create a new sys_template record and set the following:
    • table = incident
    • template = Subcategory | Cisco Systems, Inc.
  3. Click Save.
    When you attempt to save the record, the template value reverts to Subcategory | -- None --.

If you perform a Show XML on the template, the value is shown associated to the field, but:

  • the display value is display=" "
  • it looks like the template does not have a value associated to it
  • the template does not work when you try to apply it


 

Alternate usa case:

  1. Go to cmdb_ci_acc.list Create New

  2. Create a new accessory called "Gadget (for example, for a smartphone, tablet, etc.)" and save

  3. Go to Variable>Create New.

  4. Provide the following field values:

     FieldValue
     TypeLookup select box
     Cat itemApple iPad 3
     Lookup from tableAccessory
     Lookup value fieldName
  5. Go to Catalog UI Policies>Create New.

  6. Provide the following field values:

     FieldValue
     Applies toA Catalog Item
     Catalog itemApple iPad 3
     Catalog Conditiongadget>is>Gadget (for example, for a smartphone, tablet, etc.)
  7. Save the policy. Because of the commas in the condition, it is not saved.

 

Workaround

This problem was fixed in Istanbul and later.

As a workaround on earlier versions, use a reference lookup instead of a choice list.


Related Problem: PRB649956

Seen In

Eureka Patch 10
Fuji Patch 10
Fuji Patch 7 Hot Fix 2
Geneva Patch 4

Fixed In

Geneva Patch 8
Helsinki
Istanbul

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-19 00:46:08
Published:2018-03-19