Application Express :: Checkbox On Click Action

Jan 15, 2013

I am working in apex 4.2.1.

I'm having an odd problem with a checkbox on a tabular form. I created the checkbox by setting hte display as to "Simple Checkbox". The value of the underlying column sets to "Y" wehn checked and "N" when unchecked. This is what I want. The next thing I was trying to accomplish is to call a javascript function when the checkbox is clicked. So I put onclick="calculateTotal(this);" in the element attributes field. The code that it is calling is listed below. When I run the app and check the box I can seee I am entering the calculate Total function. Each of the alert functions is displaying what I would expect until I get to alerts 'IAH5' and 'IAH6'. For each of those I get an "undefined" in the alert.

So to see if this had something to do with the checkbox and added an onchange="calculateTotal(this);" to another field in my tabular form and ran it. This time I did not click on the checkbox but went into the field that I put the onchange on. When I changed this field and navigated away from it the function worked as I would expect. It displayed the appropriate values for each of the alerts and updated the fields on the screen as designed.

<script type="text/javascript">
function calculateTotal(pThis)
{
alert('IAH1');
var vRow = pThis.id.substr(pThis.id.indexOf('_')+1);
alert('IAH2');
[code].......

View 6 Replies


ADVERTISEMENT

Application Express :: 4.2.1 Dynamic Action Definition True Action Settings Not Visible

May 16, 2013

im working with apex 4.2.1 and when i try to define a Dynamic action on any item, if the action type is "Set Value" or execute SQL/Javascript code it should appear a text field that let me define the action taking place. However this wont do..

this is what happens:

And this is what should happen:

I know that patch 4.2.2 solves some issues regarding dynamic actions but in the bug report there's no reference to such a problem.

View 1 Replies View Related

Application Express :: Retain Checkbox Value On Cascading LOV Checkbox

Sep 29, 2012

My development instance's APEx version is 4.1. I have two checkbox items works on cascading LOV. The cascading works very well as long as if I do not come back and check anything from the first checkbox item after I checked the second checkbox.

If I do, the cascade LOV refresh uncheck all checked values from the second box. My question is, how can I preserve the second check boxes checked values before refresh?

View 0 Replies View Related

Forms :: Click Checkbox And Then Loop - Current Cursor Going To Last Record

Dec 7, 2010

i m using oracle 10g 10.2.0.2 version.i create a form and using check box on this form.when i click this check box then loop is using behind it.and current cursor is going to last record

i want if i click 4 record then cursor is still showing on 4 record mean i click which record after using loopmy current cursor is showing on that particular record

how it is possible

View 1 Replies View Related

Application Express :: Raise Application Error On Dynamic Action

Jul 18, 2013

I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parametersError Code and Error MsgSo in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.

Begin Package call......  If v_error_code <> '0' Then    Raise SC_Error;  End if;Exception   When SC_Error Then    RAise_Application_error(v_err_code, v_err_msg);End;

But when i run the page and I click I get an Internal exception errorOutput from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).AJAX call returned server error ORA-20003:

Customer has already been matched for Execute PL/SQL Code.4......is_internal_error: true4......apex_error_code: APEX.AJAX_ SERVER_ ERROR4.. ora_ sqlcode: -200034......ora_sqlerrm: ORA-20003: Customer has already been matched4......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 4......component.type: APEX_APPLICATION_PAGE_DA_ACTS4......component.id: 231852037977562094......component.name: NATIVE_EXECUTE_PLSQL_CODE4.

Execute Error Handling Callout defined on Page or Application Level4...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end;4......Values changed by callout:4..

An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. 4..display_location: ON_ERROR_PAGE4Stop APEX Engine detected4Final commit4-1 - 59

View 4 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 :: Enter A Value Using Set Value Dynamic Action

Aug 1, 2012

I'm using Oracle 11g XE with apex 4.0.2.

I've been trying to use a dynamic action on a text field 'item_group'. Button doesn't have this facility. I created an advanced action using 'set value' with no condition the value being 'RAM.' The event is "change", selection type 'event source', set type is 'static assignment' and value is RAM. It is supposed to trigger when the create button is pressed but nothing happens and the field is still null. I've tried variations on this but nothing works.

View 1 Replies View Related

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 :: 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 :: Checkbox In Classic Report

Jul 16, 2012

