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 not familiar with the Legal Case table (if you tell me which module/plug-in it's part of, I'll try to install it in my PDI) but I have done something similar with the RITM table and MRVS, so it should be the same structure.  Here's my view:

Of course if you want to see all of the records regardless if they have a MRVS, set the Left join on 200 to true.  On the db view list, right-click and choose Configure -> List Layout, like any other list view, the key columns for the MRVS are Question and Value.  Are you saying that you don't see these fields in your List Layout slushbucket?

[Insider]

Hello Brad,

1: legal case comes under CSM domain

2: I have used the same where clauses earlier and was able to generate a DB view for legal case and MRVS question table.

Issue-> 3: Here i am able to see the MRVS questions, but not able to fetch the other variables from the legal case which are not part of MRVS.

[Brad Bowman]

Sorry, I misunderstood.  I have the CSM plugins, but not this table.  Check a list view of the sc_item_option_mtom table and see if you have entries where the Parent Item is a legal case.  If not, there will be a similar table for csm variable ownership. Add this your view (300, and I'll use the prefix vo) and sc_item_option (400 op) or the CSM equivalent.  The Where clause on 300 would be vo_request_item=lr_sys_id (unless there's a different CSM table for vo with a different field name for parent) and vo_sc_item_option=op_sys_id on 400.

[Insider]

Hello Brad,

I was able to showcase the variable data by adding the question_answer table on the DB view.

But i have an other issue here.

-> Where user is not able to see the MRVS data on the DB View report or the list.

where as the same user has full access to table and list data of MRVS when opened separately.

I mean when user opens MRVS table.list he is having full access. But this issue is occuring only on DB Views.

I checked all ACL's and all seems to be aligned.

Any suggestions here?