Skip to main content
G
geethasrik0957
October 30, 2024
Question

Question On End User Reporting Configurations

  • October 30, 2024
  • 6 replies
  • 0 views

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!

    6 replies

    shanmathip7466
    shanmathip7466
    Inspiring
    October 30, 2024

    Hi [mention:ce3c238c3c8d4f53bd5505359d7d0961:e9ed411860ed4f2ba0265705b8793d05] ,

    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.

    G
    geethasrik0957Author
    October 30, 2024

    Hello [mention:8f8eb6b7f316476598a071db8c05cf6a:e9ed411860ed4f2ba0265705b8793d05:label=Shanmathi] 

    Thanks for the suggestion. But I don't see a way, to call the expression rule by passing inputs while configuring reporting fields. Can you pls guide me where to call this exp rule which has the rule inputs.

    shanmathip7466
    shanmathip7466
    Inspiring
    October 30, 2024

    Hi [mention:ce3c238c3c8d4f53bd5505359d7d0961:e9ed411860ed4f2ba0265705b8793d05] ,

    I don't have complete context on your logic. Could you please share your code if you are fine or sample code?

    somasundaram.d
    somasundaram.d
    October 30, 2024

    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
  )
)

    G
    geethasrik0957Author
    November 1, 2024

    Hi Soma, Thanks for the suggestion. But in EUR App, i don't find a way to call expression rules which has rule inputs.

    However, this issue is now resolved by making use of 'custom Record Fields'.

    Thankyou!

      Terms & ConditionsAccessibility statement