Application Express :: Get Part Of URL As Part Of Dynamic Action When Clicking A Button?

Nov 3, 2013

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


ADVERTISEMENT

Application Express :: Cannot Use Username Into Conditional Part Of Action Item

Sep 14, 2012

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.

View 3 Replies View Related

Text :: Make Part After AND Not Match Already Matched First Part?

Nov 2, 2012

I have a table of addresses where the indexed column consists of the city, an optional area name, the street name and the street number. For example 'Stockholm Drottninggatan 2'.

The users must enter the full city name and the beginning of the street name. So if the user wants to find all the addresses of both the streets Stockrosvägen and Stockbergsvägen which are in Stockholm, the query would look something like this:

Select * From AddressSearch
Where Contains(AddressSearch.Address, 'Stockholm AND Stock%') > 0;

But this will select all the addresses of Stockholm. Is there a way to make the part after the AND not match the already matched first part?

View 2 Replies View Related

Application Express :: 4.2.1 Dynamic Action Definition True Action Settings Not Visible

May 16, 2013

im 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.

View 1 Replies View Related

Application Express :: Part Of Screen Is Missing For Dashboard In IE And Google Chrome

Mar 7, 2013

When I see the apex dashboard in the IE or google chrome, part of screen goes missing.Last part of dashboard doesn't come but it works fine in Mozilla Firefox.What should I do? Is there some settings I need to do in IE.I am using the IE version 9.0 for 64 bit.

View 0 Replies View Related

Application Express :: Include Data Files As Part Of Export Process?

Jan 14, 2013

if it is possible to include 'data' files as part of the Application Export process. Up till now I've only been able to include supporting object files which will recreate a table structure but not the data records - I've been creating the latter outside of APEX.

View 2 Replies View Related

Application Express :: Computation To Trim Off First Part Of String Within List Manager Item Values

Jul 1, 2013

A computation after submit pl/sql function process to trim off the first part of the string (CQ..) within the list manager values. Support for example the list manager contains values such as

 CQ..SAMPLE1..TEST1CQ..SAMPLE2..TEST2CQ..SAMPLE1..TEST2 

The computation process should trim off the first part(CQ..) and should return the list manager value as SAMPLE1..TEST1SAMPLE2..TEST2SAMPLE1..TEST2 Oracle APEX 4.0.2 is the version and Oracle 10g r2 is the database. 

View 7 Replies View Related

Application Express :: Action When Button Clicked - Redirect To URL

Feb 6, 2013

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!

View 2 Replies View Related

Application Express :: Enter A Value Using Set Value Dynamic Action

Aug 1, 2012

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.

View 1 Replies View Related

Application Express :: Use Page Item In LOV That Was Set By Dynamic Action?

Aug 15, 2012

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?

View 7 Replies View Related

Application Express :: Suppress A Dynamic Action Loading GIF?

Mar 1, 2013

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

View 1 Replies View Related

Application Express :: Call Dynamic Action From Link

Nov 28, 2012

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 Related

Application Express :: Raise Application Error On Dynamic Action

Jul 18, 2013

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

View 4 Replies View Related

Application Express :: Dynamic Action Call From An Interactive Report?

Jul 6, 2012

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?

View 2 Replies View Related

Application Express :: How To Have A Dynamic Action Populate Text Fields

Sep 7, 2012

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,

View 14 Replies View Related

Application Express :: Deleting From A Tabular Form With Dynamic Action

Jan 24, 2013

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

View 18 Replies View Related

Application Express :: Dynamic Action For A Text Field In Tabular Form?

Sep 13, 2012

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]...

View 2 Replies View Related

Application Express :: Display Only Value Not Save To Database Based On Dynamic Action?

May 22, 2013

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

View 6 Replies View Related

Application Express :: Show Region After Running Dynamic Action Plsql?

May 1, 2013

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 Related

Application Express :: How To Create A Dynamic Action From Link Column In Classic Report

Feb 23, 2013

I 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.

View 5 Replies View Related

Application Express :: How To Fire Dynamic Action On Cascaded (child) Select List

Nov 8, 2012

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.

View 4 Replies View Related

Application Express :: Dynamic Action In Report Region In Master Detail Form

Nov 7, 2013

I 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 ..

View 1 Replies View Related

Application Express :: Dynamic Action To Show Skill-builders Pop Up Only Works When Page Refresh?

May 28, 2013

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

View 2 Replies View Related

Alias Not Usable In WHERE Part?

Apr 30, 2007

why this query works fine:

SELECT Z.ZAJEZD_ID, Z.JMENO,
(
SELECT COUNT(ZAJEZD_ID)
FROM trasa T
WHERE T.ZAJEZD_ID = Z.ZAJEZD_ID
) AS POCET_ZASTAVEK
FROM zajezd Z
ORDER BY Z.JMENO

But when I try to use the alias to filter the results like this (note the WHERE part):

SELECT Z.ZAJEZD_ID, Z.JMENO,
(
SELECT COUNT(ZAJEZD_ID)
FROM trasa T
WHERE T.ZAJEZD_ID = Z.ZAJEZD_ID
) AS POCET_ZASTAVEK

[code]...

Then it throws an error message ORA-00904: Unknown Identifier for the column/alias POCET_ZASTAVEK?

View 2 Replies View Related

SQL & PL/SQL :: Convert Time Part Into Second

May 10, 2013

How can i convert the time part into second. for example

in mu table i have below rows

1753-01-01 09:18:00.000
1753-01-01 09:52:00.000
1753-01-01 09:36:00.000

I want to convert the time part of each rows to number of second in different column. so for the 1st rows it is 09:18:00.000 that means 9hour and 18 min = 9*60*60+18*60.

But that is complex column.

View 14 Replies View Related

SQL & PL/SQL :: Selecting Only Part Of A String

Feb 25, 2010

I am selecting a column from a table and placing it into a cursor. The column contains backup job names that are formatted like the following:

SERVER_DATABASE_BACKUP_BACKUPTYPE_JOBID

However, I only need the DATABASE piece selected in my FOR loop below.

CURSOR c1 IS
SELECT COLUMN_NAME
FROM TABLE_NAME;

[Code]...

View 2 Replies View Related

SQL & PL/SQL :: Extracting Part Of A String

Jan 9, 2013

To make SQL query to before and after specific character.

Create table test(flist not null VARCHAR2(200));

First field content with below record:

FC028CONNE_IMPORT_WRONG_COMP_LENGAPXXXXPPPP
FC024CALL_FUNCTION_OPEN_ERRORAPXXXXPP
FC025OPEN_DATASET_NO_AUTHORITYAPXXXXPPPPPPPPPPPPPP
FC015RAISE_EXCEPTIONAPAXEPPPPPPPPPPPPPPPPPPPP

to filter the above record from FLIST column thorugh sql script as below:

FC028< CONNE_IMPORT_WRONG_COMP_LENG> APXXXXPPPP
FC024< CALL_FUNCTION_OPEN_ERROR> APXXXXPP
FC025< OPEN_DATASET_NO_AUTHORITY> APXXXXPPPPPPPPPPPPPP
FC015< RAISE_EXCEPTION> APAXEPPPPPPPPPPPPPPPPPPPP

means remove first 5 charator and after APXXXXXXXXX.

Output of SQL query should come like below:

CONNE_IMPORT_WRONG_COMP_LENG
CALL_FUNCTION_OPEN_ERROR
OPEN_DATASET_NO_AUTHORITY
RAISE_EXCEPTION

View 24 Replies View Related

SQL & PL/SQL :: What Part Of Query That Is Being Run Now From Procedure

Apr 14, 2010

I started one packaged procedure in plsql developer yesterday..thats being run from yesterday...I wanted to know what part of the query that is being run now from the procedure.

View 23 Replies View Related

How To Execute Part Of WHERE Clause Conditionally

Oct 30, 2010

I need to insert Data into a table based on particular condition, So I'm using an Insert select as follows:

INSERT INTO error_table
(error_code,cust_id,customer_name,error_message )
SELECT '34', cust_id,customer_name, 'Missing xxx'
FROM customers
WHERE cust_id = cur_cust.cust.id
AND ( NOT EXISTS ( Select .....) -- control 1
OR (EXISTS ( Select .....) --control 2
OR (NOT EXISTS ( Select .....) -- control 3

I have around 10 controls. I want these controls to run conditionally..I was wondering if this can be done using a decode based on some variable outside the query.

I want the query to run like this:

if A then execute control 1: AND ( NOT EXISTS ( Select .....)

If B then execute control 2: AND ( OR EXISTS ( Select .....)

View 2 Replies View Related

SQL & PL/SQL :: Extract Only Number Part Of Column?

Mar 25, 2010

In a table, I have a column in a table with the following values:

targetcol

30 WD
180 WD
70%
0
80%
180 CD
70%
0
7 WD
2 WD
0

-
-
-
-
-
-
-
-
-

where WD is working days and CD Calendar days.

I just need to extract number from above.

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved