Application Express :: Redirect To Different Pages Based On User Input Value?
Feb 5, 2013
I am trying to redirect to different pages based on user inputs. I have a form in which I have one text item and a submit button. For example consider text item to be empno; So once the user enters a empno and hits submit button; I need to redirect to different pages based on this job.
For Ex:
if user inputs empno whose job is 'ANALYST' then redirect to page 1
if user inputs empno whose job is 'MANAGER' then redirect to page 10
For this scenario. i wrote a pl/sql process for the submit button; but no luck -- its not at all redirecting instead its in the same page. Below is the process.
declare
v_job varchar2(20);
begin
select job into v_job from emp where empno = :P9_EMPNO_R;
if v_job = 'ANALYST' then
OWA_UTIL.REDIRECT_URL('f?p=&APP_ID.:1:&SESSION.::&DEBUG.::', TRUE);
[code]....
View 1 Replies
ADVERTISEMENT
Oct 30, 2013
Is it possible to apply a new created UI Defaults to an existing page or pages in the application.If so then how?
View 0 Replies
View Related
Jul 23, 2013
I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
View 2 Replies
View Related
Apr 30, 2010
I have table in Oracle with one column PRODUCT. Column PRODUCT have following values -
Account Management
Active Directory
Adobe Acrobat Reader
NT Account
Application Security
[code]....
I am designing application where I need to search for PRODUCT based upon user's input. Lets say user wants search on 'Laptop Account Broken'. I want to search for all products which contains any of words in user's input. So based upon user's input I want output like below.
Expected Output:
Account Management
NT Account
WebSite Account
HP Laptop
View 2 Replies
View Related
Nov 25, 2012
Oracle XE 11g
Apex 4.1 which was upgraded from 4.0 long ago.
Win 7
I've changed the "Require HTTPS attribute" to Yes on the Security Settings page in Oracle Application Express Administration Services[URL]...and after applying the change, going to the DEV or administration pages [URL]...results in a redirection to [URL]...(again, respectively), and a redirect loop error.
When going to[URL]..., the browser redirects to[URL]...and gets the old-known "Application not found" error (which is OK, I guess - the error, not the redirect address).And the most strange thing - when going to the app I developed directly[URL]..., it works OK (no edit buttons, though, although I log in as admin).
View 2 Replies
View Related
Nov 10, 2010
Need to access data in a table base on user parameter input where the data is stored like a spreadsheet with column headings JAN, FEB, MAR... and the rows are the years. Is there a way to create a generic SQL statement so that I don't have to have 12 if statements in the procedure?
View 5 Replies
View Related
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
Feb 5, 2013
i jquery mobile oracle apex ver Application Express 4.2.0.00.27 i just cant pass parameter between two page on submit button.At the end i am trying to set this imte P4_NOTE with this values &P2_NOTE, all are basic text box. my link look like URL.....
when i pass default value on P2_NOTE i get good result. How do i lose item value during submit?How do i need to set P2_NOT ?!?!?!
View 9 Replies
View Related
Feb 21, 2013
I have an application that it will have over 200 pages. Each page will have a sidebar region with a number of lists, around 8-10 items. The lists references all pages in the app. Then, if I create a new menu list , I have to include this new list in all pages, it's painful. It's posible to have shared regions between pages like the shortcuts for messages in the user interface elements?
In this way, I will create an unique element including all lists that will be shared through all pages. This will greatly facilitate the work!I'm using Apex 4.1.
View 4 Replies
View Related
Jun 5, 2013
in APEX 3 i always had a report showing all linked pages and components...
The Report was located here: Home>Application Builder>Application ID>Application Reports>Page Components>Related Pages and Components I have now updated to APEX 4 and i can't find this report anymore.
View 3 Replies
View Related
Jun 5, 2013
We have created a lists (shared objects) with a couple of links which is displayed on all application pages. It is easy to maintain. My question is that the links open in the same page. I was hoping we could use something like a "Target=_New"..I guess the only other way would be to manually code this as a HTML region in each page using <a href> as the last resort!
View 3 Replies
View Related
Nov 14, 2012
I have been given the task to modify our company's Apex from 4.1 to 4.2. The upgrade has been completed; in addition, the current UI, blue and tan has been updated to BlueJay. I have noticed the structure of the page gets shuffled as well as contents within modules. What would be the best way to "re-organize" my pages.
- Would it be easy for me modify the page, if so how do I do this. The settings look identical, so what would I change ?
- Do I recreate the entire page from scratch ?
View 15 Replies
View Related
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
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
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
May 18, 2013
APEX Version : 4.2.2
Application : TRQ_APP
[URL].......
I have a menu list defined in page 0 - when the menu list is displayed in home page (Page 1) it looks fine but in others pages it displays differently
To have the menu list displayed in all pages of application as it is in page 1.
View 5 Replies
View Related
Aug 5, 2012
I have a system that has issues with sending some emails.
When the email sending process is activated the pages just hang.
Are there any logs or anything like that anywhere that i could look at to try and make sense of it.
View 1 Replies
View Related
Nov 28, 2012
I would like to enter input in for a select list. That is, if I have a select list for the common colours (blue, green, red, ... ) that a user could query on, then I would like a user to be able to type in the colour - purple in the box next to the select list. I've looked at the select list options and couldn't see anything obvious?
View 2 Replies
View Related
Jun 11, 2012
I'm using apex 4.1.1 And i want to use a Date Picker item on my page. This works, but.. When a user selects a date you can see the date highlighted. But in the "textarea"corresponding tot the datepicker is not showing the date. This shows the date after clicking the close button.
I would like to show the date directly after selecting a new date.
View 7 Replies
View Related
Oct 29, 2012
I have been tasked to look at a technology / frameworks that will allow our company to develop tools that is quick and easy to learn and easily supported. We use Oracle architecture extensively in the organization and also have APEX 4.2 installed for development purposes. We have two basic requirements or functionality that we need to implement and I and now looking at a proof of concept to determine whether we should adopt APEX or not.
1. Forms Based Tools
We have many databases with static content and users would like to have access to the data via a form. The form will allow the user to enter parameters (eg date) and on hitting a "Submit" Button, the database will be queried and a report generated and presented.
2. Diagnostics Tools
This is a bit more involved and we require a view of our static data in real time. If a specific KPI threshold is violated (eg MOC < 85%) we would like to present an alarm on a dashboard showing the alarm. For example if there are 5 entities that MOC < 85% we would like to show a "red" indicator. If no entities violate a threshold and are above MOC > 85% we want to show a green indicator. We also want a drill down function, where if the indicator is "red", a drill down will show the details of all the entities that have violated the threshold.
I have described our basic requirements, but if it can easily be done in APEX we will definitely motivate for its use.
View 1 Replies
View Related
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
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
Sep 26, 2012
I have a need to change the LOV of a page item's select list based on the selection in another page item's select list. So in other words, for a page item that is a select list, I need to use one LOV normally, and a different LOV if the value of a different page item is set to X.
A dynamic action would be useful here (on change where Select List 1 = x), but I don't know how to take the action of changing LOVsfor Select List 2 based on that action.
View 5 Replies
View Related
Jun 29, 2011
I have created the Procedure P_GET_CURRENCIES. I want to sort the cursor query based on the Input parameter P_SORT_ORDER. For example if i pass 2 for P_SORT_ORDER then my query should be sorted by 2nd column. But i'm not getting correct Output.
PROCEDURE P_GET_CURRENCIES(P_START_ROW_NUM IN INTEGER
,P_END_ROW_NUM IN INTEGER
,P_SORT_ORDER IN number
,P_CURRENCY_DATA OUT SYS_REFCURSOR
,P_RETURN_MESSAGE OUT VARCHAR2 )
AS
[code]....
View 3 Replies
View Related
Jun 20, 2013
How to truncate the partition based on the given input. I've below table partitioned on dt field. How can i truncate the whole partition which contain the date 2013/04/30.
CREATE TABLE TST_SUMMARY
(
CUST_ID NUMBER(38) NOT NULL ,
[Code]....
View 21 Replies
View Related
Jun 10, 2013
In APEX I've always created form on report so as to have the list of records of a table and the possibility of inserting/updating every sinle record by means of the form on it, ok?I have an application concerning classic costumers, orders, ... with a table for every item.
The problem is that I have to gather all information ao as to produce a classic bill with a typical layout where you have on your left some descriptions and on your right an amount but of course the layout is not based on a classic table, do you mean?Do I have to create a table in which I'll add data and null values so as to get the layout desired
View 2 Replies
View Related
Nov 19, 2012
I have created three accordians where there will be sub tabs under each Accordian. There will be two logins. Where when i login with Admin all the 3 accordians will be shown. But in the user logins 1st Accordian will be hidden and only 2nd & 3rd will be shown with their sub tabs.
In order to highlight the tab & also for Accordian to be open based on the selection, i wrote code as follows
$("#R16463536713741058563").accordion('activate',0);
in the page under the Execute When Page Loads region where ('activate',0) means the position of the accordian which will be taken as 0,1,2..etc.But when i login as user then as the 1st accordian will be hidden & the 2nd and 3rd accordians will become 1st & 2nd. So 1st & 2nd accordian wil be consider as 0,1 positions here.
So when i click on the 2nd accordian tabs then the accordian is not opening because in the pages of this accordian tabs i have given the code as
$("#R16463536713741058563").accordion('activate',1);
as the active is 1 so the accordian in position 1 is opening but i want the accordian in 0 position to be opened as i selected the tab under that accordion only.
View 0 Replies
View Related
Aug 2, 2013
I need to order the result set with different data types based on the input parameter.
select * from scott.emp sc order by decode('&input_parameter',1,sc.empno,2, sc.ename);
If the input_parameter is equals to 1 then,ordering should be based on EMPNO which is Number data type.
If the input_parameter is equals to 2 then,ordering should be based on ENAME which is Character Data type.
Above query was failed for input_parameter 2,as we know that decode should return same data type.
View 6 Replies
View Related
Oct 1, 2013
i have used radio button under dynamic conditions for an interactive report.eg: radio button values are like a) front end b)middlware c)back end.so based on the selected value of the radio button, interactive report appears. and each fields in radio button have separate set of users. now my issue is,based on the user logging in, the default value should set up while the page is loaded...[i.e... if a front end user logs in, the default value of tat radio button shd be front end...]
View 5 Replies
View Related
Oct 27, 2013
db11gxe , apex 4.0 , firefox 24. I want to do automatic row fetch when the value of a select list changes ?but first i should ofcourse create a tabular form to fetch the data into it , but what i want is ,if i fetch 2 rows then the report contains only two rows , if i fetch 3 , the report contains only 3, if i fetch nothing , the report has nothing ?
View 0 Replies
View Related