I have question about checkbox in classic report. I need to choose only one checkbox in every row, hot to ensure that only one checkbox can be checked at same time?

Checkboxes are defined in SQL query as:

apex_item.checkbox(1,msisdn,'UNCHECKED') as clear,
apex_item.checkbox(2,msisdn,'UNCHECKED') as to_analysis,
apex_item.checkbox(3,msisdn,'UNCHECKED') as to_barring

here is the picture:

[URL]........

View 9 Replies View Related

Application Express :: Difference Between JavaScript And Checkbox

Nov 18, 2013

How to check off checkbox with JavaScript. I tried

1) $("#checkboxID").prop('checked' , false) (jQuery)
2)    $("#checkboxID").attr('checked' , false) (jQuery)2) document.getElementById("checkboxID").checked = false;Checkbox's list of values: STATIC:;1

Checkbox always states checked. When I append 'checked="checked" ' attribute (or simply checked) to this unchecked checkbox in Firebug nothing happens. Why ? I execute JavaScript code in Dynamic Action on button click. All other controls (textareas and textfields) are cleaned successfully except this checkbox. "Effected elements" property includes all needed items.

View 3 Replies View Related

Application Express :: Checkbox Not Clear Cache

Oct 18, 2013

i have created form with table  page to enter hotel details there is on 6 check box which are not database column .i have create these check box to keep days details when hotel give service .so i have use

LOV FORP1_MON      STATIC2:;1   MONDAYP1_TUE       STATIC2:;2   TUESDAYP1_WED     STATIC2:;3   WEDNESDAYP1_THR       STATIC2:;4  THURSDAYP1_FRI        STATIC2:;5   FRIDAYP1_SAT       STATIC2:;6   SATURDAYP1_SUN       STATIC2:;7   SUNDAY 

i have one more column operating days where i have use computaation to keep operating days.

:P1_MON||:P1_TUS||:P1_WED||:P1_THR||:P1_FRI||:P1_SAT||:P1_SUN 

these 6 check box are used Source used :Only when curren value in session state is nullSource Type : Static Assignment (Value equals source attibute)  Problem are when i create new record then these 6 check box are not clear cache and when i update any record value are not clear cache . i need when i create or update recor then all 6 check box should be null after keep recor. 

View 1 Replies View Related

Application Express :: Use Page Item In LOV That Was Set By Dynamic Action?

Aug 15, 2012

I have a situation where I need to reference a hidden item in a List of Values (for a pull-down list) SQL statement. It doesn't seem to be working properly. Here is what I have:

1) Using a dynamic action, set the value of a hidden item based on the change of Select List 1.

2) Select List 2 has a parent LOV item of Select List 1, and the Select statement for Select List 2 uses the hidden item that was set from the dynamic action above.

I can see that the dynamic action is working correctly. But when I change Select List 1, the Select List 2 does not show any values from its LOV.

I'm wondering if the LOV for Select List 2 is not working because the item used in the SQL statement was set by a dynamic action?

View 7 Replies View Related

Application Express :: Suppress A Dynamic Action Loading GIF?

Mar 1, 2013

I've created a change event dynamic action which fetches a description from the database for a user-entered code. When this is run in Firefox, a swirling loading image is displayed next to the description.However, the loading image causes anything displayed its right to be moved out and then back again when it disappears. On a form with lots of dynamic actions this can be quite disconcerting so I'd like to stop it.

Can a dynamic action's loading image be suppressed?

APEX inserts the following HTML alongside the input field:
<span class="apex-loading-indicator"></span>One option is to apply "display: none;" to the "apex-loading-indicator" class but this could affect other loading images that use the same class.

Note: This affects Firefox (18) but not IE9

View 1 Replies View Related

Application Express :: Call Dynamic Action From Link

Nov 28, 2012

All I want to do is call a DA from an HTML link, is it possible? Do I call the DA function like I do with JS?

View 2 Replies View Related

Application Express :: Set IR Columns Outside Of Action Menu (APEX 4.0.1)

Jan 30, 2013

I am trying to find a way to set the selected columns, like what the action menu -> select columns does. I am planning to build a AJAX Tree with check boxes, but I don't know where to pass that data to to update the selected columns. I'm sure their is a magic apex function that is passing the values of the current shuffle box, but as that is dynamically created, I have not be able to find that process / function.

