Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Using .properties file to alter data
Migrateduser
<p>Hello.</p>
<p> </p>
<p>I've been searching for a way to use .properties file to alter the data displayed in my report - with no luck.</p>
<p> </p>
<p>What I need to do is to display another value in the report data field (than what is found in the database). I managed to bind the "Keskeytys_syy.properties" -file from Property Editor - Resources. This .properties -file includes the following bindings:</p>
<p>kunta.keskeytyssaannot.syykoodi.KESKEYTYS_LOMA=Loma<br>
kunta.keskeytyssaannot.syykoodi.KESKEYTYS_SAIRAALA=Sairaala<br>
kunta.keskeytyssaannot.syykoodi.KESKEYTYS_KUOLEMA=Kuolema<br>
kunta.keskeytyssaannot.syykoodi.KESKEYTYS_MUU_SYY=Muu syy</p>
<p> </p>
<p>For example, I'd like to show on the report the shorter values like "Loma", when the value for "syykoodi"-field is "KESKEYTYS_LOMA".</p>
<p>My colleagues told this problem I'm having won't probably be resolved on the database -level.</p>
<p> </p>
<p>ACTIONS:</p>
<p>A) I was able to use this .properties file for a text field with no problem.</p>
<p>B) I was also able to use the .properties file for mapping data field each value individually from "Property Editor - Data - Map". (data field)</p>
<p> </p>
<p>-> But this isn't a dynamic way to do this. If there are any changes made to the display values OR some extra values are added to the kunta.keskeytyssaannot.syykodi -column, they are not shown on the report.</p>
<p>Better way would be just to update the .properties file if needed.</p>
<p> </p>
<p>QUESTION: Is there a way to display dynamically the shorter values (Loma, Sairaala, Kuolema, Muu syy) according to the value from the database? With only addressing the .properties value and without any actual mapping "value by value"?</p>
<p> </p>
<p>- Elja</p>
Find more posts tagged with
Comments
There are no comments yet