- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-18-2019 06:45 AM
Jon,
I had tried to create a database view but had been missing at least one step. Have tried to do this again. When I go to Try It, I am presented with the table view with 6722 records but no actual information is visible - all fields are either blank or display "(empty)". My User table has 6715 records. Adding columns re: fields from User table such as First Name and Last Name does not seem to make any difference - all fields still blank.
If I set the filter re: : Title (ttl_u_title) Is Empty AND Title (usr_title) Is Not Empty AND Active is TRUE it reduces the number of records to 570 but still nothing actually visible in the list.
Have confirmed that my table U_Title does indeed have all of the data I imported. Simply a single column, column property Display is set to True. Quite possible that it's something simple that I've missed with the table I created but if so, not seeing it. All ACL's on the table are set with Admin override is true and all work above performed under my admin account.