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.
I've created a new appliacation which has a home page and I've created a report page which updates a table. I want to add a link to my homepage, as a text line for example UpdateTable, and when I click the link, it goes to my report page. I've had a look in my Apex CookBook, and it says I do this by using the Navigation region in my home page. The problem is I don't seem to have a navigation region in my home page. I thought initially it meant the navigation bar, but I now realise this is the header bar. Do you know how I can create a navigation region in my home page..?
View 2 Replies View RelatedI have leave application form based on the LEAVE table, it has the following columns,
leave_id(primary key)
emp_name
from_date
to_date
no_of_days
Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?
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.)
i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies View RelatedTechnical 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]
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.?
Apex Version: 4.2.0.00.27Theme: 25 I have a page that I need to divide by 8 segments, rather than 12 ( I will need to place items and buttons in one of the 8 columns). To begin, I have made a copy of the One Level Tabs - No Sidebar page template. I have tried to edit this template, and played with multiple combinations changing the Grid Layout and Display Points settings, but instead of creating a page that has 8 columns, that span the width of the page, I am just left with blank space. See attached:.[URL] And these are the Page Template Settings:[URL] Is it possible to change the body section of the page template to have 8 columns span the entire width, without the dead space?
View 2 Replies View RelatedI am trying to set the intial value of "Select List" to APP_USER the only first time when the page loads and use it to filter the report, any other time once the page is loaded the user should select another value from the Select List then click the submit button to display the details in the report, i tried to achieve this by setting "select List" creating LOV for Select List then set default=APP_USER but now the problem any time you click the submit button it reset the "Select List" from selected value back to default so how can you achieve this to set the value of Select List only the first time the page loads?
View 1 Replies View RelatedI want to place change password link at the upper right of the page where logout link is..
i m using apex 4.1
Is 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 RelatedI am using apex 4.1
I have a list on page 0 which is "Tabbed Navigation List" and there are three pages running on it.
I want to change the color of the button when i click on the specific button.
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 ?!?!?!
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.
I am using theme 4, topaz. Region_Position_06 is a home link.
I have placed a company graphic at this position on page zero, and when a user clicks it on any page, she exits that page and goes to the home page, a main menu page. So no matter how deep a user may be into the application's pages, she may always click this logo image and return directly to the main menu page.
This is convenient, but there is one problem. Clicking this logo does not clear the cache on the page the user is exiting or, for that matter, on any page in the trail of pages the user took to get to the current page. I navigate primarily with buttons and always clear the cache on a page when I exit it. I need to find a way to do this when a user clicks the logo image.
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.
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 RelatedI 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 ?
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.
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]....
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.
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.
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.
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.
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?
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 RelatedIs 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 RelatedI have built a Menu Framework using the following instructions.
[URL]........
I am facing 2 problems.
1. If the user is in a child application and clicks logout. He is taken to the login screen of the master application (Correct), but once he enters login details, he is returned to the child application (False). I think he should be returned to the Home page of the Master application.
2. If I set Session Timeouts in the Edit Security Attributes of the applications. Then if the user is timed out, he is sent to the login screen of the Master application (Correct). If he then logs in, he is sent the the Home page of the Master application (Correct).
Now if he clicks a link to a child application he is then sent back to the Master application login screen. He then has to login again. He is sent to the Master Home page and everything is then ok.
I am trying to implement a Jtree with Context Menu. When Context Menu is implemented the nodes wont expand or collapse.This happens with Sample Trees Packaged application for Project Documentation tree.
View 0 Replies View RelatedI'm looking for a solution to navigate through the drop down menu (APEX-Region-Plugin two level menu) by using the tab key and short-cut keys. How it could work?
View 0 Replies View Related