I’m working on an Oracle APEX app, using Master/Detail drill down forms. I’m having difficulty working out how APEX uses a value looked up as the result of an SQL statement run in one event in a subsequent SQL statement. In JavaScript, this is async callbacks and/or Promises; from the difficulty I’m having here it’s pretty clear that there’s an async mechanism at work behind the scene.

I’m working on an Oracle APEX app, using Master/Detail drill down forms. I’m having difficulty working out how APEX uses a value looked up as the result of an SQL statement run in one event in a subsequent SQL statement. In JavaScript, this is async callbacks and/or Promises; from the difficulty I’m having here it’s pretty clear that there’s an async mechanism at work behind the scene.

I would like to hide or show some page items if a sql query result is equal to 1 or 0 .
I thought I could use a DA and then use when event Page Load, but I can’t seem to find away.

I have an Interactive Grid.

I have a Client-side Condition which looks like this:

I set up custom authentication for my APEX app (first time doing so)and it’s working, but only if I run the login page manually.
If I run the application normally, I get a browser message that the app requires authentication (See below). What I would expect to happen is for the login screen to appear. Same thing happens if I sign out – it will try to open the home page – but obviously I’ve signed out so credentials will need to be re-entered, but instead of the login page popping up, I get the weird dialog shown.

How can I set the value for columns in interactive grid before Insert its hidden items and I need to set the value automatically before insert .

I have a grid with the query:

I have an Interactive Grid (Apex 22.1)

I have an IG with the query: