Database View is not showing any results in the list view, But showing total count of results in the DB view.Issue The customer is unable to see records in the DB view Error message: Syntax Error or Access Rule Violation detected by database ((conn=46111703) Unknown column '<tablealias>.<field>' in 'field list')SymptomsNavigate to database view, click on "Try it" to open in list viewNo records appear in the list view. Error shows like "Syntax Error or Access Rule Violation detected by database ((conn=46111703) Unknown column '<tablealias>.<field>' in 'field list')"ReleaseAfter UtahCauseA database view query cannot generate the result for the functional field on the tables involved in the database view.Validate if the tables involved with the affected DB view have the "functional field = True" in the sys_dictionary table.ResolutionOption 1: Disable the functional fields on the affected table at the sys_dictionary levelValidate the DB view, works as expected. Option 2: In case the function fields are needed, Need to manually add some fields on the view fields for the affected table (like Change_request, task...) in the database view as shown in the related document below.So we are basically not retrieving all the fields of the affected table in the database view by adding "View fields". Only retrieving the fields that are needed to view from the DB view.Related Linkshttps://www.servicenow.com/docs/csh?topicname=c_SpecifyAFieldToReturn.html&version=latest