Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-15691

Assets object search cannot handle an Attribute column, if the attribute name conatains a comma

XMLWordPrintable

      Issue Summary

      Assets allow the attribute's name to include a comma, while it prevents specific characters like colon and semicolon. For example: "First Name, Last Name" is a valid attribute's name.

      The attribute can be added in the object scheme's List view as a column without any issue:

      When trying to add the Attribute as a column to the Assets>Search for objects, the attribute is split at the comma into two columns, and none of the two columns is populated:

      Impact: This behaviour breaks Assets reports/ widgets, if they depend on this filter, e.g. Assets Object Search report.

      Steps to Reproduce

      1. Create an object type
      2. Add a text attribute, use a comma within the attribute's name, e.g. "First Name, Last Name"
      3. Create one object and populate the text attribute
      4. In object Schema > List ciew, click "Columns" and add the text attribute - notice it is showing correctly as its own column and values
      5. Navigate to Assets > Search for objects (object navigator) use any AQL filter to find the object above.
      6. click "Columns" and add the text attribute - notice the columns showing now

      Expected Results

      Similar to List view, the whole attribute name is showing in the column header, including the comma, and the column has values per object

      Actual Results

      Screenshot above - the Attribute name is split into two columns and no value is populating any of these columns

      ...
      

      Workaround

      Instead of a comma, use any other concatenation (but not Colon nor semicolon).

      Versions Tested

      Please confirm all versions that have been tested for this issue, and indicate whether the tested version is affected or not affected, below: 

      Testing Requirements Version Affected Version
      Customers Reported Version 5.17.4 (Yes)
      Most Recent Bug-Fix Release 10.1.2 Y
      Previous Major Release 5.17.2 Y
      Most Recent LTS    
      Previous Supported LTS    
      Other Versions.. 5.17.1 Y
      (Add rows as needed)    

        1. image-2024-11-18-12-56-10-308.png
          211 kB
          Yinon Negev
        2. image-2024-11-18-12-56-45-187.png
          325 kB
          Yinon Negev
        3. image-2024-11-18-13-01-42-813.png
          164 kB
          Yinon Negev
        4. image-2024-11-18-13-02-31-197.png
          44 kB
          Yinon Negev

              b437717b5ac8 Yiwen Zhang
              8cdc82c96fd5 Yinon Negev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: