Query's with localized attributes with Jaspersoft

[Former Member]

We are generating reports with Jaspersoft Studio, some query´s are making reference to localized attributes from de model Category At the moment to execute this command SQL, doesn´t return results

SELECT {code}, {name} FROM {Category} where {name} = ‘1’;

How can we handle the localized attributes on the querys?

[Former Member]

moved from the yaas space

[former_member582940]

Hi Mario,

you can localize the attributes in impex using the following syntax:

{name[en]}