Database view report shows sys_id value from reference field

[Antonio42]

Team, I have a database view that gets data from a multirow variable set and this multirow has a reference field. Everything works fine, but this database view is showing the sys_id instead of display value. Is there any set up to be done in database view clause or something after that using dinamic filter (never used this before) to show in the report the diaplay name?

[Antonio42]

Yes, I am aware of that. Do you have any idea how to proceed to recovery the display value on database view? or any tip?

[Ashutosh Munot1 · Accepted solution]

HI,

Add one more table in that database view to get the value from sys_choice table. so where clause should be added between this sc_multi_row_question_answer  and sys_choice table

something like this:

abc_sys_id ==mvrs_value

Show your database view.

Thanks,
Ashutosh 

[Antonio42]

Ashutosh,

Here is, I added the sys_choice == multirow field, but the sys_id is still there.

[Antonio42]

give me one second, it seems it worked. let you know soon

[Ashutosh Munot1]

Awesome