Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Passing value to g_f01 for submit process (APEX 4.2)
Passing value to g_f01 for submit process [message #646595] Tue, 05 January 2016 05:00 Go to next message
david_ais
Messages: 3
Registered: January 2016
Junior Member
Hi,

I have a hidden item:

APEX_ITEM.HIDDEN(1, wo.operation_seq_num) operation_seq_num

in a standard report.

Each line has a button icon that submits the page using apex.submit.

I am trying to pass the value of the hidden item to the process which has an insert statement in it.

To test this I have created a dummy display item (:P20_X) and replaced the page process with:

:P20_X := APEX_APPLICATION.G_F01(1);

Where 1 = the row number which works and it sets the page item with correct value, the issue is that I'm hard coding the row number.

So...

...what do I replace the row number (1) with to ensure the correct value is passed to the page process, dependent on the line button the user selects?

Thanks.
Re: Passing value to g_f01 for submit process [message #646660 is a reply to message #646595] Wed, 06 January 2016 11:52 Go to previous messageGo to next message
Littlefoot
Messages: 21564
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why are you submitting anything in a standard report? Wouldn't a tabular form be a more appropriate technology here?
Re: Passing value to g_f01 for submit process [message #646661 is a reply to message #646660] Wed, 06 January 2016 12:01 Go to previous messageGo to next message
david_ais
Messages: 3
Registered: January 2016
Junior Member
No, it's a touch screen application that needs to have minimal 'clicks' for users and the most basic layout possible.

Plus I didn't develop the application; I'm only making enhancements to it.
Re: Passing value to g_f01 for submit process [message #646744 is a reply to message #646661] Thu, 07 January 2016 14:12 Go to previous messageGo to next message
Littlefoot
Messages: 21564
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see ... well, I never did anything like that. Have a look at Substitution strings, especially APEX$ROW_NUM and APEX$ROW_SELECTOR. Maybe you'll manage to do something with them.
Re: Passing value to g_f01 for submit process [message #646883 is a reply to message #646744] Wed, 13 January 2016 03:33 Go to previous messageGo to next message
david_ais
Messages: 3
Registered: January 2016
Junior Member
ok found how to solve this, forget APEX_APPLICATION.G_F01 for this and:
1. create a hidden item (P20_X)
2. within the html that generates the button (that holds the apex.submit) set the hidden item there with the in parameter of the function that generates the button, using:
3. apex.submit({request:'TEST', set:{'P20_X':'' || p_paramter || ''}});

[Updated on: Wed, 13 January 2016 03:35]

Report message to a moderator

Re: Passing value to g_f01 for submit process [message #646890 is a reply to message #646883] Wed, 13 January 2016 15:15 Go to previous message
Littlefoot
Messages: 21564
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for letting us know!
Previous Topic: APEX and client_identifier
Next Topic: Apex Blank Screen
Goto Forum:
  


Current Time: Wed Jun 03 15:33:15 CDT 2020