Question On End User Reporting Configurations

Question

Hi there, 
 I have a scenario where i need to change the display name of a record field value. Is it possible to do that while configuring 'Reporting Record Types' ? 
 ex. my record filed has the value 'SME' but i need to display it as 'Subject Matter Expert' (there is no related table to fetch the expanded value) on the frontend while we display the report. Is it doable in EUR? 
 Thanks in Advance!

Shanmathi Ponnusamy · Answer

Hi Geethasri , 
 As you mentioned there is no related table to fetch the expanded value, you can create a expression rule to display the value. ( This is not a best practice but you can use this if your value list is less than 10 ) 
 The best approach is to have a Lookup or reference table and display the values from that table in the UI and store the Id of the selected value in your record. So while displaying you can query the lookup and using simple wherecontains logic you can display the value of the stored Id.

Soma · Answer

You can have a logic to pass the short form and get desired text to display. Please check the example below a!localVariables(
 local!references:{
 a!map(
 short:"ABC",
 Full:"Apple Banana Carrot"
 ),
 a!map(
 short:"SME",
 Full:"Subject Matter Expert"
 ),
 a!map(
 short:"SPD",
 Full:"Space Patrol Delta"
 )
 },
 index(
 local!references.Full,
 wherecontains(
 "SME",
 local!references.short
 ),
 null
 )
)

Question On End User Reporting Configurations

Top Replies