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

Application Express :: Apply User Defaults To Existing Applications Pages Reports

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

Application Express :: JSON Error When Trying To Redirect To Another Page In Same Application?

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

SQL & PL/SQL :: Searching PRODUCT Column Based Upon User Input?

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

Application Express :: Redirect Loop On Application 4550?

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

SQL & PL/SQL :: Column Access In Table Based On User Parameter Input

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

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 :: Passing Value Between Pages

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

Application Express :: Share Regions In Different Pages?

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

Application Express :: Related Pages And Components Report?

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

Application Express :: Open Lists In New Tabs / Pages?

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

Application Express :: 4.2 Theme Upgrade - Best Way To Reorganize Pages

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

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 :: 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 :: Create A Global Region In Page 0 And Then Access It From Other Pages?

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

Application Express :: Menu List Look Change Between Home Page And Other Pages

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

Application Express :: When Email Sending Process Activated Pages Just Hang?

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

Application Express :: Enter Input In For Select List?

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

Application Express :: Show Input After Selecting Date In Datepicker?

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

Application Express :: Dashboard And Basic Input Forms And Reports

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

Application Express :: Fetching Values From HTML Textbox Or Any Input Type?

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

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 :: Change LOV Based On Another Field Value?

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

SQL & PL/SQL :: Order By Based On Input Parameter?

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

SQL & PL/SQL :: Truncate Partition Based On Given Input?

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

Application Express :: Creating A Report Not Based On A Table?

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

Application Express :: Highlighting Accordion Based On Selection

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

SQL & PL/SQL :: Ordering The Result Set Based On Input Parameter

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

Application Express :: Default Value Of Radio Button Based On A Condition?

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

Application Express :: Automatic Row Fetch Based On Select List

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







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