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
ADVERTISEMENT
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
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
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
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
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
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
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
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
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
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
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
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
View Related
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
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
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
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
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
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
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
May 21, 2013
In 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.
View 6 Replies
View Related
Aug 17, 2012
I 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 Related
Jul 12, 2010
I have a Report With Group G_Emp, having Columns Eno, Ename etc. in a Repeating frame R_1 and I have put A frame below this repeating frame R_1 with a Text Item Just for Displaying Comments, so just i want to display this Text Item in the second page and the Employee details in the first page, the restriction is that the Text item should not print in the first page.
View 2 Replies
View Related
Jan 23, 2013
I have installed APEX on my local machine, created a workspace, and added a few users with roles.
I am creating an application, similar to a Library app, where I have a table that stores Books information (BOOK_ID, BOOK_NAME, etc). I'd like to create another table BOOK_USER with two columns, BOOK_ID and USER_ID. BOOK_ID would refer to the BOOKS table, and I want USER_ID to refer to the table that stores user details of the workspace that I am using. The data entry would happen from a page that has two LOVs, one for book name (using BOOK_ID as the value) and another for user name (USER_ID, or whatever field APEX uses to store user's ID). Can I do that in APEX? I've found ways to access and authenticate a user for a page, but how to get data of all users in the workspace? In other words, how to get all usernames in a LOV?
View 5 Replies
View Related
Jul 2, 2013
why the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:
[URL]............
returns nothing for me!
View 1 Replies
View Related
Oct 3, 2012
i am facing a problem in functionality of a form as there are different search parameters:
date from: text item-->mandatory
date to: text item---->mandatory
house type: list item-->optional
form_status: list item->optional
order by: list item---->optinal
untill i don't select house type by list item everything is working fine and gives desired result, even with house type if i select any house type result is fine but as i select last list item of house type which is null as i want result without house type then it gives no any data as data is present in database.
for example:
date from: 20-05-2009
date to: 21-05-2009
with these two i got the correct result, then i select
house type: 3
i got the correct result and when i change list item to any value like: 1,2,3.....it is working fine but as i want result without house type by selecting the null value in list item as:
date from: 20-05-2009
date to: 21-05-2009
it is not picking any data from database. but the same search criteria in 1st case as i described above giving result.
declare
qry varchar2(5000);
n number;
alert number;
[code]...
View 5 Replies
View Related
May 9, 2012
How to get the label (not value) of current selection in a List Item.
View 7 Replies
View Related
Jan 6, 2011
I have a requirement to select multiple values from a list item and do some manipulations with those values. I tried by integrating the LOV with a text item, but couldn't able to select multiple items. Is there a way to do multiple selection in a list item ?
View 1 Replies
View Related
Aug 3, 2012
I'm using one of the new Date/Time picker items in Apex 4.0.2. When the user clicks the Calendar image the Calendar is displayed with the current date and time. However I would like it to display by default the current date and a time of 1000hrs.
View 1 Replies
View Related
Nov 13, 2013
I have "After header" process (with PL/SQL code) in "Page Rendering" section and want to navigate to some page after this process has been completed. I created a branch (On Submit: After Processing) with Target Type: URL. But this branch is executed only after "Page Processing", not after "Page Rendering". Maybe , there is any APEX API functions for pages navigating..
View 2 Replies
View Related
