Application Express :: Prevent Interactive Report From Running Query On Initial Page Load?
Oct 1, 2012
I am on APEX 4.1.1, db 11g and I have a report which is quite slow to retrieve results from its query. The page has some filter fields (e.g. store code, dept code) in addition to the generic search field.
When the user lands on this page (from a menu page), the query runs before the page displays and this typically takes 1-2 mins without any filters yet set. The usual browser loading indicators are not obvious to the user and they might not be aware that it is working on the request.
I want it so that it will only run the query AFTER allowing the user to get to the page, let the user fill in some filter criteria and then click on the GO button. Therefore the query will run after the page is submitted. When you hit the GO button on the interactive report, a nice rotating apex_loader.gif appears, making it obvious to the user that it is working on the request.
I would prefer NOT to create 2 pages, one for user filter, and a second for the actual report as I have many reports/inquiries which fit this category and I would prefer NOT to have to create pairs of pages for each.
I have created a IR report and I set the default search column using the suggestion found in the thread URL....but how can I keep this default even after the research was done?Now it is resetted !
I am starting to use the interactive reports in version Apex 4.1.1 but I am unable to get the report to show null records on the first load. Is there a setting that would stop the data from loaded on first load or would I have to customize that option.
Some of the columns have a lot of data and therefore take a long time to load so I would like to avoid that.
I am using Apex 4.1 and have a requirement to create an interactive report based on a dynamic query. This option is available in Classic report but in Interactive this feature is not there. Tried using collections or just a view (thought of changing the view definition during "On load", but structure of the report is already defined based on the definition of the view at design time).
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 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'm using Apex 4.2.1 against Oracle 11gR2 and mod_plsql.I've created a page containing two classical reports and an editable tabular form, with the form needing to be positioned at the page bottom.
The tabular form contains the usual buttons Apex creates by default such as "Add Row", "Save", and "Delete". Whenever users click any of these buttons, the entire page "jumps" and the mouse cursor goes to the very top of the page. Very disconcerting as well as frustrating since users must constantly scroll down to where the form is to see if a row was added or deleted.
I have set the tabular form region to "Partial Page Refresh". No effect.I have also created a dynamic action triggered on a button click (say the "Add Row" button) and whose action is to refresh the specific tabular form region. Again, no effect.
Even with both of these interventions, implemented individually as well as in combination, still has my page jumping and the mouse cursor at the top of the page whenever users click any of these form buttons.
We have an interactive report (working report), which is updateable.
The user has created his own version of the report, with less columns.
Now when he changes a value it does not save.
Am I right to say that if one of the columns he has removed from the report is a required parameter for the update code, then the report will not save.
I have an error why trying to update the source of my interactive report the error is : 1 error has occurred
The report query needs a unique key to identify each row. The supplied key cannot be used for this query. Please edit the report attributes to define a unique key column. ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
The SQL query is :
select l.code_lignebip, m.identifiant_mission, m.libelle_mission, SUM(b.nbr_jours), SUM(c.nbr_jours_consome), c.nbr_jours_realise, c.nbr_jours_raf, c.nbr_jours_reestime, c.lundi, c.mardi, c.mercredi, c.jeudi, c.vendredi FROM missions m, bip l, cra c, budgets b [code]....
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?
Since I'd rather not do it directly in the SQL used to populate the report, any clean way to style all cells of a given column from an interactive report? Perhaps all cells of interest can be addressed through jquey using the "headers" attribute they share?
I've got an interactive report with detail and icon view enabled. How do I get the current display state (user looks at report, detail or icon view) out of the apex dictionary ?Is there any place in APEX_APPLICATION_PAGE_IR_... where I can find it ? I'm on APEX 4.0.2. Upgrade to APEX 4.2.2 is planned this fall.
In Apex version 4.2 in interactive reports, you can stop users from hiding columns by unchecking a check box under column definition.Is there a way to stop users from hiding a specific column in version 3.2.
Its solved the problem by fixing the width of the column but the column is not showing the full data now. It is hiding most of its part to fit it in that column.
I have created a workflow which is going through 12 pages. At each page the user needs to choose his variables.
This could be the y-axes, x-axes, amount, surname ... etc. The variables are given to the next page via branch to next page process. Everything works well until I need to create an interactive report out of the chosen variables.
Lets say I have a variable called :P7_XAXIS with static LOV :
Amount,Amount;Date,Date;quantity,quantity
Page 8 is my IR. If I try :
Select :P7_XAXIS from mytable This will not work.
But if I try
Select Date from mytable This will work. Why? In my workflow there are several variables that can be used in a where condition. This also works. But I need to access the values before the condition and I also need to get a chart out of it.
I have created interactive report -------------------- SELECT EMPNO, ENAME , JOB, MGR, HIREDATE, SAL, COMM, DEPTNO --------------------------------- and Report Attributes=>Link Column have given Link to custom <img src="#IMAGE_PREFIX#e2.gif" border="0"> for P9_EMPNO...the editable displaying fine.
MY Requirement was ..in the editable link...i need to control with DISBALE/ENALE with if EMPNO=100 then all 100 id records need to editable link disable and if EMPNO=120 then All 120 records editable link need to be enable..this kind of thing need in the report..
If it is possible in Apex 4.2 get interactive report where clause and change it before displaying result e.g. We have an report and for some of columns we should do exact match and for some partial match.And business requirement is that they should not add additional % at the and of search string. It should be added automatically for some fields.
I am facing very strange situation. In one of my Interactive report, Filter option is not working (Processing symbol is appearing on top of the page, but nothing happens.). Is there any setting or something like that?
My Interactive Report will run for a minute or for a long time like 5 to to 10 minutes depending upon given parameters to the report. Now I would like to cancel the report search when I made a mistake like searching on a value which willtake more time. how to achieve the same.
I'm trying to translate all of the interactive report messages, on Apex 4.2. I'm using this [
[URL].........
As a reference. I have several problems translating the help section of the interactive report. First of all, I can't seem to find all of the message names. The ones I couldn't find were:
Sets the number of records to display per page.(regarding displaying certain number of rows per page)
Format enable you to customize the display of the report. Format contains the following sub menu:
Sort Control Break Highlight Compute Aggregate Chart Group By(regarding format)
You can define one Group By report per saved report. Once defined, you can switch between the group by and report views using links below the Search bar. To create a Group By report, you select:
the columns on which to group (up to 3 columns can be selected) the columns to aggregate along with the function to be performed (average, sum, count, etc.) the columns to use for sorting (up to 3 columns can be selected along with direction and null sorting options)(regarding group by)
And secondly, I have translated this message
Select columns icon enables you to identify which column to search (or all). Text area enables you to enter case insensitive search criteria (wild card characters are implied). Go button executes the search. Reports displays alternate default and saved private or public reports.
Actions Menu enables you to customize a report. See the sections that follow.using this message name:
APEXIR_HELP_SEARCH_BAR.
However, now I have two messages shown in that section: the original one, in English, and the translated one.
I have an interactive report with two columns timestamp type. I want to use the compute action in order to get the difference between those dates. Nevertheless I got values like this: +000000008 00:00:00.000000.
i would like to implement drag and drop for ordering the rows.It is a quit complex query behind the report (joins, ect.) I need a hidden item like this
apex_item.hidden(1, rowid)
AS Sort The problem is, that rowid is not allowed here (ORA-00918: column ambiguously defined).Because of that article I am sure the joins in my query are the problems ORA-00918: column ambiguously defined But I need this rowid for the sorting process.How to implement Drag and Drop I have learned from here:Read Article - Drag & Drop tabular form rows.
How to control the column width on an interactive report. I can force it by making the column header really long but that is a crazy solution. How can I get control over this? I have columns that contain memo entries and if I use the header memo the report has tall skinny columns which makes reading very difficult.
i m using apex 4.1, and want to submit page when page load. i tried dynamic action but it continuously refreshing page. is there any other javascript or anything else from which i submit page on load
dynamic action used, event on load and action submit page but it continuously submitting page.
I am trying to change the column order in an Interactive Report. Run the report as a developer then use the action menu.
However, I am not sure how one can run the the report as a developer. Do you just login and run the page? Then if I do that, I don't see the action menu there. If I go to page attributes "Save Report" tab, I do see the action menu but "Select Columns" only gives me "Report Type", "Report Name" etc as columns. Or we don't have enough privileges to run the report as a developer?
I’m on APEX 4.1, 11gR2, Windows 7 and the latest version of Firefox. I have an interactive report. I want the end user to have the ability to click on a row level link and launch a modal pop up view of another page. Ideally, I'd like to be able to use the Skillbuilders plug-in. I can get it to work if I just go the full page route but I cannot figure out a way to get it to work as a modal pop up. I’ve tried various methods, none of which work, but the one I believe I should be following is by using a page level Dynamic action that fires when a JQuery Selector found item is clicked. The problem I’m having is that I cannot find the correct JQuery Selector syntax for the column. My report has a static ID of IDN and my column a header of PARTS. The best I can manage is not to see anything happen other than a page refresh (when the link is set to the same page). I do not see and firebug console errors.
I’ve replaced the dynamic action modal page call with an alert, which is not showing, to make sure that it's not the plug-in configuration that is causing the problem.
what I should be filling in in the JQuery Selector field of the DA and what the link attributes should be? Given that I wish to redirect from page 1 to page 2, what do I put in the other link fields?
I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?
