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]

I dont see any issue with your database view. I also tried it on my instance for a scoped app and it worked fine.

Can you change the table prefix to something else may be 'ap' instead of 'APTM' and try again?

If that doesnt work, try with a smaller table name as well. Make sure the database view name is unique as well

[John Prouty · Accepted solution]

I changed the  alias to "a", but it doesn't improve anything.  The table name was made by the Application creator, and may be an aspect of the developer instance.

[SanjivMeher]

Can you create a new database view and try? I cant think of a reason why it wouldn't work unless the view is corrupted in the background.

You should be able to rename the view name even if the application assign a view name.

[John Prouty]

I rebuilt the view from the ground up and now I get data.  What I am missing though is non-join criteria.  When I add "at_active=true" to the first table (alias = "at"), it errors out.

[SanjivMeher]

Awesome. Could you please mark my response if it worked for you

Also try with the condition at_active='true'