Question
Last activity: 15 Feb 2017 7:23 EST
Localize value through function alias
Hi!
We had english values in column and we need to get localized values in Report Definition.
So i've tried to convert this values using Function Alias. In FA rule i placed code:
CASE {1}
WHEN {1} THEN '<%=tools.getLocalizedTextForString(".pyCaption", {1})%>'
ELSE ''
END
But the problem is that I unable to save rule because of "{1}" inside JSP function.
How can i pass column value in JSP function?


Pegasystems Inc.
IN
Hi,
Yes, but the this Report Definition used in section on grid and we need to have Filtering option in column heading.
The problem is that if we have english values in clipboard, Filtering option works only with that values, not localized.
According to requirements Filtering option must work with localized values, so that's why i'm tryng to get localized values from Report rather than localize it through Filed Values.


Pegasystems Inc.
IN
Hi Arseniy,
You may go through the following Support Article:
https://pdn.pega.com/support-articles/options-filter-list-not-localized
In order to get the localized values, you will have to change the control for the column to "Inherit from property" in the Advanced option.
Regards,
Evita.


Pegasystems Inc.
IN
Hi Arseniy,
I got little confused with your reply to Evita, you are trying to implement the localisaiton of filtering option. It means that,
When you have for ex, if you have japanese locale set. The column should be available filtering the data based on japanese values in the tuple of the report definition? Is it? If yes, we should understand that the report definition returns values from database which was persisted earlier/during the process of application either by user input or OOTB enteries.
These values are stored as literal phrase. Thus, How you can have localised text of Japanese to filter the option available on English text?
Secondly, are you getting any error in logs or screen during filtering of localised text by some implementation at your end?
If you are getting weired(like ¿¿¿¿) characters instead of localised values. I would asked to check the character set of the database.
I am not sure, if I am rightly co-relating your issue with this one :- https://pdn.pega.com/support-articles/problem-filtering-section-localization-report-definition . If you are facing the similar issue for same version, we can provide you this Hfix, again i will say I am not sure about it.
Regards,
Asif
Hi,
As i said earlier, we store english values in column. These values localized on section through field values. But when we try to filter them on section and typing russian string, we unable to filter results, because in clipboard this values stored in english version.
So the idea was to get russian values in RD through function alias. This way we can filter because this values will be stored in russian version in clipboard.
Hi,
in the column format use "pzGetLocalizedValue" for each columns in Report definition this will fetch the localized values, you can create the field values so that based on the locale language the report définitions colum text displays in the locale language,
Hi ArseniyS,
Thank you for posting your query on PSC.
To localize values in report definition, you can override the field values of the messages and text displayed by the report.
Regards,
Evita.