Application Express :: Onchange Event On A Column - Value Undefined?

Jul 4, 2012

I have a onchange event on a column which calls the following code:
function SetVal(pThis) {
//get the curren row index on change
var currIndex = $('select[name="'+pThis.name+'"]').index(pThis);
var currValue = pThis.Value;
  alert(currValue);
  $s('P21_mat_id_hold',currValue);

}currValue is "undefined"

Where am I missing something?

View 3 Replies


ADVERTISEMENT

Application Express :: Skillbuilders Modal Page - End Open Event?

Apr 24, 2013

I'm using Skillbuilders Modal Page 2.0.0. plugin on Apex 4.2, and I can't seem to get the event End Open to work. stumbled upon this thread Skillbuilder Modal Page - Dynamic Title; nothing happens even if I set an alert to pop up on End Open

View 7 Replies View Related

Application Express :: Capture On Change Event For Select List Using JavaScript

Nov 15, 2012

Is there any way I can capture on change event for the Select List (already created on the page) using java script and then refresh chart region?

View 2 Replies View Related

SQL & PL/SQL :: Count Column With Column Value As UNDEFINED

Jun 30, 2010

I have a porblem. I have one table with the following strucuture:

col1 varchar2(30)
col2 varchar2(30)
col3 varchar2(30)
col4 varchar2(30)

In each record of the table some of the columns have 'UNDEFINED' as column value.

I need to count COLUMN WITH 'UNDEFINED' as column value in each record.

View 11 Replies View Related

Workflow :: No Event Subscriptions Exist For Event Error

Mar 6, 2013

we are running Oracle R12.1.3 on DB version 11.2.0.3. I just migrated a created a custom subscription for the oracle.apps.ap.supplier.event Oracle Event. I execute a custom package when this event fires. My package is working fine and I'm getting the expected results. My problem is I keep getting a Workflow notification saying:

Sent: Monday, March 04, 2013 9:14 PM
To: SYSADMIN
Subject: Action Required: Local Event UNEXPECTED : oracle.apps.ap.supplier.event / 36422

To               SYSADMIN
Sent               04-MAR-2013 21:13:40
ID               1659929
    
An Error occurred in the following Event Subscription: Event Subscription

Event Error Name:
Event Error Message: No Event Subscriptions exist for this Event
Event Error Stack:
Event Data: Event Data URL
Event Details
Event Field     Value
[code]...

I saw an earlier post about this and have tried changing the Source Type to "External" but that didn't change anything. why Workflow is telling me a subscription doesn't exist when my subscription is executing with no problems.

View 5 Replies View Related

Application Express :: Hyperlink Column With Link Parameters As Region Column Values

Apr 10, 2013

On my APEX page i have region which has sql query as source and it displays as HTML table the query result to the user.

I want to display addinonal column with a hyperlink inside, and that hyperlink would have CGI/URL-parameters which contains the other values of the HTML row.

So, let's say my APEX region queryes columns as "select c1, c2, c3, c4 ..." and displays out values "V1, V2, V3, V4" then i want to have addional output column with such hyperlink:

a href="f?p=100:7:13467554876288::NO::c1,c2,c3,c4:v1,v2,v3,v4">My link column with CGI-parameters</aHow can i create such hyperlink?

The overall idea is that the link would forward to a page which loads those values "v1,v2,v3,v4" into form fields and user can proceed from there.

---

"Application Express 4.2.1.00.08"

View 2 Replies View Related

Application Express :: Column Link Where Column Number Changes With Query

Feb 11, 2013

We are using Oracle 11g with Apex 3.2 on AIX. We are reporting data from customer satisfaction surveys. I'm using the following sql to create my report

<code>select * from(
select month,'Overall Satisfaction' as q_group, 1 as srt,Overall Satisfaction,site,
case when count(*) < 31 then '*' else
round((sum(ttos)/count(*))*100,0)||'/'|round((sum(bfos)/count(*))*100,0)||'/'||count(*) end ospct
from v_XXX_report a,(select distinct month_dt month from v_XXX_report) b
where Overall_Satisfaction is not null and year_dt = 2012

[Code]....

The problem is that site is not allways present and sometimes I have other variables in addition to site. This creates a situation where the month columns will not allways appear at the same column number. For example, When I run this query as is then the "JAN" column is Col3 (first column is a break, col2 is not shown). When I run this query without site then "JAN" is the second column. I would like to create column links for the "JAN" - "DEC" columns but not for any other columns.

Another issue - in the column link creation screen I can create up to 3 variables that I can pass to the next page. Since my query is a pivot I'm uncertain how to pass the column heading or the row value (for col2)

ie
Overall Satisfaction JAN FEB MAR APR MAY ...
Overall Satisfaction 12/12/200 12/12/210 12/12/220 12/12/230 12/12/240...
Recommend 12/12/200 12/12/210 12/12/220 12/12/230 12/12/240...
etc.

So if I clicked on the values at Recommend:FEB how can I get "Recommend" and "FEB" into variables that I can use on the next page? I've tried #column_name#, #month#, #q_name# and #APEX_APPLICATION.G_F10# but no luck.

View 0 Replies View Related

Application Express :: Can Pass More Than 3 Column Values With A Column Link

Jun 19, 2012

I want to pass multiple column values of a row in an interactive report page to hidden items in another page through column link. And I did it successfully. However, I found I need to pass more than 3 columns of a row in this report, while a column link only permits me to pass 3 column value at most. Is there anyway that I can pass more column values to hidden items in another page?

View 3 Replies View Related

Application Express :: Grab Row ID From Report Column?

Jun 3, 2013

I'm having an issue pulling an ID from a report column.

I have a report based on the query:

select Inspection_Name, Activation_Status, Activate, Deactivate, Activation_Date, Inspection_Sector_Id from Inspections

where Event_Id = :P0_Event_IdThis report is based on a select list at the top of the page. The user selects an event from the select list and the report is populated.

The query for the select list is: select event_name, event_id

from Water_EventsSimple enough so far. Each row is identified by the Inspection_Sector_Id. I want to be able to turn each row under the 'Activate' and the 'Deactivate' columns into links. I have accomplished this by turning this field into a link. The link needs to navigate to a page that has that rows Inspection_Sector_Id, but am not sure how to grab that Id. I am navigating via URL on the link, i.e. f?p=application_id:page_id:session......

View 1 Replies View Related

Application Express :: How To Create 3D Column Chart

Sep 6, 2013

MONTHSTAT_NAMEPERCENTAGE_OF_TOTALApr-08USER_TIME35.43Apr-08SYS_TIME3.74Apr-08BUSY_TIME38.33Sep-13USER_TIME42.92Sep-13BUSY_TIME45.54Apr-08IOWAIT_TIME20.12Aug-13SYS_TIME2.43Aug-13IOWAIT_TIME0.04Aug-13BUSY_TIME45.05Aug-13USER_TIME42.59Sep-13SYS_TIME2.52Sep-13IOWAIT_TIME0.04select null, month, stat_name, Percentage_of_Total from oshistory

I want to create 3d column chart for above chart.

View 3 Replies View Related

Application Express :: Retrieving Column Of Datatype RAW(16)

Oct 26, 2012

I have a table defined where some columns are of the datatype RAW(16). In fact these are foreign keys to other tables. Our company has a policy that all primary keys are of the datatype RAW(16). Not much I can do about that.

Now I want to retrieve all columns of a certain row in that table and just visualize the foreign keys in hex format. All values are filled out nicely, except the columns with datatype RAW(16). Is there something special I have to do to retreive and display these? I defined an item as text-field for these, but this doesn't seem to be working...

I'm using APEX 4.1.1.00.23 at this moment...

View 4 Replies View Related

Application Express :: Column In Interactive Report?

Nov 12, 2012

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?

View 5 Replies View Related

Application Express :: How To Hide Column Link URL On Status Bar

May 8, 2013

Apex 4.1

I have IR wit one column link target to URL, and it uses javascript:my_function(#COLUMN_VALUE#)as URL, that is, calls some function and passes the value of that column to the function; everything works fine; but when I place a cursor over the link, bottom line of IE9 browser (is it called a 'status bar'?) clearly shows:

'javascript:my_function(<actual value>)' Is there any way to prevent it from showing function name and parameter value? I tried onmouseover="window.status='';"but it does not work

View 3 Replies View Related

Application Express :: How To Validate Date In Column Section

Dec 19, 2012

How to validate a date in column section?

View 1 Replies View Related

Application Express :: Report String Column To Date?

Apr 22, 2013

v: Apex 4.2

I have Dynamic report and column say some_date column and data can be in the columun (01-JAN-13) OR (01-JAN-13,04-JAN-13), (01-JAN-13,04-JAN-13,10-JAN-13) so on.

in actual table column some_date is date field but in report as above (string) because using RTRIM(some_date, ',') some_date within the select MODEL clause.

my problem is when run the report and select filter from action menu then it doesn't give option such as < , > or so on because of string but I want it should give <, <=, >, >= operators too as date column.

View 5 Replies View Related

Application Express :: IR Report Date Column Popup

Apr 30, 2013

I have an IR report and want to add another column such as complete_date. I want to add as a link so when user click it then should display the popup window or javascript popup for date selection. i don't want to use apex_item.date_popup or apex_item.date_popup2. On date selection popup user can choose only two dates such as yesterday or today all other date should be disabled?

View 2 Replies View Related

Application Express :: Download Link On Column From Another Table?

Apr 1, 2013

I'm a APEX newbie using APEX 4.1. I have a table with engineering drawing information (drawing number, title, revision, etc.) and another table with the corresponding drawing files (pdfs stored as blobs where the filename is the drawing number with a pdf extension). The user wants to search for a particular drawing by drawing number from the drawing info table and if the drawing number exists in the drawing files table the drawing number will also be a download link for the file, if the drawing number doesn't exist in the drawing files table than the drawing number will display as plain text (not as a download link).

View 1 Replies View Related

Application Express :: Hide Column In Interactive Report In 3.2?

Feb 15, 2013

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.

View 1 Replies View Related

Application Express :: Disable Column In Tabular Form

Dec 28, 2012

How i can disable column in tabular form.working with 4.1 and i have wizard based tabular form.If i have entered value in one column second column should disable and vice versa?

View 5 Replies View Related

Application Express :: To Fix The Width Of A Column In Interactive Report

Jul 16, 2013

I have a column named 'Comment'. Its have a huge data due to which the length of that column in interactive report get increased.

I need to fix the length to a desired value.I used following code in Region Footer:

<style> table.apexir_WORKSHEET_DATA td[headers=COMMENTS] {  _width: 300px;  min-width: 50px;   max-width: 300px }</style>

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.

View 1 Replies View Related

Application Express :: Starting Report Column On New Line

Jul 30, 2013

Recently I remember reading what I think was a blog post on placing the last column of a report underneath the penultimate column - I think it was for classic reports.

I can't find it... Col1  Col2  Col3----  ----  ---- abc   def   xyz123   456   987  Col1  Col2  ----  ----  abc   def         xyz123   456         987

 I think it was done with some magic in the column definition, or maybe some jQuery?Agnostic to version. It was a more robust solution than using a HTML expression of#COL2#<BR>#COL3#

View 5 Replies View Related

Application Express :: 4.2 - Changing Link Column From ROWID To ID?

May 3, 2013

I have a report linked to a form. The link column is currently ROWID and I want to change it to the Primary Key of the DB table, which is called ID.

I have done this before on a previous report/form where that ID was a display column and it works fine. Now I'm trying to copy what I did, which is this:

On the report page, go to Interactive Report attributes, scroll down to Link Column, and for Item 1, change the Name and Value.

The problem is that Name does not list P52_ID. If I type it in, it throws an error when I run the page.

I think I added ID, which is also a Display column, later on, so I wonder whether Apex has a refresh issue and can't "see" P52_ID.

View 1 Replies View Related

Application Express :: Duplicate Column IDs In Reports On Same Page

Mar 27, 2013

I have 4 reports on the same page. I have added a checkbox column to each one. On clicking I want to populate a collection with the value of the id of the corresponding row and then have a button acting on the whole list.

My code to get the id of the item that contains the value I want is this

id = 'f02_' + $(this.triggeringElement ).attr('id').substr(4,4);

But there is an f02_0001 for each report, and the code just finds the first one, rather than the one in the context of the report being clicked.

<input name="f02" id="f02_0001" type="hidden" value="2072"/>
....
<input name="f02" id="f02_0001" type="hidden" value="2052"/>
...
etc etc.

All that is ever picked up is 2072

They have different table ids but I don't know how to reference the correct ones in my code.

View 3 Replies View Related

Application Express :: How To Change Column Type At Runtime In 4.0

Apr 3, 2013

I´m newbie as Apex developer using Apex 4.0 with OracleXE 11.2, and now my problem is:

I have a tabular form where one of the columns, when calling the form, is a Display Item, so that you cannot change existing values​​.

I want, when adding a new row, that column become a Select List (named LOV) based on a query that exclude existing values ​​in other rows already inserted.

Can I change that Display Item to Select List (named LOV) programmatically at runtime? If not, what other options do I have?

View 13 Replies View Related

Application Express :: 4.1 - How To Add A Report Column To Existing Page

Oct 12, 2012

On a "Form on a table with report" page created with the wizard, I want to add a new report column from the underlying table (this is the multi-row page). If I try to add the column name to the query, Apex tells me:

"You have requested to change the Interactive Report query. If you added columns to the query, they will not be displayed when the report is run. You will need to use the actions menu and either select the columns or click Reset. If you removed any columns from the query, it will disable existing filters, highlight rules, and other report settings referencing those columns. Please confirm your request."

I sure don't want to start over and re-build the page, so where the heck is this "actions menu"?

I'm running Apex 4.1.

View 2 Replies View Related

Application Express :: Print Column Heading On Each Page In PDF

Nov 13, 2013

Version 4.1.1.00.23 

I'm having a really hard time finding a solution to print the column headings on each page after the page break when printing.  We're using a tool called PDF Creator to create the PDF's and they're opened in Adobe.The server is GlassFish Server 3.1.2. What other information can I provide?

View 7 Replies View Related

Application Express :: 4.1 - Interactive Report Column Width

Jul 10, 2012

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.

View 1 Replies View Related

Application Express :: Validate Database Column Using Validations Tab?

Sep 11, 2012

I'm trying to validate a database column using the validations tab in APEX, the data entered will always be in 'A0000' format but i cannot work out how to set up the validation correctly

View 2 Replies View Related

Application Express :: Hide / Show Column In Download To CSV?

Nov 27, 2012

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

View 1 Replies View Related

Application Express :: Creating Link In IR Report Passing Value From Different Column

Feb 19, 2013

Version 4.0.2.00.07

I have an Interactive Report with a column that I need to create a link on but I need to pass the value of another column.

This report shows the Features of a particular Release. There is a select list for the Release that is selected and executes the report. There is a column that indicates whether the Feature has a Commitment attached to it. If there is have that a link to another report that shows all the Commitments for that Feature by passing the FEATURE_ID which is also a column on the Feature report.

Query:
SELECT
....
,CASE WHEN ft.feature_id IN (SELECT cc.feature_id
FROM customer_commitments cc
WHERE ft.feature_id = cc.feature_id
) THEN 'Yes' ELSE 'No'
END "Commitment Exists"
,ft.feature_id
....

FROM ....If "Commitment Exists" has a 'Yes', the 'Yes' is a link that will pass the FEATURE_ID to another report that will show the Commitments for that Feature. If the "Commitment Exists" has a 'No' then no link. I was also wondering if the Commitment report could open in a seperate window and make it modal?

View 7 Replies View Related







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