Home › Discussions › Questions & Answers › Utility Function for Dynamic DFF Column Generation

Utility Function for Dynamic DFF Column Generation

Avatar photoCustomer Questions & Answers 3 replies

I need to dynamically include Descriptive Flexfield (DFF) columns in my report’s SELECT list, replacing an `&lexical` placeholder. Is there a utility function that handles the complex metadata lookup?

3 replies

  • Support Enginatics

    Yes, you should use the function `XXEN_UTIL.DFF_COLUMNS`. This function returns a SQL text snippet suitable for `&lexical` replacement.

  • Avatar photoCustomer

    What parameters does the function require, especially concerning table aliasing?

  • Support Enginatics

    Key parameters include `p_table_name` and, importantly, `p_table_alias` (e.g., ‘msiv’ instead of ‘msib’). The function automatically generates SQL text that uses the DFF’s form left prompt as the column alias, such as `msiv.attribute15 “Invoice UOM”`.

  • You must be logged in to reply to this post.