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

Utility Function for Dynamic DFF Column Generation

Avatar photoCustomer April 30, 2025 at 12:01 am

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support May 2, 2025 at 2:56 am  

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

    • Avatar photoCustomer May 3, 2025 at 5:33 pm  

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

    • Support May 4, 2025 at 12:18 pm  

      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”`.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: