Skip to main content
Question

Quick Information Source Draft with Custom Fields

  • April 27, 2022
  • 1 reply
  • 160 views

Forum|alt.badge.img+3
  • Sidekick (Customer)
  • 8 replies

Trying to create a QIS Draft that utilizes the “_CFV” version of the table so that the Custom Fields are available.  However, due to the fact that a “CF$_” is prepended to the field name and the Created View Definition is not editable to change an alias, the field comes into the Information Source with the CF$_ prefix, which I thought was fine.

 

And the field is visible in the BR, but if you try to put a filter on the field, it errors out, indicating that QFACT_XYZ_CFV.CF is not a dimension or fact.  It appears that the $ in the db field name is being evaluated as a parameter and making BR blow up.

 

Other than writing an IAL where I can alias the field correctly, does anyone know how to get around this issue?

1 reply

Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+18

Hi @jghall 
What is the UPD level you are using?
If it's below APPS9 UPD 12 , IFS Solution 260296 will resolve this issue.
If so please create a support ticket to IFS Support, then they will investigate the issue further and proceed with this solution.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings