Notifications

34 views

Description

Time Series report with multiple dataset has the columns wrong sorted monthly when logged in a different language than English and there are 2 or more months where the first letters are identical. For example in French June and July start with JUI (Juin and Juillet respectively).

Steps to Reproduce

1a. Import the report and report layer which are attached.

OR

2a. Create the main report as follows:
Table = Incident [incident]
Type = Time Series
Trend by = Opened
per = Month
Aggregation = Count

2b. Create the Dataset as follows:
Table = Incident [incident]
Type = Time Series
Trend by = Opened
per = Month
Aggregation = Count

3. Run the report you created at step 2a and 2b or the report named 'Test German Order' if you loaded it at step 1 > check the month order.
4. Switch the language to German.
5. Run the report you created at step 2a and 2b or the report named 'Test German Order'if you loaded it at step 1 [ http://localhost:8080/nav_to.do?uri=%2Fsys_report_template.do%3Fjvar_report_id%3Da89662ffdbe5a7009bae1c043996199d%26jvar_selected_tab%3DallReports%26jvar_list_order_by%3D%26jvar_list_sort_direction%3D%26sysparm_reportquery%3Dgerman%26jvar_search_created_by%3D%26jvar_search_table%3D%26jvar_search_report_sys_id%3D%26jvar_report_home_query%3D ] > check the month order

> Expected behavior: The months should be ordered in the right away.

> Actual behavior: Observe that months are not ordered properly: Dez./2017,  Jan./2018, Marz/2013, Mai/2013, Marz/2017 (= Dec 2017, Jan 2018, March 2013, March 2017)

Workaround

This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this form to be notified when more information will become available.

Note that appropriate translated labels for 3 letter month labels in the given locale language should fix the problem, but the right labels as known by the JVM have to be used.

For example "Aug" must be translated as "Ago" in italian.

"Sep" as "Set", and so on.

If Aug is translated to "Ago." (4 letters) or "Sep" to "Sett" the decoding will not work and August and September points will not be sorted correctly in case of multiple datasets.

Indeed, this workaround will not work for languages where two different month names start with the same 3 letters, e.g. French June and July both get MMM code set to JUI


Related Problem: PRB1316333

Seen In

Kingston Patch 11
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3

Intended Fix Version

Madrid Patch 9
New York Patch 4
Orlando

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-11-05 03:14:53
Published:2019-10-29