IV91559: METRIC REPORT - RELATED DATA NOT SHOWING RECORDS FOR NON ENGLISH (COUNT IS 19, SHOWS 0 RECORDS IN QUERY)

APAR status

• Closed as fixed if next.

Error description

• Tabular metric report related to a graphic one does not display
  the detailed list of the records:
  The description with images are in the DOC attached. Basically,
  the tabular report does not display the records on the list as
  expected. So customer is not able to select or view the details
  of the records selected.
  Customer had send us a package with 4 metrics reports based on
  triTask/ triWorkTaks :
  cstBNPP - triWorkTask -Nombre demandes intervention Exploitant
  cstBNPP - triWorkTask -Nombre demandes intervention Exploitant
  (tab)  :  this is the two originals ones with some custom fields
  test-cstBNPP - triWorkTask -Nombre demandes intervention
  Exploitant
  test-cstBNPP - triWorkTask -Nombre demandes intervention
  Exploitant (tab) : the same reports without any custom fields
  Using the two last ones :
  1. without applying any filter, if you try to open a form task
  from the tabular report there is error message "An Error
  Occurred. Contact your System Administrator. --
  [MID-3622383736]"
  2. when you try to apply a filter using the start date for
  example, the list of tasks disappears from the tabular reports.
  The issue is that if the first column on a metric tabular
  report is a numeric value with no decimals, the platform is
  trying to handle it as a record id. Since it is not a valid
  record id, an error is encountered and the row is not displayed.
  

Local fix

• The workaround is to either make the first column the System
  Record ID field, or make the first column some other field that
  does not have a numeric value.
  

Problem summary

• The issue was that tabular report display logic was trying to
  create an open record link if the passed in linkedId was
  somethng greater than zero, regardless of it being a valid
  record id. In metric tabular reports, linkedId can be greater
  than zero for any group id whose value is a numeric and not
  necessarily a valid record id. This fix catches
  SmartObjectNotFound exception to ensure all the data displays.
  It also will not create a link, unless linkedId is a valid
  record id.
  

Problem conclusion

• Resolved an issue where data was not showing for metric tabular
  queries, if the first column of the tabular query was a numeric
  value, but not an actual record id. Also resolved with this fix
  is an issue where drill through links were incorrectly showing
  up in the tabular results if the first column was a numeric
  value, but not an actual record id. This is targeted to the
  1h2017 release
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• 999
  

Fix information

Applicable component levels