issue with Data Base View not showing Variable data

[Insider]

1: I have tried creating a DB view for tables 1: legal Case table, 2: MRVS question answer table.
I was able to achieve the DB view using where clause "mrvs_parent_id=lr_sys_id" on the legal case table where clause.

But when i open this DB view i don't see any option to choose the variables which are on the legal case table.

But when i individually try making a report on legal case table i am able to fetch the variables.

Why is this occurring only in DB View?

2: When on the DB View and impersonated with user i see only legal case data but not MRVS question data on the DB list. This is happening only on DB View. 

User whom i impersonated is able to see the complete list of records when opened the table separately.

Anything that i am missing?

Please Suggest

[Brad Bowman]

I'm stumped on that one if I'm understanding correctly.  The impersonated user can view a list view of sc_multi_row_question_answer completely, but when they view a list view of the database view column headers from this table show, or don't, but no question or value data can be seen?  Is it the same for question_answer, or is that visible? Is this the same for other impersonated users with similar roles?  Is it some weird impersonation thing where it works fine for the same user who's actually logged in, not impersonating?

[Insider]

The question_answer fields and values are shown on the DB View, it is only the MRVS_question_answer fields values which are empty when impersonated. 

The user who i impersonated is lsd lead actually who has access to most of the tables along with MRVS question answer table. But not sure why the issue is occurring only on DB View.

[Insider]

1: The issue with not being able to fetch variables from the Legal Case table in the DB view:
-> So on this the only way is to create a separate report to fetch the variable data is it? SO i should provide user with a separate report for variables and also the DB view for MRVS data.

2: The issue with the impersonated user not being able to see MRVS question data on the DB view:

-> Here the filters might be the cause i will check and get back on this. Because when i impersonate the user and open the table separately he is able to see the data on MRVS table. Let me check on the filters.

Thank you so much for your help!

[Insider]

2: The issue with the impersonated user not being able to see MRVS question data on the DB view:

-> I have tried removing all the filters on the report, but it didn't work. Not sure why this is occuring.

[piyushrusia1998]

Hi , Did we get answer to this issue  ?