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].......
We have been designing resource management system and want to provide flexible way to extend resource properties at runtime. So we are storing resource properties in a single table,
e.g. select * from _kvID K V---- ----- ----- 1 name Bob 1 age 30 1 gender male 2 name Susan 2 status married convert to+-----+-------+--------+----------+| key | color | height | whatever |+-----+-------+--------+----------+| 1 | green | 15 | --- || 2 | --- | --- | lol |+-----+-------+--------+----------+example of dynamic pivot Dynamic SQL Pivoting – Stealing Anton’s Thunder</title> //<title>AMIS Technology Blog…
Is it possible to create interactive report with dynamic columns updated when _kv will be changed?Is it possible to create add/edit dynamic form depends on key set if we add value type description?
in my application i have a requirement as follows
1) column 1 indicator
2) column 2 important.
and the other columns are target actual and current year, previous year and next year.the layout should be in pivot table lay out as follows here the three columns will be saved dynamically as 2012,2011,2013 and the respecitive percentage in target and actual column
current_year previous_year next_year
target 10% 12% 5%
actual 5% 8% 5%
is it possible to create two head columns sql-pivot.
something like that...
SELECT * from ( Select position,cat_id, att_name as ATTRIBUTE, pro_name, value,competitor
FROM cat_attributes)
PIVOT (
max (value)
FOR (pro_name) IN ('MS 3','MS 4'))
for (competitor) in ('1','1');
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 RelatedI 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,
11gxe , apex 4.0 , firefox 24 ,i want to decrease width of a specific region , how ?
View 3 Replies View RelatedI 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]...
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.
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 RelatedI 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.
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?
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 RelatedHow 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.
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 am new to apex , procedure to change the icon in List Region....... see the below link
[List Region Image[URL]....
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.
Is possible to remove the "show all" of the Region Display Selector? How can i do this?
View 8 Replies View RelatedI 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.
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
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.
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 RelatedI 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.
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 RelatedRe: 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!
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 ?
Is it possible to detect the status of Hide / Show Region.
I have three hide/show regions RX,RY,RZ. When an event EX happens, then region RX should expand and the rest of the region should collapse. When an event EY happens, then region RY should expand and the rest of the region should collapse.
........
...
We can use this JS on DA to change the status of a region:
$("RX.uRegionControl").click();
$("RY.uRegionControl").click();
.....But, first we need to detect the status to know where to apply that DA. ? I am working on apex 4.2. theme 25.
I am using Apex 4.1 and theme 24. I have a hide and show region in a page with some validations. On any validation error the region refreshes and closes. I don't want the region to close on refresh except Submit.
View 2 Replies View RelatedI have a tree region, surrounded by <div>, the height of which is set on page load by a dynamic action so that it is 200px smaller than the window.innerHeight. I have set overflow:auto in the style so that the full free can still be viewed. I now want a dynamic action which fires when the window is resized, which automatically adjusts the size of the region accordingly, so that the region always remains 200px smaller than the innerHeight of the window. I can get the dynamic action to fire by setting the event to resize, however it does not change the size of the region.
View 1 Replies View RelatedIn 4.2 early adapter 2 there is a packaged application called Incident Tracking. In this application page number 50 is having a region called Tickets. It has a template which is numeric.
I could not find the template under the application theme. Even if I try to create a page with the same page template but when I try to create a region in the region template LOV the numeric template is not displayed.