Reason for this: Too many columns on the IR report. Want them divided by categories in a tree view. And no, I cant break the report up into multiple reports. Currently this report has 548 columns.

View 1 Replies View Related

Application Express :: Action When Button Clicked - Redirect To URL

Feb 6, 2013

I have tested the following html page:

<html>
<body>
Click me
</html>

and is working fine when I click on the button on the created page.

However, using the same thing under the "Action When Button Clicked -- Redirect to URL" when create a new button, i.e:

javascript:window.open ('file:///c:/sample/','Documents');

will only open a new window, but blank in content!

View 2 Replies View Related

Application Express :: Compute Action In Interactive Report

Mar 13, 2013

I have an interactive report with two columns timestamp type. I want to use the compute action in order to get the difference between those dates. Nevertheless I got values like this: +000000008 00:00:00.000000.

View 1 Replies View Related

Application Express :: Retrieve All Data From One Multiple Checkbox To Another?

Jul 11, 2012

How do you retrieve all data from one multiple checkbox to another? The method I'm using returns one choice even though multiple have been chosen.

View 2 Replies View Related

Application Express :: Multiselect Checkbox As Cascaded Item

Nov 14, 2013

I have a check box in which if i select more than one check box, based on that multi-select values, i wanted the next item values to get displayed. I have set up an example at

[URL]........

In this page, if i multi-select "place" check box i wanted the "departments"  to get displayed according to the above multi-select.If i do a single select in check box, i am getting the corresponding departments but i am not getting it while i select multiple check boxes. 

View 11 Replies View Related

Application Express :: Insert A Row Into Table On A Button Click?

Oct 4, 2013

i have a table say 'temp' with 4 columns as seq, name, event, id and  i have a pg with 3 text fields as name, event, id now ma issue is,if  i enter values into those 3 text fields in that page and on a button click (say create), i wanted dose values to get inserted into  'temp' table andregarding ,  'seq' column i hav created a sequence for it. so

1. how to insert values into the table by entering values in the page    

2. wat shd b done for seq column.. (shd anyth b done from apex pages or wil it automatically get values for each row entered) 

View 4 Replies View Related

Application Express :: Possible Passing A Value To Two Different Pages When Click A Chart?

Sep 17, 2013

My application build in Apex 4.1, Oracle 11gr2In my application, there are three pages:

Page1 (Dashboard): contains 6 different chart
page60: Generate a chart based on  a value passed from page1
Page14: Generate a report based on a the value passed from Page1 and Page60

I want to pass value "3"  to page item P60_KPI_NO and P14_KPI_NO when click on first chart  I want to pass value "4"  to page item P60_KPI_NO and P14_KPI_NO when click on second chart.

View 0 Replies View Related

Application Express :: Dynamic Action Call From An Interactive Report?

Jul 6, 2012

I’m on APEX 4.1, 11gR2, Windows 7 and the latest version of Firefox. I have an interactive report. I want the end user to have the ability to click on a row level link and launch a modal pop up view of another page. Ideally, I'd like to be able to use the Skillbuilders plug-in. I can get it to work if I just go the full page route but I cannot figure out a way to get it to work as a modal pop up. I’ve tried various methods, none of which work, but the one I believe I should be following is by using a page level Dynamic action that fires when a JQuery Selector found item is clicked. The problem I’m having is that I cannot find the correct JQuery Selector syntax for the column. My report has a static ID of IDN and my column a header of PARTS. The best I can manage is not to see anything happen other than a page refresh (when the link is set to the same page). I do not see and firebug console errors.

I’ve replaced the dynamic action modal page call with an alert, which is not showing, to make sure that it's not the plug-in configuration that is causing the problem.

what I should be filling in in the JQuery Selector field of the DA and what the link attributes should be? Given that I wish to redirect from page 1 to page 2, what do I put in the other link fields?

View 2 Replies View Related

Application Express :: How To Have A Dynamic Action Populate Text Fields

Sep 7, 2012

How to have a dynamic action populate text fields. When the create button is hit, it will insert the record in the DB like normal.

I had a search box doing a dynamic action when a record_number is entered and the selection changes It populates the remaining text boxes with the results of the record_number.

I used a "SET_VALUE" true action on each individual ITEM

For each individual item i have different SQL Statement populating that item.

Ex. To populate Last_Name/ P2_LAST_NAME item i do the following

Select LAST_NAME from patient_Demographics
where record_id = :P2_RECORD_ID

Affected Elements:
P2_LAST_NAME

So i have about 8 of these true statements, so i'm hitting the DB 8 times to get the individual items. Is there a way to hit the DB once and set the items using one PL/SQL statement? I tried using a PL/sql function body,

View 14 Replies View Related

Application Express :: Cannot Use Username Into Conditional Part Of Action Item

Sep 14, 2012

For our customer we have build a custom login page. The form we currently made has de following items:

- Username
- Password
- Select list for selecting the task type

When the customer enters his username, automatically the select list of the task type will be refreshed to get only the task type where the customer has the rights to do it. This part works...It can occur that a customer has only one task type (which is default) then we want to hide the select list. This part doesn't work

We used APEX version 4.1.1.What we did is:

- One action item to refresh the selection list (works)
- One action item to hide the selection list by starting the application (works)
- One action item to show the selection list only when the selection list has more than one result. For this part we used the conditional part of the action item (Function returning a boolean).

In the query (inside the function) we want to use the entered username, looking into the application in the session state I saw the correct username, but for some reason the function cannot use this entered username, it becomes empty. When I use a hardcoded username the code works.

Why I cannot use a username into the conditional part of the Action Item.

View 3 Replies View Related

Application Express :: Deleting From A Tabular Form With Dynamic Action

Jan 24, 2013

Using Apex 4.2

Is it possible to delete a row from a tabular form using dynamic actions.

At the moment my report sql contains html and javasript for a delete button

'<input type="button" name="Delete" value="Delete"  onclick="del(''delete'','''||a.applicationname||''')">' A2I then have javascript in my page header
function del(Request, Name){
var answer=confirm("Do you really want delete application "+Name+"?

* Provider assignments will be deleted
* Application objects will be deleted
* DB-roles will be dropped
* DB-views will be dropped
* User-synonyms will be dropped");

if (answer==true) {
  document.getElementById('P10_APPLICATIONNAME').value = Name;
  doSubmit(Request);
}
}

Finally I have a page process to do the delete which fires when the request = delete

View 18 Replies View Related

Application Express :: How To Get Checkbox Value When List Value Changed In Classic Report

Dec 26, 2012

I worked with apex 4.2 and i create normal classic report with one checkbox column and one column change it to select list(named loved) now i want when user change list take value of checkbox item and show it in message .

SQL for report

{
SELECT
'<INPUT TYPE="checkbox" NAME="f01" VALUE="'
||SEQ
||'">' SEQ,
ID,
DEPT_NO,
EMP_NAME}

i change the column attributes of Dept_NO to Display as Select list of department name (named lov). Now i want when user change name of department the value of SEQ SHOW IN ALERT MESSAGE

i create JavaScript on the page

function test(pThis) {
var f01_value = $('select[name="f01"]').value;
alert('#SEQ : '+ f01_value);
}
</script>

I call this javascript function when list change but the value undefined..

My Question :

How can get this value Or any value of item in reports ?

View 6 Replies View Related

Application Express :: Single Value As Checkbox Or RadioButton That Submits Page?

Jul 18, 2012

I need a page item with a single value that submits back to the page, so that I can conditionally display other page items.I know a traditional 'Button' would work, but the a checkbox or Radiobutton would be my preference.

Here is where I am stuck.

CHECKBOX - I have used Dynamic Events to hide/show page items, but in this case I need a SUBMIT.

RADIO BUTTON - This works great with either the Redirect or Submit option, but I only have 1 value, so I what it act like a on/off button, where if it is currently selected, and the user clicks it again, it changes to unselected..

View 1 Replies View Related

Application Express :: Error In Javascript Not Fetching Value On Button Click

Nov 23, 2012

I am using APEX 4.1 to build the application. I have 2 select list region in the page where one region consist of certain values.On calling a javascript function it is able to move the value from one select region to another. After this I click on the modify button where in the value move out of the first select list region to the second will be updated in the table.

Although I could see the values are not being updates. On putting alerts after the value being fetched in the javascript function and clicking the Modify button I can see that no data is being reflected in the alert. Hence the data is not being passed from the second select list APEX item to the javascript function.

View 1 Replies View Related

Application Express :: How To Build A Button On Click Of Which Opens A List Below It

Jun 29, 2013

I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action. 

View 7 Replies View Related







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