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


ADVERTISEMENT

Application Express :: Positioning Sub Regions

Aug 28, 2012

I have created a Search Sub region within a reports region. But the sub region is created at the bottom of the reports and I am unable to move it to the top. I want it to be displayed on top of the report but within the reports region.

View 4 Replies View Related

Application Express :: Display Horizontal Sub Regions

Mar 4, 2013

I am using APEX 4.0, my regions need to be displayed at "Display Point: Display Template Body 2" in column 2.I have 2 regions I want displayed horizontally, side by side.I want to use a parent region to contain them. I create my parent region, called it A, template = Reports, assign it to sequence = 10.I create my 2 sub region (B) and (C), sequence 20 and 30, template = Navigation, picking parent = A.By default, B displays above C. URL....

I copied the Navigation template, creating a new one called NAV2 and added this in the sub-region template section:(this cut/paste) doesnt display well here: it is the exact DIV begin/end block as posted above.

div style="float: left;"
#SUB_REGION#
div

I changed regions (B) and (C) to use template = NAV2, without any change in display behavior.I read further in the above post where it was recommended to reset the clear property, so I changed the above style like to: style="float: left;clear:none;".

View 5 Replies View Related

Application Express :: How To Connect List Of Values To Regions

Aug 20, 2013

I created list of values like Bar chart,Column Chart,Pie Chart.these list of values added to the text field named as Chat type. In same region i created 3 chart sub regions. My requirement is if i select chart type-pie chart.the page will show only pie chart region only.Same to Bar chart and Column charts also. 

View 3 Replies View Related

Application Express :: Oracle Apex 5 SOD - Multiple Regions

May 24, 2013

In Oracle Apex 5 SOD it says it will have the following feature:

"New Multi-Row Edit Region Type – Define a new region type with a modern UI for updating multiple rows of data and allow multiple regions on one page"

[URL].......

If so, how likely it will allow dynamic query (PL/SQL) in addition to simple query? Also, how likely it will include advanced features like frozen columns with group headers, subgrid, etc.? It will be nice if the grid will adjust itself based on the width of the screen.

View 2 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 :: 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 :: Inserting Into Two Tables From Two Regions In A Page

Aug 2, 2012

I am using apex 4.0.2.00.07. I have a page with two regions. The first region has only one row and I have no problems accessing it and inserting those values into the table this is what I used to access one column from that one row APEX_APPLICATION.G_F03(1)

The second region is an interactive report, to which I have managed to add a checkbox and a textbox.

1)So if a checkbox has been checked off the row should be inserted
2) if the textbox has been entered it should replaceone of the values.

My question is how to access the second region? I started a loop based on the rows in the collection but that is as far as I got.

FOR idx IN 1..l_collectionTable_name
loop
end loop

View 0 Replies View Related

Application Express :: How To Align Items In A Form Page With Respect To Regions

Oct 16, 2013

I have 20 item fields in same form. i need to align them in sequential manner. For example x  y   z  abcl  m  o p   q   r   s   xyzabclmopqrs  are the items to achieve this what i have to do...

View 2 Replies View Related

Application Express :: Hiding / Displaying Regions Using Radio Button Not Working?

Jun 30, 2012

APEX 4.1 / 11g
Theme 21

I have a page with about 8 Classic reports. 4 of them percentage values, 4 totals. I have one RG with a Percentage or total option. When I select the percentage radio, it should hide all the total regions. When I select the totals radio it should hide all the percentage regions. Simple? So I thought. This is what I did.

1. Created a RG(P2_RG) -> Page value is redirect and set value.

2. STATIC:Percentage;P,Total;T

In the RG, I have created a normal DA which has the true and false events as follows.

Event -> Change
Items -> P2_RG
equal to -> P

In the true actions, I have hidden the 4 totals regions.
shown the 4 Percent regions.
In the false action, I have shown
hidden the 4 percent region
shown the 4 totals region.

The event specification for one these true actions is

Action -> Hide (If I am hiding)
Fire when event is ->True
Selection type -> region
Region -> The region I want to hide/show.

But it does not work! I tried to replicate the issue on apex, by using a small example but could not. Works fine in apex following the same process.

[URL]

I tried to debug by having a display item to show the value when I change the radio button. The values are changing properly. I tried actually, adding a condition filter in the region itself by using the "Value of item/column in expression1 = expression 2" where expression one I tried :P2_RG and expression 2 as P but that just hides the whole region.

View 5 Replies View Related

Application Express :: Bug Report - Conditional Regions Affect Grid Layout

Mar 20, 2013

I had a few regions on my page, the 2nd did not start a new row so it appeared horizontally where possible.During some experimentation, I created a new region with a sequence in between that started new row, but even when that region was conditionally never, my original 2nd region started on new row.

Original:
Region 1 - Region 2(empty) - Region 3 (new row/col no)>
New region added:
Region 1Region 1.5 (added, new row)
Region 2
Region 3>
Region 1.5 not shown:
Region 1Region 2
Region 3>

Let me know if you would like a test case for better visualisation.

View 3 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 :: 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 :: Conditionally Display Html5 / Flash Chart Regions Depending On Browser Compatibility?

Nov 12, 2012

APEX 4.2 Theme 25 Oracle DB 11gr2 - I need to conditionally display Html5/Flash chart regions depending on browser compatibility, how to achieve this.

View 8 Replies View Related

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 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 :: 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 :: Changing Sequence In Content Frame Not Changing Ordering Of Regions

Apr 24, 2013

Using Application Express 4.2.1.00.08

Any problem using 4.2's One Level Tabs - Content Frame page where you have a parent region (of type content frame Body Container ) while number of child regions (of type Hide & Show Region - Borderless ), if you want to re-order them by changing the sequence, it has no effect when you run the page.

The regions still show in the same order top to bottom as it did before the update of sequences. Heading links (to show/hide child regons in content frames) has the same ordering as before.

View 3 Replies View Related

Replication :: Oracle Streams Vs Share Plex

Aug 31, 2011

Till now my company used Share Plex for replication 6 DBs from different location to one server (used for BI operations).

1) Replication in in real time
2) All DBs are Oracle but different versions 9 and 10 .
3) We have horizontal and vertical replication. We replicate just some tables, for some tables just some columns and for some tables just records with some conditions
4) We have different charsets.
5) SharePlex have compare/repair tool to check it DBs are in sync mode

I started to look for Oracle Streams to use it instead of SharePlex. Do you know if it is able to handle that type of replications? Do you know about any Oracle Streams limitation which eliminates it?

View 5 Replies View Related

Data Guard :: Failover Standby Rac / Share Steps For Failover

Aug 26, 2010

In my production -- we have 3 nodes Primary RAC with 2 Nodes Physical secondary Standby RAC. Due to some reason we will have to failover means 3 nodes Primary Standby RAC to 2 Nodes secondary physical Standby RAC. share Steps for Failover ( not switchover) from 3 Nodes Primary RAC to 2 Nodes Physical Standby RAC. I know this is generic and can be find from google but issue is how can failover from 3 nodes primary standby rac to 2 nodes secondary physical standby rac.

View 3 Replies View Related

Forms :: How To Share PL/SQL Variable Between 2 Forms

Nov 20, 2010

I create 2 forms

form 1: I used the Departments table to create this form

in form-level trigger : When-New-Form-Instance

go_block('departments');
execute_query;

there is a control block with name (CTRL)

there is Exit button with trigger When-Button-Pressed exit_form

there is a text item to print the department_id that i select this is for confirmation. I populate this item by (department no) button When-Button-Pressed

my_data.department := :departments.department_id;
:CTRL.TEXT_ITEM8:= :departments.department_id;

Now this part has the global shared pl/sql variable when i press in the button POPULATE_AND_SEND with a trigger When-Button-Pressed

my_data.department := :departments.department_id;
OPEN_FORM('c:Shared_PLSQL_Variablesemployees.fmx',ACTIVATE,NO_SESSION,SHARE_LIBRARY_DATA);

form 2 in this form i used employees table it will display the data that is content in the department selected from the first form it only has form-level trigger When-New-Form-Instance

IF my_data.department IS NOT NULL THEN
SET_BLOCK_PROPERTY('employees',DEFAULT_WHERE,'department_id='||to_char(my_data.department));
:CTRL.TEXT_ITEM8:= my_data.department;
GO_BLOCK('employees');
EXECUTE_QUERY;
END IF;

this is the code in .pll file that i attached in Attached Libraries

PACKAGE my_data IS
department number;
END;

when I run this forms and press in (DEPARTMENT NO) button it's not display any thing in the text item I received this error check the link.

same error when i press in POPULATE AND SEND button to open the other window and execute query.

View 11 Replies View Related

Reports & Discoverer :: How To Print Into Two Pages

Jul 6, 2010

I am creating report a using emp table .There are 14 rows in emp table , i want to print output into two pages . If i set FILTER TYPE Property to 5 ,it only shows 5 records .

View 2 Replies View Related

Forms :: Set Horizontal For Each Tab Pages In A Tab Canvas

Apr 16, 2012

I have a tab canvas with 4 tab pages.I want to set scroll bars for each tab page. I draw 4 stack canvas on 4 tab page but it doesn't transferred fields in each tab pages.

View 4 Replies View Related

Reports & Discoverer :: One Report Two Pages

Oct 3, 2011

i'd like to fit two pages in one report. i.e i'd like to divide A4 paper into 2 pages. How to do that in report 10g . like in the PS

View 2 Replies View Related

Reports & Discoverer :: Between Pages Trigger?

Dec 17, 2010

I have idea about Between Pages trigger.But i don't know any practical example to do it.

View 5 Replies View Related







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