Application Express :: How To Assign Concatenated Output To Item On Page Load

Dec 27, 2012

I have a table that reads something like this

City Route
NewYork 2
NewYork 4
NewYork 5
London A
London B
Paris X1

I want to assign Routes (concatenated) to an item on page load... as an example for NewYork it should read like this

P2_ROUTE = 2, 4, 5

I am looking to do the above using query, something like this

select (concatenated route)
from Table_A
where
City = :P2_City

how to concatenate variables.?

View 2 Replies


ADVERTISEMENT

Application Express :: Assign A Value 1 To Page Item / Whenever Key Is Pressed

Jan 11, 2013

I need to assign a value 1 to a page item whenever key is pressed:Here what I did:

1. Created a item P1_SHOW
2. Created a dynamic action
Event : Key Press
Selection Type : Item(s)
Item(s) : P1_SHOW

True action: pl/sql
:P1_SHOW := 1;

View 2 Replies View Related

Application Express :: Reset Data Picker Page Item By Selection Page Item

Aug 23, 2012

Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.

Issue here is unable to find a way to set the page range item values based on the quarter field selection

how to reset the page item fields.

View 0 Replies View Related

Application Express :: JavaScript Assign Value Is Not Visible To Page Process

Aug 21, 2012

I 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

View 3 Replies View Related

Application Express :: Assign To Item List Of Value According To Contents Of Other Fields

Oct 18, 2013

Let me explain, I have two items in my page, the first is not required, if it is null the second field is a value list based on selection A (select from A. .. A. .. where . A..) but if the field is not null then the list of values ​​of the second field is based on the selection B (Select B from B where B. ..). 

I create a dynamic action on the event "change" of my first field,  on the "true action" I tried this: 

declare  vva_ternum Varchar2 (3): = null;Begin   APEX_ITEM.SELECT_LIST_FROM_LOV (2, : P26_TERNUM, 'LOV_RSPRODUIT_TERRITOIRE'); End;  

But it does not work!! 

View 5 Replies View Related

Application Express :: Passing Item Value To Another Page Via Button Set To Redirect To Page

Jul 16, 2013

I 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?

View 8 Replies View Related

Application Express :: How To Submit Page On Load

Oct 4, 2012

i m using apex 4.1, and want to submit page when page load. i tried dynamic action but it continuously refreshing page. is there any other javascript or anything else from which i submit page on load

dynamic action used, event on load and action submit page but it continuously submitting page.

View 5 Replies View Related

Application Express :: Show Progress Bar While Only On Page Load?

Nov 13, 2012

I want to show progress bar every time when page loads.

Progress bar is coming on the page. but it is not going off after page is loaded.Below is the code which i added for the Progress bar.

//written on Header Text of Page
<script type="text/javascript">
<!--
function html_Submit_Progress(pThis){
$x_Show('AjaxLoading');
window.setTimeout('$s("AjaxLoading",$x("AjaxLoading").innerHTML)', 100);
}

[code]...

I want only to show only page loads.

Apex Version : Apex 4.1
DB Version : 10g

View 2 Replies View Related

Application Express :: Hiding Regions On Page Load?

Jan 3, 2013

I have a page which, upon page load, some regions should be hidden. I've created a dynamic action which hides a couple regions (on page load), however I can see the regions for a moment as the page is loading, then disappear. Is there a way to ensure the regions are hidden when the page is rendered?

I've also tried using javascript, but I have the same issue (the regions are visible for a moment, then disappear).

View 6 Replies View Related

Application Express :: Page Load DA / Shouldn't Run Until Document Is Ready

Apr 18, 2013

Should the page load D.A. fire not until the dom is ready? Or is this not necessarily the case.I'm running a page over a slow connection, so the event (true action: execute JS) is being executed before the page is ready to handle the code. I would think this event should not run until the DOM is ready.

I have confirmed this by wrapping the code in document.ready, and it behaves as expected.

View 0 Replies View Related

Application Express :: Select List Default Value On Page Load

Aug 5, 2013

Basically I have a report that as part of it's source sql takes in an element from a select list. 

E.G. SELECT * FROM table_name WHERE table_column = : P1_SELECTLIST 

This works fine when the user selects an option from the select list however the first time the page runs it always returns data not found. The options correctly appear in the select list as they should without any nulls although it seems the select list is still initializing as null. I have been told to try and add a computation before the header on the select list item, although I'm not sure if this would work/how to do this.?

View 4 Replies View Related

Application Express :: Two Validations On One Page Item?

Jun 13, 2013

it is possible to have two Validations one Page Item. Also I need to execute them one by one. If one is passed then go to the other and validate that one. 

Example:P20_FORM_ACTIONP20_REOPENP20_REASON Validation 1: P20_REASON  != 0 with condition P20_FORM_ACTION = CLOSEIf Validation 1 is passed then go to Validation 2Validation 2: P20_REASON  != 0 with condition P20_REOPEN = YES

If Validation 2 is passed, then submit the form otherwise get error.  is possible in Application Express 4.2.2.00.11. I tried to put the validations as described above into my application, but it did not work. Only one Validation was executed. 

