Hello, friends! 

Question about localization of BIRT reports for Maximo. 

How do u manage it?

I know a few ways.

for content:

1. For each language use separate table rows that was fetched from DB in SQL query (itemDescEn, itemDescDe and etc) and set visibility based on language that is setted in mxReportScriptContext.getLanguageCode() 
2. in script use registerDataTranslation()

But for labels translation there is not so easy. 

Yes, we can use here properties files (here is an example Localization of BIRT report: Need sample example report and guideline 

or the same way for each language use separate table rows with static values for each language 

But anyway, in the case when we want to use actual object attribute's titles from Maximo, how i understand it will always requires to update report design or properties files. 

So found that myself only working solution is always to add extra dataSet, which will query attribute titles from maxatribute and translate it  (registerDataTranslation or just fetch for each lang in separete column) and then put it in layout binded each element 

So, the questions are: 

1. Does Maximo dynamically update properties for birt reports when providing database changes? How I understood - no.
2.  How do u manage it ?

So, after small investigation, looks like using registerDataTranslation for content is not the best solution, because it generates for each translation separate sql like 

select description from l_TABLE where langcode = ? and ownerid = ?

for 5000 records and 3 translateable columns, it is 15k fast, but extra queries. 

What community think about it?

Hello, friends! 

Question about localization of BIRT reports for Maximo. 

How do u manage it?

I know a few ways.

for content:

1. For each language use separate table rows that was fetched from DB in SQL query (itemDescEn, itemDescDe and etc) and set visibility based on language that is setted in mxReportScriptContext.getLanguageCode() 
2. in script use registerDataTranslation()

But for labels translation there is not so easy. 

Yes, we can use here properties files (here is an example Localization of BIRT report: Need sample example report and guideline 

or the same way for each language use separate table rows with static values for each language 

But anyway, in the case when we want to use actual object attribute's titles from Maximo, how i understand it will always requires to update report design or properties files. 

So found that myself only working solution is always to add extra dataSet, which will query attribute titles from maxatribute and translate it  (registerDataTranslation or just fetch for each lang in separete column) and then put it in layout binded each element 

So, the questions are: 

1. Does Maximo dynamically update properties for birt reports when providing database changes? How I understood - no.
2.  How do u manage it ?

select labelkey, labelvalue from reportlabel where reportname = 'woprint.rptdesign';select * from l_reportlabel where ownerid in (select reportlabelid from reportlabel where reportname = 'woprint.rptdesign');

So, after small investigation, looks like using registerDataTranslation for content is not the best solution, because it generates for each translation separate sql like 

select description from l_TABLE where langcode = ? and ownerid = ?

for 5000 records and 3 translateable columns, it is 15k fast, but extra queries. 

What community think about it?

Hello, friends! 

Question about localization of BIRT reports for Maximo. 

How do u manage it?

I know a few ways.

for content:

1. For each language use separate table rows that was fetched from DB in SQL query (itemDescEn, itemDescDe and etc) and set visibility based on language that is setted in mxReportScriptContext.getLanguageCode() 
2. in script use registerDataTranslation()

But for labels translation there is not so easy. 

Yes, we can use here properties files (here is an example Localization of BIRT report: Need sample example report and guideline 

or the same way for each language use separate table rows with static values for each language 

But anyway, in the case when we want to use actual object attribute's titles from Maximo, how i understand it will always requires to update report design or properties files. 

So found that myself only working solution is always to add extra dataSet, which will query attribute titles from maxatribute and translate it  (registerDataTranslation or just fetch for each lang in separete column) and then put it in layout binded each element 

So, the questions are: 

1. Does Maximo dynamically update properties for birt reports when providing database changes? How I understood - no.
2.  How do u manage it ?