catalog field XML (no hardcoding allowed)
Summary
catalog field XML (no hardcoding allowed)Content
Hello community,
actually I'm creating a PDF report out of a XML file. The XML file is stored as CLOB in the database.
Unfortunately there are catalog fields in the XML data (For example: ES instead of Spain, M instead of Male). The final report should print out the full name. There exist some lookup tables in a database where I can find the connection of ES and Spain and so on.
I'm not allowed to hardcode this in the report by using conditional formats because lookup tables change from time to time and the owner of the report doesnt want to change the report then. Instead I need some sort of connection in the data model.
Tagged:
0