Database View not displaying base record data

[Karen16]

I'm creating a database view on the sn_hr_core_case_finance table.  In the view, I have selected several of the base table fields for view including number, opened_at, closed_at, short_description, assignment_group, assigned_to, sys_id, hr_service, priority, state.  When I try the view, I see assignment_group, assigned_to and state, but all the other fields are empty.  This is the base data on the record, what would cause it not to display?

Thanks,

Karen

[Brian Lancaster]

Can you show us how your created your view?

[Karen16]

Found the issue is that I used an upper case letter in the view case variable prefix.  For some reason, this is an issue with SN 🙄