Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hide Item when null (server side condition not working?)

satishpMar 2 2022 — edited Mar 2 2022

So i thought this would be easy but i'm hitting some weird behavior..

  1. I added an item to my region
  2. set the source to be a database query returning a single value from a column.. a pretty simple "select col from table where condition". The column contains nulls for many rows.
  3. set a server-side condition that the item should render using condition "item is not null", and choose the region-item.
    image.png
    Apex refuses to respect this. It ALWAYS shows the item.
    What am i doing wrong?
    ===========
    I was able to solve this through a page load DA, that does a Hide IF item is null. Is this the only option?
    image.pngimage.png
This post has been answered by fac586 on Mar 2 2022
Jump to Answer
Comments
Post Details
Added on Mar 2 2022
#apex-discussions
8 comments
2,141 views
2 mentions