Database view report shows sys_id value from reference field

Antonio42 · ‎07-09-2020

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?

Ashutosh Munot1 · ‎07-09-2020

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

Ashutosh Munot1 · ‎07-09-2020

Hi,

This is because the table in backend where the mapping between the variables and ritm is stored is in string format.

So it only stored the sys id as string and not as object.

Thanks,
Ashutosh

Antonio42 · ‎07-09-2020

Thanks for your reply Ashutosh!

I have used the sys_choice to referencing values, like this:

Antonio42 · ‎07-09-2020

Here is the sc_multi_row_question_answer how the value was recorded on that:

Ashutosh Munot1 · ‎07-09-2020

HI,

That is the sys_id of the record in sys_choice table.

Thanks,
Ashutosh