reporting configure function field, I need display value instead of sys_id

[Naveen Bagula]

All,

While creating a report, I need to concatenate the short description and assignment group to display in the report. I attempted to use the "configure function field" in a trend report, but it is displaying the sys_id of the assignment group instead of the display name. The getDisplayValue() method is not supported syntax here, anyone tried such kind of report, please let me know, thanks

[Nishant8 · Accepted solution]

Hello @Naveen Bagula, Basically, fetching DB values using dot walking and displayValue is not allowed in function field in Reporting. But, such restrictions aren't applied when creating function field directly in the table. having said, can you please try to create the field in the table and use in the reporting :

- for e.g. if Incident is used in the reporting then create function field in Incident table- refer below SS

here is the function definition: glidefunction:concat(assignment_group.name,'-',description)

- use it in the reporting

- dont try to change the field in the reporting now

Regards,

Nishant