Database Views not working

[John Prouty]

I can't get Database Views to return any data.  I even built a view that consisted of 1 table with no Where Clause.  When I press "Try It", I get the correct number of rows, but the rows have not data.  Also the list includes all the columns in the table, not the ones listed in the view.  When I tried to use the view in a report, it shows the correct number of rows, but no data.  For example, Active is true for all the rows, but the view and report show Active as false.  What am I doing wrong?

[SanjivMeher]

Did you try adding the correct fields using the list layout in the database view?

I dont think there should be any issue unless you have access issue to that table.

[John Prouty]

I had already added fields to the view.  List Layout isn't used in Orlando for adding fields, it uses "New".  My application is scoped.  Does that impact Database views and Reports?

[SanjivMeher]

I was talking about this one. Are you using List V3?

Also scoped application shouldn't be a problem. Database view works for all applications. I never had a problem configuring the database view.

Would you mind sharing screenshots of the database view and the List View of the Database view

[John Prouty]

Here is my data:

When I click "Try It", this is what I get:

I wrote a report using the database view and it gives me this: