When a trend report is run against the 'Date/Time' field, the data is sorted in alphabetical order and not in numerical order.

Steps to Reproduce

  1. Login as administrator in an instance based on Oracle db.
    2. Go to Reports > Create New .
    4. Switch to the Classic UI.
    5. Select the below options:

    Table: Incident
    Type: Trend
    Group By: Active
    Trend By: Opened
    Per: Hour
    Aggregation: Count
    No. Groups: System Default (12)

    6. Run the report. Observe the output data appears in alphabetical order, i.e.: 1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,3,4,5,6,7,8,9.


This problem is under review and targeted to be fixed in a future release. You can Subscribe to this article to receive notifications when more information will become available.

Instances based on MySQL database do not have this issue.

Related Problem: PRB1303260

Seen In

Jakarta Patch 9

Fixed In

London Patch 10
Madrid Patch 8
New York

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-08-21 14:17:09