View 6 Replies View Related

Application Express :: Dynamic Page Item Name

Nov 1, 2012

I have a from with some fields (VELD01, VELD02...VELD11) and a page process that fills that field. I want to make that more dynamic using a loop. Is it possible to use some 'dynamic SQL' like:

l_cnt := 1;
for r in c
loop
P1210_VELD0||l_cnt;
l_cnt := l_cnt + 1;
end loop;

Example above does not work of course...

View 3 Replies View Related

Application Express :: Create Collection In A Process To Fire On Page Load

Dec 31, 2012

My collection is not working as expected, what could be the issue here. This is what i did,

1. I created a collection in a process to fire on page load

if apex_collection.collection_exists(p_collection_name=>'MMMM') then
apex_collection.delete_collection(p_collection_name=>'MMMM');
end if;
APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'MMMM');

2. On my page i have a text field P1_text1 when i enter value into text field like ="sample data" i want this data loaded into my collection, so i created a button and added a process(on submit - before computations...) so it should insert into the collection when i click the button but no data is loaded, process:

APEX_COLLECTION.ADD_MEMBER(
p_collection_name => 'MMMM',
p_c001 => :P1_TEXT1,
p_c002 => 'TESTDATA' );

3. when i run the below query it shows "no data found" ,

SELECT c001,c002
FROM APEX_COLLECTIONS
WHERE collection_name = 'MMMM';

View 4 Replies View Related

Application Express :: JQuery Mobile - Popup Only Opens After F5 / But Not On First Page-load

Feb 12, 2013

how to combine APEX 4.2 with jquery mobile componentsOn one page with a hole bunch of components there is also a popup-div<div id="myPopup" data-role="popup">

 <!-- close button, safe button, input field and short list... -->
</div>It gets opened with js:  $( "#myPopup" ).popup( "open" );

This all works fine, besides the face that it only works after refreshing the page! The page gets loaded via js:    $.mobile.changePage('f?p='+ $v('pFlowId') +':20:' + $v('pInstance') { transition:"slide", reloadPage:true });...

which also works fine so far. That same problem I had before when I was using a dialog instead of the popup. - only showing after refreshing the page.

This certainly must have something to do with how JQM loads and renders the page (besides the APEX-job) - a rather basic issue. I have also tried different ways of calling the page, with no difference to that problem.

View 6 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 :: Page Item Only Refresh Into Session?

Mar 24, 2013

I have some troubles with a "Set Value" Dynamic Action. What I want to do is set a Page Item with a specific variable derived from javascript. So basically I have a javascript variable 'test' that is being changed in javascript code. I am using a dynamic Action "Set Value" to set this value into a page item. As source, Im using "Javascript Expression". It is working, however, the Set Value Dynamic Action with JAvascript expression does not reflect this change in the session, so the page item is not updated.

I tried:

$s -> does not work
apex.submit -> does work, however submits the page. I need to submit only the Page item.

View 3 Replies View Related

Application Express :: How To Use Display Image Item On Page

Sep 24, 2012

APEX 4.0 Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server

I have a table which contain 3 columns, see below:

id primary key
pic1 blob
pic2 blog

there is 1 row in it(id=1), just for display 2 images.

Uploaded 2 images into above Blob fields by file browse function. Now, I want to show the 2 pictures in a Region by using display image item P1_AR, but it didn't work.

Based on: BLOB Columns specified in item source
Alternative Text Column: null
Filename Column: null
BLOB last update Column: nullSource used: Only when current value in session state is null
Source type: SQL Query(return single value)
Source value or express: select dbms_lob.getlength(PIC) from cp_pic where id=1

I got the error below after runing:
ORA-20999: P1_AR has to have a valid BLOB column as source

View 7 Replies View Related

Application Express :: Page Item Shared By Different Regions?

Jan 30, 2013

I have created two regions in one page. I created some items but would like to share the items for both regions. When you create the item, you have to select which region it belongs to. Those items are supposed to be used by both regions, so I wonder if it is possible to share the items instead of creating the same items for region 2. I know I can create application item, but how to share items among different regions in the same page.

View 6 Replies View Related

Application Express :: How To Get Cascading With Select List Page Item

Feb 22, 2013

Technical description:

Oracle apex version 4.1.0
Oracle Db 11g

how to set Value to select list page item based on the return value of other select list page item(before header process i need to include or need to write a process)

Example:

Select country: [This is my first select list ]

Select State: [ This is my second select list, which i want to set in before header process based on the first select list]

View 1 Replies View Related

Application Express :: Unable To Trigger JavaScript From Page Item?

Oct 22, 2013

I 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 

View 3 Replies View Related

Application Express :: 4.2.2.0.11 Page Item Session State Not Showing?

Sep 20, 2013

I have searched for comment on this, but could'n find. So problem is ... not all of the page items are showing in SESSION STATE.

View 4 Replies View Related

Application Express :: Prevent Interactive Report From Running Query On Initial Page Load?

Oct 1, 2012

