Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-2867

Pie chart return error when a column use integer number

    XMLWordPrintable

Details

    • Release Notes
    • CR1
    • +
    • Workaround Exists
    • Hide

      As this error occurs only with integer the workaround consists in cast the type to string before use in the chart.

      1. Create dataset (using MySQL syntax here, but similar syntax should be available for other DBs):
      select id, processInstanceId, processInstanceDescription, convert(slaCompliance, char(50)) as slaComplianceString from ProcessInstanceLog

      2. Create a new page with a pie chart, use column 'slaComplianceString' for Categories

      Show
      As this error occurs only with integer the workaround consists in cast the type to string before use in the chart. 1. Create dataset (using MySQL syntax here, but similar syntax should be available for other DBs): select id, processInstanceId, processInstanceDescription, convert(slaCompliance, char(50)) as slaComplianceString from ProcessInstanceLog 2. Create a new page with a pie chart, use column 'slaComplianceString' for Categories
    • Hide

      1 - Create a dataset

      • Administration -> Data Sets
      • New Data Set -> Execution Server
      • Data:
        Name: getAllProcesses
        DS: ${org.kie.server.persistence.ds}
        Server configuration: default-kieserver (or any other running kie-server)
        Query Target: PROCESS
        Query: select * from ProcessInstanceLog
      • Test & Save the new dataset

      2. Create a page

      • Menu -> Pages -> New Page
      • Expand 'Reporting'
      • Drag a Pie chart on to the page
      • Select the 'Data' tab, set:
        Dataset: getAllProcesses
        Categories: slaCompliance ==> THIS IS THE IMPORTANT STEP, the error only shows up when selecting specific columns for the category
        Series: processInstanceId
        Aggregate function: Count
      Show
      1 - Create a dataset Administration -> Data Sets New Data Set -> Execution Server Data: Name: getAllProcesses DS: ${org.kie.server.persistence.ds} Server configuration: default-kieserver (or any other running kie-server) Query Target: PROCESS Query: select * from ProcessInstanceLog Test & Save the new dataset 2. Create a page Menu -> Pages -> New Page Expand 'Reporting' Drag a Pie chart on to the page Select the 'Data' tab, set: Dataset: getAllProcesses Categories: slaCompliance ==> THIS IS THE IMPORTANT STEP, the error only shows up when selecting specific columns for the category Series: processInstanceId Aggregate function: Count
    • 2020 Week 40-42 (from Sep 28), 2020 Week 43-45 (from Okt 19), 2020 Week 46-48 (from Nov 9), 2020 Week 49-51 (from Nov 30)

    Description

      When trying to create a Pie chart, in a Page, using a dataset that has a column with an integer value is returned a JS error.

      Attachments

        Activity

          People

            abkuma abhishek kumar
            rhn-support-roribeiro Rodrigo Ribeiro (Inactive)
            Savitha T Jose Savitha T Jose
            Savitha T Jose Savitha T Jose
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: