Hello,
I am currently trying to run a quick report that has a custom field in the report. I have a simple select statement (select * from ifsapp.business_lead_cfv) but this does not show the custom field listed.
The entity BusinessLead has a custom field that is enabled to show on reports, and it’s value is a reference to the CustomerInfo entity, that has a custom field which is also enabled to show on reports.
I can pull the referenced custom field by doing (select cf$_sic_code from ifsapp.business_lead_cfv) but I’m wondering why it wont automatically list the custom field when doing the same prompt but for customer_info_cfv actually pulls the custom field column...
Best answer by eqbstal
View original