So I added a new field to an existing entity, let's call the field SpecialName, entity name = Application. It's just a single line of text field.
Checked the view in sql server, and saw that the field was there, in the view and the base table, Perfect so far.
Now I want to bring back data, so for a test, I manually altered the view in sql server, by changing myBaseTableName.SpecialName to 'test' SpecialName.
Manually ran the view in sql server and sure enough, every single row had the word 'test' in that column. Still perfect.
Added this new field to a new view using CRM. A copy of an associated view that only had 2 fields. So now my new view has 3 fields total, published.
Tried using the new view in CRM, and the 2 existing fields return data as expected, just like the view it was copied from, and the new field name (column) is there, but, no data.
Refreshed, republished, etc., you name it, still no data.
Why?
*This post is locked for comments