Skip to Main Content

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!

Client-side Condition Involving Null Checking on Two Columns

Jared C7 hours ago — edited 7 hours ago

Oracle APEX 24.1.6

Sorry if the answer to this is already out there somewhere (which I'm sure it is), I was Googling for a while and couldn't find anything satisfactory.

I have a Dynamic Action on the change event for TWO columns in an Interactive Grid. The DA runs a server-side code action. The thing is that I want to make sure the action only runs if neither of the two columns are null. With page items, this would be easy, I would simply do something like apex.item('PX_PAGE_ITEM1').getValue().length > 0 && apex.item('PX_PAGE_ITEM2').getValue().length > 0. In this case, since they are columns in an IG, they are not accessible via the apex.item() API.

I do see that one can access the invoked record through something like apex.region("ig_static_id").widget().interactiveGrid("getViews", "grid").getContextRecord(this.triggeringElement)[0] but this is quite involved. Before I go down this road, I was wondering if there is a simpler way to access these column values?

Thanks!

Comments
Post Details
Added 7 hours ago
2 comments
32 views