Skip to Main Content
Feature Request FR-3233
Product Area Page Components
Status CLOSED

6 Voters

Increasing the character limit from 4000 in Interactive report columns and from 32000 for dynamic region.

govindasamy.chenniappan Internal · Jun 26 2023

Idea Summary
Currently for the reports, the maximum character limit is 4000. Sometimes it's harder to handle data and we need to make alternative solutions to get the result. 32000 limit for dynamic region is also very challenging.

Use Case
In case user needs a table inside a column which can be implemented by dynamic content, the character limit is not allowing us to display entire data as required. For example, if user needs to answer a question from a questionnaire which needs more than 4000 characters are certain HTML characters, 4000 is not enough or the dynamic region returning more than 32000 characters which we have a lot in our requirements.

Preferred Solution (Optional)
Increasing the length.

Unfortunately, this idea does not contain sufficient information for us to take it forward.

Comments

Comments

  • damyantiresidency OP 1.9 years ago

    focus on marketing

  • vincent morneau Admin OP 1.7 years ago

    Hi @govindasamy.chenniappan ,

    The APEX team discussed this idea today. Because this is related to two different components, would you mind providing more information, possibly examples, on how you are reaching those limits?

    Thanks.

  • govindasamy.chenniappan OP 1.7 years ago

    Hi @vincent morneau ,

    Thanks for considering the idea. I have faced the issue many times in our internal tools. I have two examples and hope it would be useful for you.

    1. User needs to answer a questionnaire and in some cases it exceeds 4000 characters. So we are asking them to add a file as an attachment as a workaround.
    2. In another case, we have multiple releases for a product. For each releases there are multiple platforms and filesets attached to it. We are providing this info via table in an IR. Most of the times we have to truncate it and provide an additional link in the column using LISTAGG ON OVERFLOW TRUNCATE to display the entire content. 

    Since we are migrating from ADF, it is sometimes unfortunate to explain users about the limitations especially when it is handled well in older technologies.

    Thanks.

  • govindasamy.chenniappan OP 1.7 years ago

    For dynamic regions, the formation of source query involves various logics and it is difficult to limit it with in 32000 characters. To avoid this we have to lose the indentation and it is very difficult to read the source query.

  • vincent morneau Admin OP 1.7 years ago

    For dynamic regions, I understand that it's the APEX Code Editor that is limiting you to 32k, not the CLOB output. In that case could you move your code to a package instead? You will find many benefits to do this especially if you are writing so much code inside APEX pages.

  • govindasamy.chenniappan OP 1.7 years ago

    That's a better choice but not all could be handled in same way. In one of my tasks I had to compare three different collections and arrive at a table for multiple grouping . 

        Column 1                               Column2

            1                                                 A

            1                                                 B

            1                                                 C

           2                                                   B

            3                                                  A

            3                                                  B

            3                                                   C

            3                                                   D

            3                                                   E

    output has to be

         Column 1                                    Column2

           1,2,3                                                B

             1,3                                                  A,C

              3                                                    D,E

    All based on user's selection on collections.