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...
Solved
IFS Cloud SQL quick report with custom field
Best answer by eqbstal
I've noticed that in some situations on QR I had to check/recheck the columns that are available. Do you see the expected custom field over there? You mentioned a referenced field, maybe that is causing the problem and you need to have the business_lead and view to referenced field to connect (so basically what cfv should do). I know it is not what you want, but it gives the wanted values in the list and that is what the end-user expects.
+21I've noticed that in some situations on QR I had to check/recheck the columns that are available. Do you see the expected custom field over there? You mentioned a referenced field, maybe that is causing the problem and you need to have the business_lead and view to referenced field to connect (so basically what cfv should do). I know it is not what you want, but it gives the wanted values in the list and that is what the end-user expects.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.