MRVS table in "value" field shows a reference value.. How can I fetch its referenced name for each record and use it to make a report?

[John Clyde Ap_a]

I apologize as I am not sure how to word it out but basically. 

I have this reference field which refers to different drinks in another table called "Drinks table".

My main requirement is to make a report of the popularity of each drink per month and base from other threads. I can access the MRVS answers in the sc_multi_row_question_answer table. So I did try it.

However I have noticed that the values that I am trying to make a report of only shows its reference value. 

when it actuality I wanted to get the actual name that it is referring to.

My question is how to fetch/access/convert these values into its referred value? which are the name of the drinks that were chosen..

[Aman Kumar S]

Hi @John Clyde Ap[as,

Since your "Select the name of the drink" field is a reference field, so it stores sys_id of the record which is expected behavior.

If you want to get other fields from the record, you will need to create a database view with Drinks table and get the required rows for your report.

[John Clyde Ap_a]

Hello Aman,

Does that mean there's no way for me to get the actual value for the reference field? Will creating a database view make me able to see the actual value its referencing to and not the sys_id? If so how may I do that and set up the view?

[Aman Kumar S]

You can refer to below link to achieve the same, here req item is used instead you can do it for your table

how do report on multi row variable set

[John Clyde Ap_a]

Thanks but sorry to ask this question. How will I approach the problem where the value is showing its sys_id instead of its actual referred value. I have checked the thread, the value is already a string but I am confused as how to approach it since mine is basing from a reference.