Support Article
Localization issue for columns with table joins in pie chart
SA-32773
Summary
Localization issue for Pie chart on portal- Labels are not getting translated from English to French.
Error Messages
Not Applicable
Steps to Reproduce
- Create Report Definition.
- Use table joins.
- Use the columns of joined table in query.
Root Cause
When there are joins in report Definition, localization for the columns which are joined isn't happening
Resolution
1. Create required Field values in @baseclass Application ruleset.

2. Create New Control “LocalizedControl” (+Create -> User Interface -> Control)
3. Put below code in control named as “LocalizedControl”
Code Snippet:-
<% if(tools.getStepPage().getStringIfPresent(".pxObjClass", false) == null || "".equals(tools.getStepPage().getStringIfPresent(".pxObjClass", false))) tools.getStepPage().getProperty(".pxObjClass").setValue("@baseclass"); %>
<%= tools.getLocalizedTextForString(".pyCaption", tools.getActiveValue()) %>
4. Use above created control in Format “LocalizedControl”.

Published January 24, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.