Question:
A query exists where all custom keys related to a Health Care Organization (HCO) is not displayed in the Basic Report Builder while all custom keys are shown in the SQL Query Editor.
Example:
select * from customkey where custom_key_entity_id__v='937688503203XXXXXX'
There are six active custom key records returns in the SQL Query Editor.
Only one result returns in the Basic Report Builder.
Answer:
This is by design.
Basic Report Builder only returns one row per Veeva ID. If an HCO has multiple custom keys, the application randomly picks one custom key to display.
As a workaround, it is highly recommended that users run queries using the SQL Query Editor to ensure all records are displayed in report results.
Related Documentation:
Network Help Documentation:
Send us your feedback: We're always looking for feedback to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.