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.
Our application has a homepage that displays results of several SQL statements that are defined as reports. One report in particular should only display a custom message when Count of Invoices having a particular status > 0, and not the actual invoice count itself.
I have gotten the layout to not display the count but I need to be able to display a custom message that says "Problem Invoices exist. Please see Invoices Report for more information." I've looked over the Report Attributes definition page but I cannot find how to display this custom message.
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 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.
In APEX I've always created form on report so as to have the list of records of a table and the possibility of inserting/updating every sinle record by means of the form on it, ok?I have an application concerning classic costumers, orders, ... with a table for every item.
The problem is that I have to gather all information ao as to produce a classic bill with a typical layout where you have on your left some descriptions and on your right an amount but of course the layout is not based on a classic table, do you mean?Do I have to create a table in which I'll add data and null values so as to get the layout desired
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:
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.
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.
Having this issue in Apex 4.1.1 and 4.2 (haven't tried it in versions prior to 4.1.1 yet). So I got my standard IR, and trying to create a private report with control breaks, aggregations.
Once I save it as a private report, It applies the same on my primary report.
It's no big issue as I can flip back to Primary report and delete the control breaks, aggregations but is some kind of bug? Ideally it shouldn't modify my primary report unless I try to save it as "Default Report Setting".
I have a Page containing 3 reports and I was wondering if it is possible to re-execute only one of the these reports using a button or preferably a Select List which allows me to choose which of the 3 reports I wish to 'refresh/re-execute'. I may be totally wrong here but I assumed that choosing the option to submit a Page will cause all regions to refresh i.e. re-execute the SQL queries they are 'based on'.
I have a Report Region with Type SQL Query and Source "SELECT * FROM <table>" where <table> has a primary key from a sequence. Under Report Attributes, I have Report Column "ST_NM" with Show and Sort checked and having a Sort Sequence of "1". I assume this is to set the iniital display sequence but regardless, the report rows display in Primary key order initially.
To try it: [URL]
1) How do I set the initial display sequence to be other than the primary key sequence?
What is the code/javascript/url behind the test report button on report queries component?
We are having DSN problems using the print url given on the report query. The URL works for some of our developers and not for others.
The test report button on the report query appears to work for everyone but I do not know what is behind the "Test Report" button. If I could recreate the test report button on our page this would be GREAT!
I have to implement IR report search functionality (*when ever we click on column header it will display all the values in that particular column , once we click on particular value , the report will filter based on that particular value * ) in classic report .
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.