I am on APEX 4.1.1, db 11g and I have a report which is quite slow to retrieve results from its query. The page has some filter fields (e.g. store code, dept code) in addition to the generic search field.

When the user lands on this page (from a menu page), the query runs before the page displays and this typically takes 1-2 mins without any filters yet set. The usual browser loading indicators are not obvious to the user and they might not be aware that it is working on the request.

I want it so that it will only run the query AFTER allowing the user to get to the page, let the user fill in some filter criteria and then click on the GO button. Therefore the query will run after the page is submitted. When you hit the GO button on the interactive report, a nice rotating apex_loader.gif appears, making it obvious to the user that it is working on the request.

I would prefer NOT to create 2 pages, one for user filter, and a second for the actual report as I have many reports/inquiries which fit this category and I would prefer NOT to have to create pairs of pages for each.

View 5 Replies View Related

Application Express :: How To Soft-code Page Number Portion Of Item Name

Oct 9, 2012

In 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?

View 13 Replies View Related

Application Express :: Display Page Item Values In HTML Table

Sep 7, 2012

I would like to have a table in HTML region and to display in the table some Page Items from the page.

I got the code like this:
{
<table>
<tr><td>&P1_ECEMEA_ASSISTANCE</td></tr>
<tr><td>&P1_ECEMEA_WIP</td></tr>
</table>
}

It shows the Page Item names as text, not the values. However this code without the table tags:

{
ECEMEA Request for CQT Assistance: &P1_ECEMEA_ASSISTANCE.
ECEMEA CQT Work in Progress: &P1_ECEMEA_WIP.
}

works and the Page Item values are displayed.

Is it possible to display the Page Item values in the HTML table at all or I have to use a different method of showing the values in a table? The above is only a snippet of the code. I need to display about 30 Page Items, formatted in a table with headings.

what kind of region is the best to be used or if I should only use some escape symbols in the table code.

View 2 Replies View Related

Application Express :: Dynamic Alignment Of Report Column And Page Item Value?

May 7, 2013

I have an interactive report which contains the columns like

<li>empno
<li>Name

In the above i have "empno" with a column alignment of left and a "Name" with a column alignment of left.

Whether it is possible to override the data alignment that we set in the report according to the value of the application item like

If my application item value is US, then i need the column alignment of both the column"empno" and "Name" to be left and if my application item value is AR, then i need the column alignment of both the column "empno" and "Name" to be right. Whether is it possible to achieve the dynamic alignment to the report data of both the columns "empno" and "Name" according to the application page item value.And also in the case of page item i have a page item with a name P1_NAME in which it has a Element Horizontal/Vertical alignment to left.

I need that element alignment of the page item to behave dynamically according to the application page item, like if the application page item is US then the element alignment of the page item has to be left and if the application page item is AR then the element alignment of the page item has to be right.

View 14 Replies View Related

Application Express :: Page Input Item Label Conditional Style At Run Time

Feb 6, 2013

We have an issue after migrating to apex 4.2.1. We have a select list and use another couple of dummy items to be used as its label instead of giving the text value to the LABEL control. Only one of the dummy items is shown as a label for the select list conditionally based on another value. It was working fine with the earlier versions upto 4.1, but with the introduction of grid in 4.2, its now displaying the select list on a new row (ie the lable in one row and the select list on the next row).

However, we really would like to solve this by having a way to display the label of the select list either in "required format style" or as an "optional style". The display style should be determined only at runtime.

Example. Say P100_MY_SELECT_LIST is the select list

The label for this item is "My Select List Label"

I have another dummy item P100_DUMMY

if P100_dummy = 1 then the label "My Select List Label" should be displayed in red and with an * *My Select List LabelOtherwise it should be in black and without * My Select List Label.

View 3 Replies View Related

Application Express :: Dynamically Update A Number Field By Summing Of Page Item Values

Jun 28, 2012

I'm trying to update a number field on an apex page by summing up the values of multiple page items. I've tried to follow this tutorial

[URL]........

especially the "Create a Set Value Dynamic Action Using PL/SQL" part.

In the tutorial example they return an page item value P3_SAL multiplied by a multiplier they've determined by another page item's case. What I want to do is much simpler in that I just want to add up multiple page item values and then display them in a number field at the bottom of the page.

so the code I tried to use based on the tutorial is in the tab: Home >Application Builder>Application 103>Page 3>Edit Dynamic Action>Create / Edit Action

Set Type: PL/SQL Function Body

PL/SQL Function Body:

BEGIN
return :P3_ITEM1+P3_ITEM2+P3_ITEM3;
END;

Page Items to Submit: P3_ITEM1,P3_ITEM2,P3_ITEM3

But it gives me an error that I need to declare the identifiers, yet it works if I only use one item and I can perform any arithmetic.

i.e.

BEGIN
return :P3_ITEM1+1000;
END;

View 2 Replies View Related

Application Express :: Can Open Page 306 As Modal Window But Page Closes Immediately

Nov 13, 2012

i 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.

View 3 Replies View Related

Application Express :: Add Field In Page Title Or Repeat Header On Each Print Page

Jun 4, 2013

We 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.

View 1 Replies View Related







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