Skip to Main Content
Feature Request FR-2403
Product Area Page Components
Status DELIVERED

36 Voters

Option to hide null values when using report template "Value Attribute Pairs - Column"

morten Public · Mar 26 2022

Idea Summary
When using the “Value Attribute Pairs - Column” report template, null values are shown as rows in the report.

Use Case
Simplify and reduce clutter. Reduce the vertical size of the report output by omitting null values from the output.

Preferred Solution (Optional)
Add a template option to the built-in report template. Alternatively, make it possible to reference :column_value in the column template condition so the developer can create his own customized copy of the template and filter out the null values by using condition “:column_value is not null”.

This has been delivered in Oracle APEX 24.1!

Comments

Comments

  • morten OP 3.2 years ago

    See https://twitter.com/mortenbraten/status/1507677089352331268 for related discussion.

  • jayson hanes Admin OP 3.2 years ago

    I agree this would be nice. Cleaning up the output of such a report with JS/jQuery is more work than it should be.

  • dietmar.aust OP 3.2 years ago

    Totally agree! 

    Could also be implemented as a server-side condition, so that these rows aren't even generated and transferred to the client … only to be hidden through a template option.

  • fac586 OP 1.9 years ago

    Same thing for the Contextual Info report, please.