Application Express :: How To Pass Parameter / Create New Region / Set Display Point

May 3, 2013

On package application "Customer Tracking", there is good example about Modal Page. Quite simple but it work quite nicely.The step to create this Modal Page:

- Create new region, set display point: After Header and use region template: Modal Region and set the Static ID (eg. ActivityModal)
- Create the page item and put it on the above region (eyample: Name, Company etc.)
- Create a button, set the action to "Redirect to URL" and enter the URL target to: javascript:openModal('ActivityModal');

Now when you click on the button, the modal page will be display.How can I pass a parameter to the modal page, example: I want to pass text 'Johnny' to the Name page item which is on the modal region.

View 2 Replies


ADVERTISEMENT

Application Express :: Display PDF In Apex Region?

Jul 11, 2012

I have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.

I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned

[URL]...

View 20 Replies View Related

Application Express :: Display Row Number In Report Region

Feb 6, 2013

I would like to display the row number in the report region at the beginning of each row for each page (based on the number of rows to display per page).

So if the number of rows per page is 15, I would want to show each row from 1 to 15. When going to the next page (16 - 31) I would like to show row 1 to 15 again next to each row. And if the number of rows per page is 20, I want to see row numbers 1 to 20 on each page.

Since I believe an Update button only processes the current page, I would like to then use this row numbers (1 - 15) to get the values of the displayed column for each row to perform an insert to another table.

View 1 Replies View Related

Application Express :: Edit Region Display Selector

Dec 7, 2012

Is possible to remove the "show all" of the Region Display Selector? How can i do this?

View 8 Replies View Related

Application Express :: How To Display 4.2 Chart Region Title Dynamically

Aug 21, 2013

i I am using APEX4.2 and created

(1) a drop down list item called P38_DESK which contains a list of desks such as A, B, C

(2) a Chart region with region title: Chart Mvt by &P38_DESK.

(3) a dynamic action to "refresh" the Chart region if the value of P38_DESK is changed. 

I can see that everytime the desk is changed from the drop down list, the chart section/region gets refreshed accordingly but NOT the Chart's region title.

It only showed the first value I chose. e.g. Chart Mvt by A So in APEX4.2, how can the CHART's region title be changed dynamically ( without submitting the entire page ) to reflect the value from the drop down list P38_DESK ? 

View 7 Replies View Related

Application Express :: Possible To Display Null Item Value As All In Blank HTML Region

Jul 2, 2012

Apex 4.1
Theme 21

I have select list which has null and other values. I have created a blank HTML region with the following text

Report for the year &P2_YEAR. and for geography &P2_GEOG.

Now P2_YEAR works fine because, it is always populated with a year. However, &P2_GEOG has 'All' as null value since we can see the report for all geographies. However, if the all option is selected, the above &P2_GEOG. shows as null. Since its not a PL/SQL proc, I cannot put in a NVL. I am guessing one possible way is to write a PL/SQL code before region and then check if its null and then try to populate a new hidden field and show, something like that. Wondering if there is a way to do it directly in the HTML region?

View 0 Replies View Related

Application Express :: 4.2 - How To Pass Date Picker Parameter Into Query

Aug 19, 2013

steps to achieve this report I need a Date Column on top of the page Depending on the selected date, Result should be displayed below for e.g. 

suppose i select a date as 14-aug-2013

Enter Report Date ___________________ ( Date Picker)  Location Name      Report Date        Quantity           valueXYS                       14/08/2013          5000            1200000ABCD                     14/08/2013          2000                24000-------------------------------------------------------------------------------------------------TOTAL                                              7000            1224000 

View 9 Replies View Related

Application Express :: How To Create Different Bodies In Single Region

Jul 12, 2012

How to create more than 1 body in a single region. E.g i created report region and under body tag in region all other charts reports are created.

i dont want that .. i want to create different bodies in a single region.

View 2 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 :: How To Create A Display Field In Tabular Form

Oct 1, 2012

I am stuck at point.

using apex 4.1, created tabular form for inserting values from customer with a simple query

table name : customer
select
USER_ID ,
USERNAME,
PASSWORD,
STATUS,
PRODUCT_ID
from CUSTOMER

I WANT TO FETCH THE NAME OF PRODUCT FROM ANOTHER TABLE NAME PRODUCT_NAME, I WANT THAT WITH TABULAR FORM COULMN OF PRODUCT NAME IS ALSO DISPLAYED, HOW I DID THAT ? JUST WANT TO ADD COLUMN FROM ANOTHER TABLE IN TABULAR FORM.

WHEN I ADD TABLE NAME IN FIRST QUERY IT IS NOT WORKING GIVING ERROR ABOUT NOT JOINING THE TABLE

View 2 Replies View Related

Application Express :: How To Create A Display Image Item With Apex Functions

Jul 28, 2012

I'm working on Apex 4.1.1.00.23 in a 11g XE Data Base, I want to display a Image in a Report, I can do it using the "+BLOB Download Format Mask+", but the images displays at original size and I want to display them smaller.

I've read that you have to create a procedure, a SYNONYM and call them in the src of the img tag. as Zsuzsi Vadasz mentions here [URL] But I remember that I was able to create some items in reports with Apex functions, I think they were from APEX_ITEM Package, so I want to know if there is a way to create the "+Display Image+" item with one function of APEX.

View 2 Replies View Related

Application Express :: Pivot XML In Region

Jul 12, 2012

I tried to follow Pivot query using XML option in APEX

I can get the data into the xml serialized state, but how do I display the actual values in a region? See my example app below. I want the two far right columns in the Pivot XML region to duplicate what is in the original version.

[URL].......

View 3 Replies View Related

Application Express :: Region Of Interactive Report

Oct 31, 2013

I've created a interactive report, and i have more items than my window behaves. So, i want to separate in two regions, and put in one region a scroll bar. How i can do this?

View 3 Replies View Related

Application Express :: Items Align In Region?

Dec 18, 2012

I have 2 regions in my application one is html form region and another is tabular form .I created 6 items in html region and created DA for the items to hide according to the value of items and then created tabular form

find below the sample link

[URL]...

user name: aneesmohamed.m@gmail.com
psswd: symphony

once i select the first item(declaration letter) it will show the second item (applicacable) perfectly,but when i select applicable as yes and discrepancy then all the items become misplaced,

View 7 Replies View Related

Application Express :: How To Decrease The Width Of A Region

Oct 10, 2013

11gxe , apex 4.0 , firefox 24 ,i want to decrease width of a specific region , how ?

View 3 Replies View Related

Application Express :: Calling A Page In A Different Region?

Sep 5, 2012

I am using Apex 4.0 with oracle 11g.I have a requirement where I need to call a page in a region in different page.

For example. I have 2 pages page1 and page2

I need to call the page1 in page2 region.

View 2 Replies View Related

Application Express :: Center A Button Within Region?

Feb 28, 2013

How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?

View 1 Replies View Related

Application Express :: Pass Header Variable From OAM To Apex And Read It In Application?

Mar 4, 2013

We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.

The three header variables which are configure in OAM right now are:
Header variable name Value
1. OAM_REMOTE_USER $user.userid
2. OAM_REMOTE_USER_EMAIL $user.attr.mail
3. OAM_REMOTE_USER_GROUPS $user.groups

We need an additional header variable as mentioned below:
Header variable name: OAM_SAMACCOUNTNAME
Value: $user.attr.samaccountname

The new header variable was added in the OHS server's dads.conf file like shown below:
=========== dads.conf =============
...
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL
PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME

But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable:
===================
begin
:P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' );
end;

The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.

View 1 Replies View Related

Application Express :: 4.2 - Where Is Flash Chart Region Source

Sep 4, 2012

I just noticed on apex.oracle.com (4.2) that I couldn't find the region source for flash charts. I expected to find it under the Region Definition tab.

Has this moved or will it be included in a later release?

View 12 Replies View Related

Application Express :: Region Button To Go To Back To Top Of Page

Oct 24, 2013

In Application Builder, when editing an item's properties there is a handy 'Up' arrow at the top right of each region which takes you back to the top of the page. Is there any way of adding something similar to an actual page region as this would be useful when creating particularly large pages (I know, we should design smaller pages but that's not always possible).

View 11 Replies View Related

Application Express :: No Navigation Region On Home Page?

Sep 21, 2012

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 Related

Application Express :: Changing Icon In List Region?

Nov 23, 2012

I am new to apex , procedure to change the icon in List Region....... see the below link

[List Region Image[URL]....

View 0 Replies View Related

Application Express :: Partial Page Refresh PL/SQL Region

Aug 13, 2013

I have an APEX page with a master and a detail. The master is a classic report with a column link which sets an hidden item on my

page:javascript:$s('P280_DAK_ID','#DAK_ID#'); 

I have a dynamic action which reacts on change of the item P280_DAK_ID.It then refreshes the detail region which is a PL/SQL region with the following:

begin apex_p280.show_xml(p_dak_id => v('P280_DAK_ID'));end;

This prints a few pieces of text to the screen, nothing special. Everything works except the refresh of the detail region.This is due to the fact that the new value of P280_DAK_ID is not in the session state yet. So my question is: what would be a nice solution to set the item in the session state without a submit? With a normal region I could fill in 'Page items to submit', but with a pl/sql region I can't. 

View 1 Replies View Related

Application Express :: Scrollable Content Region - Template?

Jul 31, 2013

I have just implemented a "Data Load" function which is the OOTB page type in apex 4.2 which allows the end user to go through a wizard and import csv data into a table.

 When the user is viewing the data to be imported - they have to scroll across the length of the screen (depending on how many columns you are loading). I noticed there is a Region template called "Scrollable Content Region". I tried applying this template to my region, and when this didn't work, to a container region. 

The scrollbars appear (horizontally and vertically) but they are greyed out as the region is still at max width and you have to use the browser to scroll instead.I think this looks untidy as the header colour-styling ends, as well as other regions being stretched.

View 3 Replies View Related

Application Express :: 4.2 New Database Sessions Per Report Region?

Nov 22, 2012

Does version 4.2 create a new db session for each report run on a page?

The reason I ask is we have a page with 4 report regions, each querying a global temporary table that is populated in a 'Before Regions' page process. The first report displays the correct data, but the others return 'No Data Found' and it is because the Global Temporary Table has been cleared out following the first report. This did not happen in 4.1.

I know we should be using Apex Collections, and we will in future, but time is at a premium to get this live

View 3 Replies View Related

Application Express :: Move Interactive Search Bar To Another Region

Dec 4, 2012

I have an interactive report which needs a horizontal scroll bar as it holds too much information for the screen, the problem is when a user scrolls the search bar is lost

i wanted to know if this could be changed by moving the interactive search (the whole action bar) to another form which would sit above the report.

View 2 Replies View Related

Application Express :: Cell Padding In SQL Report Region

Aug 23, 2013

I have what I hope is a simple question. I have a SQL Report region and I want to add more padding to the left and right sides of the table cell.  I don't want to change the style sheet because I don't want to affect other pages.  But I tried adding style attributes on the "Region HTML table cell attributes" field but I still can't get it to work. give me an example of how I can do this?

View 9 Replies View Related

Application Express :: How To Populate Date Picker Value In Calendar Region

Jul 2, 2012

I have a calendar region based on a simple query from a table which has date and name columns. The calendar type is monthly with 3 buttons - previous, today & next. It works perfectly.

I have added a date picker in a calendar region now. If i choose any date, the calendar month should be refreshed accordingly. Ie... by default it would show July 2012 month. When i choose the month as March 2012 in the date picker, it should show March month data.

View 0 Replies View Related

Application Express :: HTML Text In Reports Sub-region Not Displaying

Nov 30, 2012

I have a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .

View 1 Replies View Related

Application Express :: Report Columns Duplicated When Region Is Copied

May 15, 2013

Re: Report Columns duplicated when region is copied.

When I copy a region which I have created via master-detail form, the report columns are duplicated. I'm actually copying the whole page but I have had other cases where I just copying the desired region and the columns were duplicated there as well. And, of course, there is no way that I know to delete columns from the form. But I doubt because -- in at least some cases I've tried -- the columns seems to be "linked" in that a change to one copy of the column was duplicated in the other when changes were applied.

In the example (below), there are three regions on the page and the problem occurs in region 2. (I think I will likely delete the first region.) It's been agonizing trying to get the report of region 2 and the tabular formish edits of region 3 on the same page. I made this in Oracle 11.2 in our APEX 4.1 and imported it to 4.2. You can see it here:

WS apex_examples_01
demo
demo
Appl. 991204

Page 57 is the original page created in 4.1 and imported
Page 58 is the page copied from 57 under 4.1 and imported
Page 59 is the page copied from 57 under 4.2 (Same result as in 4.1.)

If you want to try the page, select DSD01 from the DSD LOV, click "Query Process" and then click the edit icon. Ignore the region 1 errors -- I'll probably delete this region. The data is region 3 is for Run Date 12-May-13.

Is there some setting that allows this region to be copied without duplicating columns?

P.S. I think I know why it happens: APEX hates me!

View 3 Replies View Related







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