I have tested the following html page:
<html>
<body>
Click me
</html>
and is working fine when I click on the button on the created page.
However, using the same thing under the "Action When Button Clicked -- Redirect to URL" when create a new button, i.e:
javascript:window.open ('file:///c:/sample/','Documents');
will only open a new window, but blank in content!
I am new to APEX and I am developing an application to manage Oracle database user accounts. I have a page (8) that has text items for the username and the database name. I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account. I have another button that should:
get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11
The issue is that FIND_USER_IN_DB does not get populated and page 11
which is a simple report with the following query:
SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB;
How do I accomplish this?
I have 3 pages: - Classes: a Classic Report that shows a list of classes and summarises attendance- Class Attendance Report: An Interactive Report that shows a row for each student that attended a class- Attendance Add / Edit Form On the Classes page, the Date value is a Link which passes a filter in the URL to the Class Attendance Report, showing only students who attended the class held on this date On the Class Attendance Report, I want to have a Region Button that, when clicked, goes to the Attendance Add / Edit Form and the Class Date field on this form is automatically populated with the same date value as was being used for the filter on the Interactive Report on the Class Attendance Report Page. So, I click on the Class Date link for 2013-11-01, this takes me to the Class Attendance Report and filters for students who have been already entered as attending on 2013-11-01. If I click on the "Add Attendance" button, it goes to the Attendance Add / Edit form and the Class Date is automatically set to 2013-11-01. I assume I need to do this via a Dynamic Action that runs when the "Add Attendance" button on the Class Attendance Report page is clicked?
View 6 Replies View Relatedim working with apex 4.2.1 and when i try to define a Dynamic action on any item, if the action type is "Set Value" or execute SQL/Javascript code it should appear a text field that let me define the action taking place. However this wont do..
this is what happens:
And this is what should happen:
I know that patch 4.2.2 solves some issues regarding dynamic actions but in the bug report there's no reference to such a problem.
I have a shuttle control (P8_SHUTTLE) that lists then names from scott.emp.
Now I want to create a dynamic action that fires when I click on one of the names on the left side of the shuttle control.
I want the dynamic action to recognize the name of the employee that was clicked, and then set the value of a text item (P8_LAST_VALUE) to that ename. (Eventually I want to display the department of that employee in the other text item).
Here are screen shots of my DA:
[URL].....
Currently, when I click an item in the shuttle control, the text item P8_LAST_VALUE remains blank.
I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button. The dynamic action sets two values in a table and then I would like to redirect to another page. Setting the values works fine. The code is below:
declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information, CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data"
how to redirect to a page from within PL/SQL . None of them result in success.
We have several interactive reports setup and some of them can display more than one screen of data at a time, depending on the results returned.
All of the reports have prev/next pagination links at the top and bottom of the reports. For the longer reports, if you click prev/next at the bottom of the reprot, the prev/next page will display. But, you will still be at the bottom of the page/screen. Is there a way to force the report to return to the top of the page/screen when prev/next is clicked?
Oracle XE 11g
Apex 4.1 which was upgraded from 4.0 long ago.
Win 7
I've changed the "Require HTTPS attribute" to Yes on the Security Settings page in Oracle Application Express Administration Services[URL]...and after applying the change, going to the DEV or administration pages [URL]...results in a redirection to [URL]...(again, respectively), and a redirect loop error.
When going to[URL]..., the browser redirects to[URL]...and gets the old-known "Application not found" error (which is OK, I guess - the error, not the redirect address).And the most strange thing - when going to the app I developed directly[URL]..., it works OK (no edit buttons, though, although I log in as admin).
I am trying to redirect to different pages based on user inputs. I have a form in which I have one text item and a submit button. For example consider text item to be empno; So once the user enters a empno and hits submit button; I need to redirect to different pages based on this job.
For Ex:
if user inputs empno whose job is 'ANALYST' then redirect to page 1
if user inputs empno whose job is 'MANAGER' then redirect to page 10
For this scenario. i wrote a pl/sql process for the submit button; but no luck -- its not at all redirecting instead its in the same page. Below is the process.
declare
v_job varchar2(20);
begin
select job into v_job from emp where empno = :P9_EMPNO_R;
if v_job = 'ANALYST' then
OWA_UTIL.REDIRECT_URL('f?p=&APP_ID.:1:&SESSION.::&DEBUG.::', TRUE);
[code]....
I am using Apex 4.2. On a click of button a Dynamic Action is written, which calls a DB Package. The DB package has exception handlers and also the package has two output parametersError Code and Error MsgSo in my code(Dynamic Code) i make a call to the package and checks the value for Erroc Code.
Begin Package call...... If v_error_code <> '0' Then Raise SC_Error; End if;Exception When SC_Error Then RAise_Application_error(v_err_code, v_err_msg);End;
But when i run the page and I click I get an Internal exception errorOutput from Debug -- I am not sure what the Cell in Red colour means, because the package is returning a correct message (before the red line).AJAX call returned server error ORA-20003:
Customer has already been matched for Execute PL/SQL Code.4......is_internal_error: true4......apex_error_code: APEX.AJAX_ SERVER_ ERROR4.. ora_ sqlcode: -200034......ora_sqlerrm: ORA-20003: Customer has already been matched4......error_backtrace: ORA-06512: at line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 973 ORA-06512: at "SYS.WWV_DBMS_SQL", line 999 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_EXEC", line 830 ORA-06512: at "APEX_040200.WWV_FLOW_PLUGIN_UTIL", line 2304 ORA-06512: at "APEX_040200.WWV_FLOW_DYNAMIC_ACTION_NATIVE", line 442 4......component.type: APEX_APPLICATION_PAGE_DA_ACTS4......component.id: 231852037977562094......component.name: NATIVE_EXECUTE_PLSQL_CODE4.
Execute Error Handling Callout defined on Page or Application Level4...Execute Statement: begin declare l_error wwv_flow_error_api.t_error; begin l_error := wwv_flow_error_api.g_error; wwv_flow_error_api.g_error_result := apx_error_utils.handleerror ( p_error => l_error ); end; end;4......Values changed by callout:4..
An unexpected internal application error has occurred. Please get in contact with your system administrator and provide reference# for further investigation. 4..display_location: ON_ERROR_PAGE4Stop APEX Engine detected4Final commit4-1 - 59
I am working in apex 4.2.1.
I'm having an odd problem with a checkbox on a tabular form. I created the checkbox by setting hte display as to "Simple Checkbox". The value of the underlying column sets to "Y" wehn checked and "N" when unchecked. This is what I want. The next thing I was trying to accomplish is to call a javascript function when the checkbox is clicked. So I put onclick="calculateTotal(this);" in the element attributes field. The code that it is calling is listed below. When I run the app and check the box I can seee I am entering the calculate Total function. Each of the alert functions is displaying what I would expect until I get to alerts 'IAH5' and 'IAH6'. For each of those I get an "undefined" in the alert.
So to see if this had something to do with the checkbox and added an onchange="calculateTotal(this);" to another field in my tabular form and ran it. This time I did not click on the checkbox but went into the field that I put the onchange on. When I changed this field and navigated away from it the function worked as I would expect. It displayed the appropriate values for each of the alerts and updated the fields on the screen as designed.
<script type="text/javascript">
function calculateTotal(pThis)
{
alert('IAH1');
var vRow = pThis.id.substr(pThis.id.indexOf('_')+1);
alert('IAH2');
[code].......
I'm using Oracle 11g XE with apex 4.0.2.
I've been trying to use a dynamic action on a text field 'item_group'. Button doesn't have this facility. I created an advanced action using 'set value' with no condition the value being 'RAM.' The event is "change", selection type 'event source', set type is 'static assignment' and value is RAM. It is supposed to trigger when the create button is pressed but nothing happens and the field is still null. I've tried variations on this but nothing works.
I have a situation where I need to reference a hidden item in a List of Values (for a pull-down list) SQL statement. It doesn't seem to be working properly. Here is what I have:
1) Using a dynamic action, set the value of a hidden item based on the change of Select List 1.
2) Select List 2 has a parent LOV item of Select List 1, and the Select statement for Select List 2 uses the hidden item that was set from the dynamic action above.
I can see that the dynamic action is working correctly. But when I change Select List 1, the Select List 2 does not show any values from its LOV.
I'm wondering if the LOV for Select List 2 is not working because the item used in the SQL statement was set by a dynamic action?
I've created a change event dynamic action which fetches a description from the database for a user-entered code. When this is run in Firefox, a swirling loading image is displayed next to the description.However, the loading image causes anything displayed its right to be moved out and then back again when it disappears. On a form with lots of dynamic actions this can be quite disconcerting so I'd like to stop it.
Can a dynamic action's loading image be suppressed?
APEX inserts the following HTML alongside the input field:
<span class="apex-loading-indicator"></span>One option is to apply "display: none;" to the "apex-loading-indicator" class but this could affect other loading images that use the same class.
Note: This affects Firefox (18) but not IE9
All I want to do is call a DA from an HTML link, is it possible? Do I call the DA function like I do with JS?
View 2 Replies View RelatedI am trying to find a way to set the selected columns, like what the action menu -> select columns does. I am planning to build a AJAX Tree with check boxes, but I don't know where to pass that data to to update the selected columns. I'm sure their is a magic apex function that is passing the values of the current shuffle box, but as that is dynamically created, I have not be able to find that process / function.
Reason for this: Too many columns on the IR report. Want them divided by categories in a tree view. And no, I cant break the report up into multiple reports. Currently this report has 548 columns.
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.
View 1 Replies View RelatedI’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?
How to have a dynamic action populate text fields. When the create button is hit, it will insert the record in the DB like normal.
I had a search box doing a dynamic action when a record_number is entered and the selection changes It populates the remaining text boxes with the results of the record_number.
I used a "SET_VALUE" true action on each individual ITEM
For each individual item i have different SQL Statement populating that item.
Ex. To populate Last_Name/ P2_LAST_NAME item i do the following
Select LAST_NAME from patient_Demographics
where record_id = :P2_RECORD_ID
Affected Elements:
P2_LAST_NAME
So i have about 8 of these true statements, so i'm hitting the DB 8 times to get the individual items. Is there a way to hit the DB once and set the items using one PL/SQL statement? I tried using a PL/sql function body,
For our customer we have build a custom login page. The form we currently made has de following items:
- Username
- Password
- Select list for selecting the task type
When the customer enters his username, automatically the select list of the task type will be refreshed to get only the task type where the customer has the rights to do it. This part works...It can occur that a customer has only one task type (which is default) then we want to hide the select list. This part doesn't work
We used APEX version 4.1.1.What we did is:
- One action item to refresh the selection list (works)
- One action item to hide the selection list by starting the application (works)
- One action item to show the selection list only when the selection list has more than one result. For this part we used the conditional part of the action item (Function returning a boolean).
In the query (inside the function) we want to use the entered username, looking into the application in the session state I saw the correct username, but for some reason the function cannot use this entered username, it becomes empty. When I use a hardcoded username the code works.
Why I cannot use a username into the conditional part of the Action Item.
Using Apex 4.2
Is it possible to delete a row from a tabular form using dynamic actions.
At the moment my report sql contains html and javasript for a delete button
'<input type="button" name="Delete" value="Delete" onclick="del(''delete'','''||a.applicationname||''')">' A2I then have javascript in my page header
function del(Request, Name){
var answer=confirm("Do you really want delete application "+Name+"?
* Provider assignments will be deleted
* Application objects will be deleted
* DB-roles will be dropped
* DB-views will be dropped
* User-synonyms will be dropped");
if (answer==true) {
document.getElementById('P10_APPLICATIONNAME').value = Name;
doSubmit(Request);
}
}
Finally I have a page process to do the delete which fires when the request = delete
for a text field of a, wizzard generated, tabular form i created a dynamic action when lost focus. using a jquery selector to bind the da to the item in every row when the event fires some jscript and pl/sql code is executed. this all works like charm for existing rows.
but how can i bind the da to the field for newly added rows?a sc of the definition of the da can be found here [URL]...
I have a select box with products, and a dynamic action that updates a display only element with the price, based on the product selection.After the selection is made and the page is submitted, I have noticed that the price is not stored in the database. If I change the display only value to a text box, the data is saved. Is this expected behavior? If so, can I add something to the text box to make it not editable?
Version is Application Express 4.1.1.00.23
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...
View 2 Replies View RelatedI Have an apex page that display a modal window utilizing jquery. In the modal window I have a classic report with a link column that I want to capture its click event.
I was thinking I could create a dynamic action with selection type=jquery selector. Not for sure if I need to do anything on link column and do not know the syntax jquery selector.
When a user selects a Plan Type (Parent Select list) Plan codes (Child select list) to be filtered, working OK.
When a plan code is selected I need to do conditional display of regions.
Example: Plan code = A then display Region A
Plan code = B then display Region B etc.
I have a DA on Plan code select list but it's not working as it's being a cascaded (child) select list and the 'Change' event is already fired when I selected the Plan type, I also tried with other event options with no success.
Plan code shows no value in the session.
In my project, I implement file's upload and download function by "BLOB Support in Forms and Reports" of official development document Advanced Programming Techniques When user click the BLOB column to download file, I want to trigger an action to update one table for counting this file is downloaded one more times. But I can not find any "dynamic action" about this Blob column of Report.
View 1 Replies View RelatedI have created a master detail form , in which many validation etc is done ,the MASTER is a FORM and DETAIL is a REPORTNow I am stuck up with the detail region .i.e reportI have Line Detail where there are ITEMS such as SL NO:
,ITEM_ID , UOM ( Unit of measuremnt ) etcNow here is where
Using POP UP LOV i have managed to fetch in LOV for the item "ITEM_ID",---
i can select an item name using the pop up LOV ,Now all that I want is when I select an item name from the pop up lov , an Item Id is displayed or fetched in that particular place , now i want the corresponding UOM to be diaplayed ( i.e the UOM for that particular Item Id which has been selected by me from the pop up lov ).
In order to resolve this I created a Dynamic action where in I get the UOM . Bt the problem is that the ITEMS displayed for selecting in the WHEN section (DYNAMIC action-IDENTIFICATION section-WHEN section----- items ( here i am not listed with ITEMS of the REPORT region instead ITEMS of the MASTER is available )-TRUE ACTION section etc is only theITEMS of the MASTER region ..
I have a report with a link column:
'<a href="f?....................................class=show_popup"........
I have a dynamic action defined like this:
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
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 3 Replies View Related