Uploaded image for project: 'SR for Jira - Development'
  1. SR for Jira - Development
  2. SRJIRA-5804

Dashboard Gadget fails to show Database Picker vales more than 43 characters

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Duplicate
    • 6.34.0
    • None
    • Script Fields
    • None
    • 1.6

    Description

      When using Issue Statistics or Two Dimensional Filter Statistics in dashboard, database picker values with more than 43 characters will display incorrect result or rendering errors.

      Steps to Reproduce

      Provide a detailed step-by-step process to reproduce the problem.

      1. Create a select list with options, 43 characters long, 44 characters long and 48 characters long like so:

       

      2. Create a database picker that shows all the options value from this select list:

      // Retrieval/validation SQL
      select ID,customvalue from customfieldoption where customfield=10300 and id = cast(? as numeric) order by customvalue asc
      
      // Search SQL
      select ID,customvalue from customfieldoption where customfield=10300 and lower(customvalue) like '%' || lower(?) || '%' and disabled = 'N' order by customvalue asc 

      3. Make selections in some issues.

      4. Display it in dashboard gadget: Issue Statistics or Two Dimensional Filter Statistics.

      Expected Behaviour

      Values are displayed correctly.

      Actual Behaviour

      Value missing (character >= 44) or rendering error (character >= 48) is shown like so:

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mlim Max Lim
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: