Application Express :: Get Checked Options Values Via Application Global Arrays?

Apr 26, 2013

how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...

When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:

<input type="checkbox" name="*f10*" value="3" />

And this one stands for array name "g_*f10*".However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly.

My generated HTML snippet:

<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>

View 2 Replies


ADVERTISEMENT

Application Express :: How To Check If The Checkbox Is Checked

Oct 24, 2012

I am running blank with this one.

I have a checkbox item called P46_PAGE2 with static LOV STATIC:;1

How do I check if it is check using Javascript.

View 2 Replies View Related

Application Express :: How To Determine Which Tabular Form Check Box(es) Are Checked

Oct 1, 2012

I'd like to determine (from code defined in a button definition) which check box(es) on a Tabular Form are checked. Assuming only one check box is checked, I want to obtain one of the values in that row for further processing. How to interrogate the Tabular Form to find out which box is checked?

View 9 Replies View Related

Application Express :: CSS In Global Page

Mar 20, 2013

I wanted to apply some CSS throughout my application by adding it in Global Page in APex 4.2

And I used

<style>
#t18InlineError {
color: rgb(243, 12, 12);
}
</style>

It doesn't work.

View 4 Replies View Related

Application Express :: Checkbox Corresponding Global Array Name?

May 27, 2013

m learning how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:

<input type="checkbox" name="*f10*" value="3" />

And this one stands for array name "g_*f10*".

However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly :(

My generated HTML snippet:

<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>

View 4 Replies View Related

Application Express :: Global Item Date

Dec 19, 2012

in my application I have several pages with the item of date. How to ensure that all items had the same date for all pages and can be set on each page ?.

Application Express: 4.1.0.00.32
DB: Version     10.2.0.4.0

View 7 Replies View Related

Application Express :: Create A Global Region In Page 0 And Then Access It From Other Pages?

Apr 26, 2013

I have a number of pages containing charts and gantts. I want the user to be able to filter the data shown in these various charts. More than that, I want the user's filters to persist between pages. So, if they select "Key project = 'Y'" on the gantt page, the gantt will filter - and if they then navigate to a report (bar chart) page, that will also be filtered for Key projects only.

To make this happen, I plan to have an identical sidebar on all these pages. This will contain maybe 8 dropdowns and tickboxes allowing the user to create or remove these filters. Eventually some users might save preferences for certain choices within these dropdowns.

Since the sidebar will almost always be identical from page to page, the smartest approach would seem to be to create one sidebar (as html region) and access that sidebar from all pages rather than copying the code from page to page. Then I thought I'd create application-level items in order to create global variables for each of the dropdowns.

My question is: is this approach possible? And can I create a "global" region in Page 0 and then access it from other pages? (This is how I thought it would work but I have tried and can't see how to do it.)

View 7 Replies View Related

Application Express :: 4.2 Translate (Function And Global Variable Declaration) Data?

May 1, 2013

i 'm using APEX 4.2.1.00.08 and i 'm wondering if there is a way to translate "Function and Global Variable Declaration" textarea. Every other script textarea is available for translation, but not this.

I know that this is code is loaded on header but may contains important alert messages of global functions.

View 1 Replies View Related

Application Express :: Assign Values In Many Rows Based On Search Values?

Jul 25, 2013

I used Region, Process by to search the report which appears as shown above. Then I use Choose Auditors column to select my Auditor and copy paste it into the report under To be Audited By col. Is there a way to automate the process. I am here using a tabular form in APEX. My main aim is to assign auditors based on Region, not equal to Processed by. 

View 4 Replies View Related

Forms :: Checkbox Checked On Runtime And Store In Global Variable

Feb 6, 2010

I have more then one checkbox on my form,I want to get which one is checked on runtime and store it in global variable?

View 6 Replies View Related

Application Express :: Getting Values Of Checkbox

Sep 4, 2012

I have problem with getting values of checkbox. I have search page where are some numbers field, date pickers, radio buttons and checkbox (P40_ OE) when I click search button I want to get report with filters like

select t1.id, t1.name, t1.company
from table1 t1, table2 t2
where t2.id = t1.id
and t2.oe in list of values from P40_OEIn checkbox I have 11 options to choose. I work in Apex 4.1.

How can I make this search or filter report working?

View 2 Replies View Related

Application Express :: Defaulting Values Of One Tab To Another

Apr 16, 2013

While working with Apex, i want to implement the following functionality :

the requirement is that, if the user creates a record in the one tab then the fields (say, Project Number, Task Number , Waterfall Number) used for creating the record should be defaulted in the next tab. How can i acheive this.

View 0 Replies View Related

Application Express :: Conditional List Of Values

Nov 15, 2012

Is there any way I could set the condition on the list of values.

For example if Value of the item x is null then use select ...

and when value of the item x is not null use this select ....

View 4 Replies View Related

Application Express :: Comma When Passing Values In URL

Jun 20, 2012

I have two page , from first page to second page I am passing some values using url parameter passing but some values contains comma ex :- P1_ NATION  text field contains INDIA,USA,UK

but apex treated that as these are separate values and assign it to separate items

suppose my intention is like P2_NATION,P2_EMPLOYEE,P2_EMPID :INDIA,USA,UK,SAGAR ,123

but apex treating it as P2_NATION = INDIA :P2_EMPLOYEE=USA :P2_EMPID = UK

I am using apex4.1 , db 11g , ie , chrome , ff.

View 2 Replies View Related

Application Express :: LOV With Optional Values For One Entry

Jul 11, 2012

As there is no boolean datatype in oracle (I wonder why, it exists in ms-sql, and I'm still quite new to oracle) you have several ways to 'simulate' a boolean. (1/0, 'Y'/'N', in german 'J'/'N', or this in small caps...)

Now for a checkbox you have to include the 'true'-value in the LOV. But what, if your database doesn't use '1', as you have implemented, but 'Y', or what, if the 'false'-value is not '0' but null? Each time you would have to adopt your STATIC2:...

So I am wondering about a flexible solution, and I would like to ask if and how it is possible. (Havn't found anything via searching for that yet.)

Instead of writing:

STATIC2: ;Y ... and having only the 'Y/N' implementation working, how about it would look something like that:
STATIC2: ;NOT('0' OR 'N' OR  'n' OR null) ... and a lot of reasonable boolean-implementations are incorporated. You could use a standard LOV for all checkboxes, dealing with different 'booleans'

But just like that, its not working...

So, a) it there a syntax for that at this point? and b) what do you think about that in general, or whats your 'best practice'?

View 0 Replies View Related

Application Express :: Update Values When Logout

Sep 14, 2013

I want to make DML process when the user logout :-i do the following steps :-1-I change the url &LOGOUT_URL to another page not the login page like 10  , as wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:102- Make tow process in the pageone (on-load before header) to do dml code like this

BEGIN
UPDATE SYS_USERS
SET ACTION_STATUS = 2
where upper(:p101_username)  like upper(USER_NAME);
commit;
END;and another process after header
apex_application.g_unrecoverable_error := true;
wwv_flow_custom_auth_std.logout(
p_this_flow => :APP_ID,
p_next_flow_page_sess => :APP_ID ||':101'
); 

to go to the login pagebut the dml code not executeand when try to login again i have this errorContent-type: text/html; charset=UTF-8 Content-type: text/html; charset=UTF-8 Set-Cookie: ORA_WWV_APP_100=-1; HttpOnly Location: /apex/f?p=100:101

View 1 Replies View Related

Application Express :: How To Connect List Of Values To Regions

Aug 20, 2013

I created list of values like Bar chart,Column Chart,Pie Chart.these list of values added to the text field named as Chat type. In same region i created 3 chart sub regions. My requirement is if i select chart type-pie chart.the page will show only pie chart region only.Same to Bar chart and Column charts also. 

View 3 Replies View Related

Application Express :: Hold Session Values In APEX_ITEM

Dec 6, 2012

I was making some page validation to APEX_ITEM manual tabular form. When every a validation executes it will clear all the data what user enters. What is the best method to hold the session values in APEX_ITEM.

View 4 Replies View Related

Application Express :: Interactive Report - How To Get Item Values

Mar 27, 2013

I have created a workflow which is going through 12 pages. At each page the user needs to choose his variables.

This could be the y-axes, x-axes, amount, surname ... etc. The variables are given to the next page via branch to next page process. Everything works well until I need to create an interactive report out of the chosen variables.

Lets say I have a variable called :P7_XAXIS with static LOV :

Amount,Amount;Date,Date;quantity,quantity

Page 8 is my IR. If I try :

Select :P7_XAXIS  from mytable This will not work.

But if I try

Select Date from mytable This will work. Why? In my workflow there are several variables that can be used in a where condition. This also works. But I need to access the values before the condition and I also need to get a chart out of it.

View 1 Replies View Related

Application Express :: Passing Item Values To Javascript

Nov 23, 2012

APEX 4.2 - Base code from Denes examples

CODE ON HTML HEADER

<script language="JavaScript" type="text/javascript">
function f_setglp(pThis,p_app_item,p_other_record_level_item)
{    
var curr_id = $x(pThis).id; // OK !
var curr_glp = $x(p_app_item).id; // returns undefined
var curr_orli = $x(p_other_record_level_item).id; // returns undefined

[Code]...

The Javasxcript function fires OK on click in the "Product" attribute but: PMO_GLP_PK is an Application Item that Javascript can´t reference as I called YES_NO is another tabular form attribute and the reference returns also "undefined"

what is the best way to implement this ?

View 4 Replies View Related

Application Express :: Passing Values To Modal Popup?

Aug 23, 2012

this modal popup, it works correctly but not passing values from page page1 to my page3. How do i pass these paramater values to page3,

function modalWin() {
if (window.showModalDialog) {
window.showModalDialog("f?p=&APP_ID.:3:&SESSION.:POP:NO::P3_EMPNO:#P1_CUSTOMER_ID#::","name","dialogWidth:600px;dialogHeight:400px");

[Code].....

View 4 Replies View Related

Application Express :: JavaScript API To Set Item Values Not Working In 4.2 EA2?

Aug 7, 2012

I had a complex drill-down dashboard where I was setting page items through $s(Page Item, value) from the Chart Links. But when I did the same thing in APEX 4.2 EA on [URL]...it is simply opening a blank page. whether in 4.2 that Java API has been removed?

View 4 Replies View Related

Application Express :: Report With Multiple Values For A Single Parameter

Oct 4, 2012

I have a user requirement where they want to be able to select multiple values for a single parameter that will act as a filter for a report. The possible values for a parameter can come from almost any master data Oracle eBusiness table. I don't want to just present the user with a LOV where they search down a list selecting what they want. That wouldn't be very practical for selecting part numbers from 1000's of rows. I also want the user to easily see what values they have selected. I thought about providing a button that would navigate to a multi-row form where they could record their values and use those values in the where clause of the SQL for the report, but that is a somewhat complex solution I have never tried before. how to do this. I'm working in the latest version 4 of APEX.

View 1 Replies View Related

Application Express :: Cannot Open Login Page - Not Able To Get Parameters Values

Nov 20, 2012

Not able to open login page 101 in my internal application. I am getting below error

ORA-12170: TNS:Connect timeout occurred
Error Not able to get parameters values
OK

View 2 Replies View Related

Application Express :: Currency Format For List Item Values

Sep 18, 2012

How can i apply currency format to the select list values queried from database tables. The data is stored in database in number format. The user wants to see 1000 separator commas in the list item values.

View 2 Replies View Related

Application Express :: Tabular Form - Change Column Values Before MRU

Jun 4, 2013

I have a problem with Tabular form. Configuration: Oracle 10g, Application Express 4.1.0.00.32.

I have tabular form on simple table. I need to change some column values before MRU. For example: i have column named "UPDATE_DATE" where i need write SYSDATE every time this record was updated. I've created page process, associated with my tabular form.

Process point: On Submit - After Computations and Validations;
Sequence set to 1 (before "ApplyMRU" process - it has sequence 10);
When Button Pressed: Submit;
Execution Scope: For Created and Modified Rows;

Source:

declare
indx varchar2(255);
l_map wwv_flow_global.vc_map;
l_id number;
l_pk number;
begin
[code]........ 
   
But this doesn't work. MRU process writes old values, that was posted from browser. I tried change values by

apex_application.g_f04(:APEX$ROW_NUM) := sysdate;but this also not work.

How can i change values before MRU? Why wwv_flow_tabular_form.set_row_values doesn't change values?

View 5 Replies View Related

Application Express :: Page Items Values Don't Get Submitted In Add_member Collection 4.2

Jun 10, 2013

The values in the page item dont get submitted hence generate errors in my application , in apex 4.2 using collectionEg.

apex_collection.add_member(p_collection_name => 'ORDER',     p_c001 => :P56_product_id,     p_c002 => :P56_product_name,    p_c003 => :P56_list_price,    p_c004 => 1);  

Can there be a reason why ?

View 4 Replies View Related

Application Express :: Fetching Values From HTML Textbox Or Any Input Type?

Jul 27, 2012

I am working on APEX 4.1.1 on Linux server. I have created one application in which I have take a HTML region where i have written the following code:

<input type="text" id="APP_ITEM1" name="APP_ITEM1" />

I am able to see the text box in page, but not able to fetch the value from it.

View 9 Replies View Related

Application Express :: Update Default Column Values In Database From Form

Sep 14, 2012

Application Express ver. 4.1

I have created a form. Some of the elements are hidden such as updated_by and update_date. I have provided the default values for these attributes as pl/sql expression in the "default section" (Application->page->edit page item). I am using the Process Row process that is automatically created when a form is created.

The problem is when I click the update button, the updated_by and update_date is passed as null values which throws an error from the database.

View 2 Replies View Related

Application Express :: Updatable Report With Row Data Depended Dropdown Box Values?

Apr 17, 2013

Oracle 10, Apex 4.0.

Working on this query:

SELECT waarde1,waarde2,
APEX_ITEM.POPUP_FROM_QUERY (3,waarde3,'select select ((waarde1-0.1)+(level*0.1)) d, ((waarde1-0.1)+(level*0.1)) r from (select * from lov_test where waarde1 = c001) connect by level <= (((waarde2-waarde1) *10)+waarde1)') waarde3
FROM lov_test
ORDER BY 1

The idee is to get a popup or dropdown box for "waarde3" in witch the selectable values are waarde1 to waarde2 rising with 0.1 at a time.

And this in a multi row updatable report.Example

waarde1 waarde 2 waarde3

(possible values in the dropdown box)

1 4 1-1.1-1.2 ... 3.8-3.9-4.0
3 7 3-3.1-3.2 ... 6.8-6.9-7.0

The error I get is:Error in init lov: ORA-00936: Ontbrekende uitdrukking. p_lov:select select ((waarde1-0.1)+(level*0.1)) d, ((waarde1-0.1)+(level*0.1)) r from (select * from lov_test where waarde1 = c001) connect by level <= (((waarde2-waarde1) *10)+waarde1)wwv_flow_security.g_security_group_id:1264429985836387wwv_flow_security.g_curr_flow_security_group_id:1264429985836387 Unable to initialize query. For every row in the table lov_test.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved