Please try to generate and compile the application, additionally, the pool can be restarted, and perform flushing the Redis. If it didn't help, please check if all the necessary columns (Id, CreatedById, ModifiedById, ModifiedOn, etc.) were added to the view object. Possibly next Community posts will be helpful for solving the issue you have faced:
In case after performing the mentioned operations and checking the issue still persists for you, please open the web developers console (in Google Chrome just need to press F12) before opening the detail record and check if there are any specific error notifications that can point at some missed configurations for the needed detail.
And execute below script to create the view in database.
After executing the view, I made sure that there is data by executing select query on that view
After doing this, I tried to display the data of this view in a dashboard list. but unfortunately I am not getting any data from this view object on crm. Am I missing something, any idea how i can fix this issue?
In order to create a view in the system you need to do the following:
1. Create a new object in the system configuration. Give it the same name as view. Set "Represents Structure of Database View" option to true (put a tick); The object should include all columns, that you will add to the view.
2. Run a script to the database to create a view with needed columns.
Please take into account, that structure of columns in the view should match the object columns structure.
Based on your screenshot I can tell, that in the object for the view Contact and Account fields will be lookup type columns and will be referred as [Column name]+Id e.g. UsrContactId, UsrAccountId. However, in the view, you have named them simply UsrContact and UsrAccount. Please check the naming.
Also, as you open dashboards, please open developers console as well (F12). You will see errors indicating which column cannot be found. This will help you to determine the issue.
