Application Express :: JavaScript Code In Page Zero?
Sep 27, 2012I have javascript code i want to move from standard report page to page zero, well page 0 doesn't have html header/page attribute section so how to i achieve this?
View 7 Replies
ADVERTISEMENT
Application Express :: How To Pass A Cursor Result To Javascript Code
Jun 15, 2012what document I should look for to pass a cursor generated by PL/SQL to java script code in APEX?
View 15 Replies View RelatedApplication Express :: Use Javascript.addrow() In A New Page?
Oct 5, 2012In a normal tabular form, with the add, delete, submit option, Under the add button we have the javascript.addrow() call which creates a new row. However, in my case the rows in the tabular form have some columns as display type. So when the user clicks on the add button, he cannot enter all the fields. Is there a way
1. Either to enable all columns of a new row only so that users can add all values and save
2. Or atleast open a new page where the new row is open with all editable fields?
Version:4.1.0
11g
Application Express :: Unable To Trigger JavaScript From Page Item?
Oct 22, 2013I am using the following code in Java Script function
function notNull(object){ if(object.value=="") alert('This field must contain a value.'); }
I am then calling the function from one of the page item under HTML Form Element Attributes by using the following
onblur="notNull(this);"
But it doesn't seem to work. I am using APEX 4.2.3
Application Express :: JavaScript Assign Value Is Not Visible To Page Process
Aug 21, 2012I have a page (16) and a tabular form when the user select the check box I update the zero page item
$x('P0_REPORT_REFNO').value=l_value;
this works fine till this point now i have a button will calls page 8 and pass the parameter to page 8 P0_REPORT_REFNO is displaying the selected value but passing null to page 8.I am running the application on apex.oracle.com
Application Express :: Execute JavaScript After Update And Submit In Skillbuilders Modal Page
May 13, 2013I'm editing, say, list of my employees in a tabular form opened in Skillbuilders Modal Page. I have to execute same javascript code after the changes in the tabular form have been submitted.
I've tried using a Dynamic Action fired on Page Load, but that gets executed before the update is completed.
Application Express :: JavaScript - Execute When Page Loads Not Working When Paging Results Grid
Aug 12, 2013I have some Javascript in an Apex page, running in 'Execute when page loads'. It does some stuff to a results grid. It works fine on page load, but then doesn't run when I page through, or sort the grid. I presume this is because the grid is being sorted / paged using Ajax, which means the page isn't being fully loaded. Is there anywhere else I can put the code so it gets applied to the grid on sorts and paging?
View 2 Replies View RelatedApplication Express :: How To Soft-code Page Number Portion Of Item Name
Oct 9, 2012In an Application Procedure, I'd like to reference some items that are local to the current page. Obviously, hard-coding like the following won't work unless it happens to be on Page 25.
:f105_blah := :p25_blah;
So how can I write this line of PL/SQL code so that the "25" is automatically set to the number of the current page?
Application Express :: Set Popup LOV Value From JavaScript?
Sep 3, 2013I use APEX 4.2.2 and in my page I call a Modal Region to insert a new customer using AIAX and OnDemand PL/SQL process, then I need to set the inserted value into the Popup LOV from javascript. I used the code
:$('dialog').dialog('close');$('P20_CUSTOMER').trigger('apexrefresh');$('P20_CUSTOMER').one('apexafterrefresh', function() { apex.item('P20_CUSTOMER').setValue(ajaxResult, $v('P20_DESCRIPTION'));}
where P20_CUSTOMER is the Popup LOV, ajaxResult is the PK returning from the OnDemand PL/SQL process and P20_DESCRIPTION is an APEX Item of the Modal Region. The new customer is inserted successfully into the table and the PK value returned to javascript code, but the new value is not displayed into the LOV.
Application Express :: Display Only And JavaScript
Oct 26, 2012I have two Select Lists P58_TYPE_DOC (it shows for users that have not adm profile) and P58_TYPE_DOC_ADM (it shows just for administrator).
On my Page proprieties I have on HTML Header this code :
onload="show_fk_facture('P58_TYPE_DOC');show_fk_facture('P58_TYPE_DOC_ADM');"
I have to execute the java script when the page loads, but I cant execute the function for both items in the same time.
Because one of the items will be hidden, and the java script won't be able to find it.
I tried to use "if isNAN('P58_TYPE_DOC') else ....." but it doesnt work.
Application Express :: Set Variable Via Javascript
May 16, 2013I got a long string (length exceeds 32512) from Javascript, and want to pass the sting to a variable to a item called P_SQL
I use *$x("P_SQL").value* in javascript to set the value, but my process couldn't get the value before I submit, however, when I do submit it reports an error like this : Bad Request
Your browser sent a request that this server could not understand.mod_plsql: /pls/alq/wwv_flow.accept HTTP-400 Value param too long. Length is 216343. Upper limit is 32512
how to handle this conflict ?
Application Express :: Setting MaxDate Using Javascript?
Jun 24, 2013I am struggling to set the maxDate of a datetimepicker.
In the document load of the page I have this:
$('#P64_STARTDT').datepicker("option", "maxDate", $v('P64_XFORMATSTARTDT'));
P64_XFORMATSTARTDT is in the format YYYYMMDDHH24MI
It never sets it.
Application Express :: Difference Between JavaScript And Checkbox
Nov 18, 2013How 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.
Application Express :: Changing Color Using JavaScript In IE8
Nov 19, 2013Apex version 4.1.1.00.23IE8 (8.0.7601.17514)Firefox 25.0
I have a tabbed form that I need to conditionally disable rows (making them read only). I'm using Javascript to set the attributes of the fields that need to be set.A request was made to make the font color of the read only fields black so that they're easier to read.I'm not able to get the font changed to black on the fields that are Select Lists in Internet Explorer. They are staying gray, however, they are set to black in Firefox. The JavaScript code for one of the Select List is:
var curr_id = html_GetElement('f42').id; //Group
$x(curr_id).disabled = true;
$x(curr_id).style.background = "silver";
//$x(curr_id).style.color = "black";
$x(curr_id).style.color = "#000000"; //black
Application Express :: Passing Variable To Javascript
Aug 28, 20134.1.2theme 24
I have a .js process in the before header of a page which has this pl/sql process using htp script javascript function {code}
function check(flag_val){ if(flag_val=="N")
document.getElementById("btn").disabled = true;
else
document.getElementById("btn").disabled = false; }
{code}
and then there is the actual pl/sql process which has a cursor
{code}
declareflg varchar2(1);
..begin selectflag into v_flagfrom table where rownum = 1;
-- actual conditions are different but this returns one value.
Then below using htp package I had html table with something like
<td align="right">
<button class="btn btn-success" type="button" id="btn" onclick="check(flg);"
title="Accept Lead" style=" width:50px;">Flag value</button> </td>
{code}
For some reason the script function is not called if I use onload. If I change the onload to onclick it works. Also, if I pass check(flg) it does not work. If I use check(''N'') then is works fine. question is how do I pass a pl/sql variable flg in this case to a javascript function as a parameter? I basically, want the value of flg checked on page load and then if it is N then disable the button. Or else keep it enabled.
Application Express :: Additional JavaScript For Websheet?
Oct 11, 2013I need some functionality in current (4.2.2) APEX websheet which seems not possible out of the box.Therefore I'd like to ad a javascript to my websheet application.
View 0 Replies View RelatedApplication Express :: Passing Item Values To Javascript
Nov 23, 2012APEX 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 ?
Application Express :: Updating APEX Collection Via JavaScript?
Aug 1, 2012Note, I'm using APEX 4.1.1
The scenario is that I have tabular form that was manually created from a collection; the collection name is "COMPANY"
Within this tabular form, I have number of selection lists (apex_item.select_list) and for each, I fire off a JavaScript based on the "onchange" event (e.g.,'onchange="updateCollection(' || seq_id || ', 10, this.value)"'); updateCollection is a custom function I created. Right now, all it does is alert me with the specifics of the of the selection list. As a further example, if I select "Google" from the selection list, sequence id would be "1", attribute number would be "10" and attribute value would be "Google"
Within this JavaScript, I would like to update the value of this associated element in the "COMPANY" collection. Ideally, I would like to directly call this:
APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE(p_collection_name => "COMPANY", p_seq => 1, p_attr_number => 10, p_attr_value => 'Google') but I could not figure out how to do this.
Application Express :: Javascript Function For Tabular Form Changes?
Apr 12, 2013I have a tabular form with a few columns. THey are ID, date1, date2 and task_name. The task_name is a drop down list of tasks. Upon selecting a specific task, I want the date1 and/or date2 columns to become read only (voided out) so users cannot enter in data. I am working with a tabular form, so I figured I need a javascript function to handle the logic and to call the function in the html elements of the column in the apex environment. This will need to happen dynamically (on click) before the page is submitted. I am more lost/confused on syntax. I know I will need to know the actual column name (coo1, coo2, something like that) of my columns that I will be refering to when I use javascript.
View 2 Replies View RelatedApplication Express :: JavaScript API To Set Item Values Not Working In 4.2 EA2?
Aug 7, 2012I 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 RelatedApplication Express :: Can Open Page 306 As Modal Window But Page Closes Immediately
Nov 13, 2012i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
Application Express :: Add Field In Page Title Or Repeat Header On Each Print Page
Jun 4, 2013We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.
Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.
Application Express :: How To Create A Text That Links To Another Page From The Login Page
May 21, 2013In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.
With a button, its simple because its inbuilt there,but I do not want a button,just this: Register
I want also to have the text in color not black.
Application Express :: Passing Item Value To Another Page Via Button Set To Redirect To Page
Jul 16, 2013I am new to APEX and I am developing an application to manage Oracle database user accounts. I have a page (8) that has text items for the username and the database name. I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account. I have another button that should:
get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11
The issue is that FIND_USER_IN_DB does not get populated and page 11
which is a simple report with the following query:
SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB;
How do I accomplish this?
Application Express :: Navigate To Authorized User Page 5 - Keeps On Going To Page 1
Aug 17, 2012I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .
View 8 Replies View RelatedApplication Express :: Error In Javascript Not Fetching Value On Button Click
Nov 23, 2012I 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.
Application Express :: Value Changed By JavaScript Submitted As Null When Using $x_disableItem?
Oct 21, 2012Had some issues with a page on which i changed the value of an item using javascript and added a dynamic action (dummy pl-sql) that submitted the item. The problem was that if i also used $x_disableItem to disable the item in the function that set the value , the value submitted was always null. However if i used the "Disabled" attribute from the item Settings and remove the calling $x_disableItem in the function, the value submitted is correct.
To reproduce , create these objects on a page (default everything not specified):
<li>P1_VALUE - textfield
<li>P1_SET_VALUE - button calls "javascript:setValue();"
<li>P1_SUBMIT - submits the page
<li>Dynamic action:
- Event - Before Page Submit
- Execute PL-SQL (begin null; end;) - Page item to submit P1_VALUE
[code]....
So i have two questions:
1) Why is the implementation different (would have expected to behave in the same way)?
2) When using the javascript API function $x_disableItem , why is the value submitted null?
P.S: For the workaround i removed the $x_disableItem call with calling a custom function that toggles the read-only attribute of a given item.
Application Express :: Capture On Change Event For Select List Using JavaScript
Nov 15, 2012Is there any way I can capture on change event for the Select List (already created on the page) using java script and then refresh chart region?
View 2 Replies View RelatedApplication Express :: Syntax Error In Javascript Processing A Tabular Form
Sep 21, 2012I have the following code which allows me to disable the "f04" field if pThis is set to 'N'
<script type="text/javascript">
function hide_show_comments(pThis){
//get the curren row index on change
[Code].....
Application Express :: Change Form Text Field Label Using Javascript
Oct 22, 2013I have a field that will be providing different info based on document type. I would like to change the field label from javascript in DA.
View 3 Replies View Related