Database view report shows sys_id value from reference field

Antonio42
Kilo Guru

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?

1 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 

View solution in original post

11 REPLIES 11

Thank you very much, it worked fine!

Cool