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

Add option to remove the concatenator completely when importing objects

XMLWordPrintable

    • 1
    • 2
    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Problem definition

      By default, when importing objects and concatenating values from multiple datalocators, the default concatenator is space. However, it is not possible to ignore the concatenator and not use any value (e.g. so that "ABC" and "1234" together become "ABC1234").

      Suggested resolution

      Add option to disable concatenator completely, so the values are concatenated without any character in between.

      Workaround

      • Create the desired value right on the source side, example:
        • If using database as a source, create a new column that contains concatenated values from other desired column values (without space), then use that new column as a datalocator.
        • If using CSV as a source, open the file in Excel (or other spreadsheet editor) and use CONCATENATE function to generate a desired value in a new column, then use that generated column as a datalocator.
      • Use Insight Automation rule, that would execute a Groovy script which would find if there is a space in the object attribute and remove it.

          Form Name

            [JSDSERVER-8622] Add option to remove the concatenator completely when importing objects

              Unassigned Unassigned
              mfilipan Marko Filipan
              Votes:
              3 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated: