Application Express :: How To Show Data From A Table Having Large Number Of Columns
Oct 8, 2013
I have a report with single row having large number of columns . I have to use a scroll bar to see all the columns. Is it possible to design report in below format(half columns on one side of page, half on other side ofpage :
Column1DataColumn11DataColumn2DataColumn12DataColumn3DataColumn13DataColumn4DataColumn14DataColumn5DataColumn15DataColumn6DataColumn16DataColumn7DataColumn17DataColumn8DataColumn18DataColumn9DataColumn19DataColumn10DataColumn20Data I am using Apex 4.2.3 version on oracle 11g xe.
Recently i created a form which contains emp_name,deptno,supervisor_name.For emp_name if i type the emp name (eg:allen) it will show me a list of employees named allen as a select list.For that i used a jquery script on page header
and i have created a dynamic action for emp name to fetch the deptno,supervisor_name if select the employee name it is working fine is if i type a emp_name which doesn't exist in the employee table it will show me a alert message employee does not exist and it will clears all the fields.
I have been requested to create a tabular form, but end user should have ability to hide/show columns, also they should rename the column headers. So I have created a table with column name called "attribute1", attribute2", etc. Based on that table, create a tabular form, which has column header as "attrbute1", "attrbute2", etc.
Now end user wants to rename attrbute1 as he wants. And he/she also wants to have a link called "hide/show" next to the column header, so end user can control which column they want to hide/show. It is so easy to do that control from developer side, however, shift that function to end user from front end seems very difficult to me
The following query is used to generate a flash chart:
select null link 'Available' as "Available", to_number(max_licenses - consumed_licenses) from software_detail where capture_date = trim(GET_CAPTURE_DATE) and software_product = :p1 and software version = :p2 [code].....
But the 2d doughnut flash chart shows:
Available = 39 Consumed = 1
How is this possible?
Oracle 11.2.0.3 RAC on Windows 2008 R2 APEX 4.2.1.00.0 with Apex Listener 2.0 on Apache Tomcat 6.
from jobs aI would like to show a count from another table where the jobid = jobid from the above sql.The problem is I don't know how to refer to the jobid in my extra sql.Here is my extra sql for the new count column.
(select count(1) from jobs a, loghead b, dba_scheduler_job_run_details c where a.logid = b.logid and b.session_id(+) = c.session_id and a.jobid = :P3_JOBID) no_of_related_jobs.
This will not work because :P3_JOBID is a page item.I have also tried #JOBID#, but got en error, as it was not recognised.
I am trying to change the default behavior of Hide/Show Region to show, after some attempts i got it partially working but now clicking the icon to toggle hide/show doesn't work also changed the icons and added type="" but its not working.
I created one collection report and in the report when i click on the next >> then the report will show the next columns to enter data in some columns but the data which i entered before going to next will not get retain (data is getting lost) when i come back by clicking << previous but i want the data to get retained even when i click on next >> or previous << in report so that i can enter large amount of data at a time in the report columns by clicking >> & << and click on submit button to save all the data.
Consider tables A,B,C,D,E,F. all are having 100000++ records Tables B,C,D are dependent on table A (with foreign key constraint). When I am deleting records from all tables, table B,C,D are taking max 30-40 seconds while table A is taking 30-40 mins. All tables are having indexes.
Method I have used:
1. Created Temp table
2. then deleted all records from B,C,D,E,F for all records in temp table for limit of 500. delete from B where exists (select 1 from temp where b.col1=temp.col1);
3. Why it is taking too much time for deleting records in table A.
Is there any thing that during deleting data from such master table, it is referring to all dependent tables even if dependent data is not present ?
how to use APEX_ITEM.text for where the source for this comes from user input values and not for an underlying table.I have a report where three columns are coming from an actual table (one being a checkbox for selection) but then also have two additional fields on the screen that are not from a table but placeholder fields for user's to enter data.
For example, my query looks like this:
select apex_item.checkbox2(10,id), name, telephone, apex_item.text(20,NULL) as "Date Contacted", apex_item.textarea(30,NULL,5,80) as "Comment" from my_table
I am not seeing any values for the two user fields when entering values and doing a view source?
i am trying to make an image to show up in an application am developing but is only appearing like a box but when i click on the edit pencil icon the image will appear.
I want to show progress bar every time when page loads.
Progress bar is coming on the page. but it is not going off after page is loaded.Below is the code which i added for the Progress bar.
//written on Header Text of Page <script type="text/javascript"> <!-- function html_Submit_Progress(pThis){ $x_Show('AjaxLoading'); window.setTimeout('$s("AjaxLoading",$x("AjaxLoading").innerHTML)', 100); }
I have an IR where I have to show a column in report, but hide it while downloading to CSV.
I get this by having a condition on this column - NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF') I also have a column where I have to hide it in the report, but show it while downloading to CSV.
I am able to hide it, but this column doesn't show up while downloading.I am using this condition on this column NVL(:REQUEST,'EMPTY') IN('CSV','XLS','PDF','XML','RTF') APEX - 4.0.2
In a classic report, I'm using the Sum functionality and breaks by First Column to get subtotals and report total. I Repeat Headers on Break which works great for the subtotals but I would like for the report to display the column headers above the report total for easier reading. If the last grouping has a lot of data, the user needs to scroll up to read the column headers when looking at the Grand Total.
Is there a way to Repeat Headers prior to report total?
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.
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 ?
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:
Im tring to dynamically hide/show page item. I searched and found something but it not working for me. Im using apex 4.1 and below described are work I did.
In my page (form) I have 5 fileds iitems.
- Customer No - Edit - First Name - Last Name - Address
I want to hide First Name, Last Name, Address based on the value in Edit. Let say if user selects "Edit First Name" then First Name must get visible while Last Name & Address hidden.
So I placed this line onChange="$f_Hide_On_Value_Item(this,'LASTNAME,'LN')" in page item EDIT> Label > HTML Table Cell Attributes
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.
issue with my apex line chart. The scenario is as follows: have a table called revenue. revenues per year are saved in it. and revenues are generated from three sources which are also saved in the same table. I have made a line chart on it. works well.
Now I have to show that if the value of one of the sources had fallen, how must have it affected the total. I made a number field that takes an estimated change value, and build my sql query with it. it works but the problem is that it changes the non-affected source too. it must change the value of the affected source only and hence the total value.
bold or I will put it this way, how can I write a select statement for a chart series so that one of the rows value does not change and the other two change.
i have a hidden region at the page top i want to show only after clicking my button which is running DA plsql code. This region is like a prompt message container/div at the top of the page so after few seconds like 10 secs i want to hide it again. I tried to use JQUERY but never hide it back, also i tried another TRUE CONDITION within my dynamic action but it doesnt reset it back the region is always shown...
Currently if i let required field empty, then APEX puts systematic error message "XXX must have some value." near the field and into the page header. I want to create custom business rule, that would show message for example "This action cannot be performed, because this and that...".
That kind of custom validation should be in my plSql package and somehow it should throw/send the phrase "This action cannot be performed, because this and that..." to the page header where was message "XXX must have some value.".
How can i create such custom error message to appear out using PlSql package function that i define myself? I plan to create a common validation package, which has lots of plsql functions to validate lot of APEX pages/forms, all those functions should throw/send somehow error messages to page header. I looked that this unofficial solution does not suit for me:
[URL].......
Because it disables APEX systematic automatic validations as i understand, and is unofficial.
I just created a "Hide and Show Region" from a template in APEX4.2, and would like to control the behaviour of this region, i.e.
1. At the page load, this region should be in "Hidden" mode 2. Once the user Opens the region, it should stay as "Expanded" mode ( even the page gets submitted), until the user chooses the "Hidden" mode again.
So I tried the following
1. Chose the Hide and Show Region(expanded) template for the APEX region 2. uses Dynamic action to force the "Hidden" mode by setting Style as style="display: none;" at the page load event.
But it still shows the region in "Expanded" mode after the page gets loaded.
Event: click. type: jquery selector selector: a.show_popup no condition.
action: skillbuildersmodalpage 2.0.0 URL: attribute of triggering element.
This works fine, but after the popup is shown and closed, the link is not working until the page is entirely refreshed again.
after the popup is closed, i only refresh the report with $a_report , ( in another dynamic action on the "auto close skillbuolders" event) i don't want to submit all the page....the partial refresh is working fine too, but not the link, it only works again by refreshing or submiting all page
I am new to the Upload data from excel to Table..... how to implement on this.....I need code for UpLoad CSV/XLS Files to the Table ....Table name T_UPLOAD have contains 40 columns....
I'm trying to unload data from a table, so i go to SQL Workshop > Utilities > Data Workshop > Data Unload to Text, i select my table, select the columns, give the condition to unload the data of the last month (between sysdate-28 and sysdate), then i select the comma separator, including the column names, and finally press "Unload Data"...the file is downloaded correctly, but when i open the file, the data is not ordered as i expected.
