Question:
When running the following Ad-Hoc Query in a Network Instance, the results show that a specific field is blank even though that field is populated before the report is run.
select vid__v, corporate_name__v, alternate_name_1__v, alternate_name_2__v from hco where vid__v = 654630041270123456(sample)
The database is also refreshed. In this case, it is evident that this specific field was populated months ago (January 25th, as noted in the Revision History), and the last Database Refresh completed an hour ago. Why is the field not showing as populated in the report results. See the screenshot below:
Answer:
This behavior is expected. The cause of this inconsistency is that the specific field in question (Alternate Name 2 in this example) has values which are added before the field is enabled in the Data Model (which in this case occurred on February 21st). Only records that are updated after this date are re-exported to the database to insert values into these fields.
Related Documentation:
Veeva Network Online Help: Building reports with SQL queries