Application Express :: How To Get Checkbox Value When List Value Changed In Classic Report

Dec 26, 2012

I worked with apex 4.2 and i create normal classic report with one checkbox column and one column change it to select list(named loved) now i want when user change list take value of checkbox item and show it in message .

SQL for report

{
SELECT
'<INPUT TYPE="checkbox" NAME="f01" VALUE="'
||SEQ
||'">' SEQ,
ID,
DEPT_NO,
EMP_NAME}

i change the column attributes of Dept_NO to Display as Select list of department name (named lov). Now i want when user change name of department the value of SEQ SHOW IN ALERT MESSAGE

i create JavaScript on the page

function test(pThis) {
var f01_value = $('select[name="f01"]').value;
alert('#SEQ : '+ f01_value);
}
</script>

I call this javascript function when list change but the value undefined..

My Question :

How can get this value Or any value of item in reports ?

View 6 Replies


ADVERTISEMENT

Application Express :: Checkbox In Classic Report

Jul 16, 2012

I have question about checkbox in classic report. I need to choose only one checkbox in every row, hot to ensure that only one checkbox can be checked at same time?

Checkboxes are defined in SQL query as:

apex_item.checkbox(1,msisdn,'UNCHECKED') as clear,
apex_item.checkbox(2,msisdn,'UNCHECKED') as to_analysis,
apex_item.checkbox(3,msisdn,'UNCHECKED') as to_barring

here is the picture:

[URL]........

View 9 Replies View Related

Application Express :: Interactive Report Functionality For Classic Report?

Jun 27, 2012

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 .

View 8 Replies View Related

Application Express :: Classic Report - Logo In PDF Report

Apr 12, 2013

I have created a classic report in Apex. Have enabled the print PDF link on the report for the business users to download it in a PDF format. Is is possible to put a logo in a downloaded PDF from the report?

View 0 Replies View Related

Application Express :: Item Value In A Classic Report?

Oct 3, 2012

I have the release 4.1.1. I have this problem:

- i have a master-detail page

- in a detail there is a classic report

- some item of the row of report are the select list based on LOV

I need to get the value of item inside the select list.

View 1 Replies View Related

Application Express :: How To Use The Result Of A Sum In A Classic Report

Sep 20, 2013

I've created a classic report that sums a couple of columns in two different regions:(Why can't I insert an image?)This is a simple example:

Region1col1     col2     col3     col4     col5    a          b          20          5          25%c          d          40          4          10%e          f          120         6            5%report total:     180          15          x Region 2col1     col2     col3     col4     col5    g          h          30          6        20%i          j            70         14       20%report total:     100        20          yMy

How do I access the values generated by APEX (in bold) so that I can use them in further calculations? e.g. create a grand total from both regions

2) Having calculated a value, assuming 1 above is possible, how do I insert it at position x or y? e.g I want to calculate a % so that x would be 8.33% and y 20%

3) How do I change the words report total

View 2 Replies View Related

Application Express :: Conditional HTML Expression In A Classic Report

Sep 6, 2013

Apex 4.2I currently have a report column in a classic report that has a Column Formatting Attribute as below. This works fine it shows a map icon that when you click on it goes off to google maps and put 2 geo points on a map. However I need to change this report column so that the HTML expression will be different dependent on the value returned so if the column returns 1 then the HTML Expression will be slightly different. 

HTML EXPRESSION <span class="map_#BROKE_GEO#_#VALID_GEO_CODES#"><a target=_blank href="f?p=&APP_ID.:323:&SESSION.::::P323_PARCEL_ID,P323_SCAN_ID,P323_PROP_ADDR1,P323_PROP_POSTCODE,P323_PROP_LAT,P323_PROP_LONG,P323_SCAN_LAT,P323_SCAN_LONG:&P341_PARCEL_ID.,#SCAN_ID#,#LINE_1#,#POST_CODE#,#PROPERTY_GEO_LAT#,#PROPERTY_GEO_LONG#,#SCAN_GEO_LAT#,#SCAN_GEO_LONG#"><img src="#WORKSPACE_IMAGES#&P341_IMG_MAP_#BROKE_GEO#." alt="Google Maps" title="Google Maps"></a></span>  

I think I can do this in the report source directly with a case statement and include the HTML in that for the column but how do you handle all the quotes within the SQL statement. e.g.

Original Query SELECT     parcel_id    ,status    ,LOCATION    ,scan_date    ,scan_id    ,driver_comments    ,card_id    ,valid_geo_codes -- this is my html column    ,property_geo_lat    ,property_geo_long    ,scan_geo_lat    ,scan_geo_long    ,broke_geo    ,line_1    ,post_code    FROM vw_parcel_history_details  WHERE parcel_id = :p341_parcel_id  ORDER BY scan_date  New Query SELECT     parcel_id    ,status    ,LOCATION 
[code].....

various iterations of that large html string but I do not know how to format it because off all the quotes?

View 3 Replies View Related

Application Express :: How To Highlight Entire Classic Report Column To Red

Sep 20, 2012

We have a requirement, to highlight an entire column of a classic report based on a query to red. So if the search of the report returns column1, column2 as the output. Column 2 (text) should be highlighted in red across all results rows.

In some forum responses, I see using some id format, one can try to highlight a single column in a row. Not sure how can this be done across the whole column of multiple rows.

View 9 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 :: Resize IFrame Generated On-the-fly Inside APEX Classic Report

Jun 25, 2012

I have a classic report generated by Oracle Apex 4.0. I have customized it to have a hyperlink on each record, which when clicked opens a detail report in an iframe right under the current record. This, I am doing by using the Javascript insertRow method on the html table element (Condensed Javascript code below)

var pTable= html_CascadeUpTill(t,'TABLE');
var myNewRow = pTable.insertRow(pTR.rowIndex+1);
var myNewCell = myNewRow.insertCell(0);
myNewCell.innerHTML = '<iframe src="detail report url" height="0"></iframe>';In order to resize the height of the iFrame that is different for different detail records, I have the following code in the "Execute when Page Loads" section of the report
[code]........           

Without the setTimeout call to iResize function, the iframe resize is not happening. But this setTimeout is adding a delay in the resized iframe to appear which I want to avoid. Is there a way to do this? All the related posts/articles I have seen online deal with iframes that are built into the page but not generated on-the-fly as in my case.

View 3 Replies View Related

Application Express :: No Data Found When Adding Column Link To Classic Report

Jul 16, 2012

Oracle 11g r2, APEX 4.1.1.00.23.

I have some classic reports.

I go to Report Attributes, then I click Add Column Link in the "Tasks" right menu, it adds me a column link, I just add some text for the link and a page to go to. Then I run the report and I get :

report error: ORA-01403: no data foundTested with several classic reports on multiple pages.

Debug mode shows me :

0.43816     0.00240     ...Execute Statement: select distinct [...] order by 3,11 ,4
0.44056     0.00162     print column headings
0.44218     0.04816     rows loop: 25 row(s)
0.49037     0.00141     report error: ORA-01403: aucune donnée trouvée
0.49175     0.00078     Computation point: After Box BodyWhen I run the query in my favorite tool, I get expected results.

Did I missed something ?

View 9 Replies View Related

Application Express :: Retain Checkbox Value On Cascading LOV Checkbox

Sep 29, 2012

My development instance's APEx version is 4.1. I have two checkbox items works on cascading LOV. The cascading works very well as long as if I do not come back and check anything from the first checkbox item after I checked the second checkbox.

If I do, the cascade LOV refresh uncheck all checked values from the second box. My question is, how can I preserve the second check boxes checked values before refresh?

View 0 Replies View Related

Application Express :: How To Add Select List In Interactive Report Search Bar

Apr 16, 2013

I am using Oracle Apex 4.2 and theme 25. I want to add select list in IR search bar. I am able to add buttons but i am unable to add items.

View 4 Replies View Related

Application Express :: Getting Values Of Checkbox

Sep 4, 2012

I have problem with getting values of checkbox. I have search page where are some numbers field, date pickers, radio buttons and checkbox (P40_ OE) when I click search button I want to get report with filters like

select t1.id, t1.name, t1.company
from table1 t1, table2 t2
where t2.id = t1.id
and t2.oe in list of values from P40_OEIn checkbox I have 11 options to choose. I work in Apex 4.1.

How can I make this search or filter report working?

View 2 Replies View Related

Application Express :: Checkbox On Click Action

Jan 15, 2013

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

View 6 Replies View Related

Application Express :: How To Check If The Checkbox Is Checked

Oct 24, 2012

I am running blank with this one.

I have a checkbox item called P46_PAGE2 with static LOV STATIC:;1

How do I check if it is check using Javascript.

View 2 Replies View Related

Application Express :: Checkbox Corresponding Global Array Name?

May 27, 2013

m learning how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:

<input type="checkbox" name="*f10*" value="3" />

And this one stands for array name "g_*f10*".

However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly :(

My generated HTML snippet:

<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>

View 4 Replies View Related

Application Express :: Difference Between JavaScript And Checkbox

Nov 18, 2013

How to check off checkbox with JavaScript. I tried

1) $("#checkboxID").prop('checked' , false) (jQuery)
2)    $("#checkboxID").attr('checked' , false) (jQuery)2) document.getElementById("checkboxID").checked = false;Checkbox's list of values: STATIC:;1

Checkbox always states checked. When I append 'checked="checked" ' attribute (or simply checked) to this unchecked checkbox in Firebug nothing happens. Why ? I execute JavaScript code in Dynamic Action on button click. All other controls (textareas and textfields) are cleaned successfully except this checkbox. "Effected elements" property includes all needed items.

View 3 Replies View Related

Application Express :: Checkbox Not Clear Cache

Oct 18, 2013

i have created form with table  page to enter hotel details there is on 6 check box which are not database column .i have create these check box to keep days details when hotel give service .so i have use

LOV FORP1_MON      STATIC2:;1   MONDAYP1_TUE       STATIC2:;2   TUESDAYP1_WED     STATIC2:;3   WEDNESDAYP1_THR       STATIC2:;4  THURSDAYP1_FRI        STATIC2:;5   FRIDAYP1_SAT       STATIC2:;6   SATURDAYP1_SUN       STATIC2:;7   SUNDAY 

i have one more column operating days where i have use computaation to keep operating days.

:P1_MON||:P1_TUS||:P1_WED||:P1_THR||:P1_FRI||:P1_SAT||:P1_SUN 

these 6 check box are used Source used :Only when curren value in session state is nullSource Type : Static Assignment (Value equals source attibute)  Problem are when i create new record then these 6 check box are not clear cache and when i update any record value are not clear cache . i need when i create or update recor then all 6 check box should be null after keep recor. 

View 1 Replies View Related

Application Express :: Retrieve All Data From One Multiple Checkbox To Another?

Jul 11, 2012

How do you retrieve all data from one multiple checkbox to another? The method I'm using returns one choice even though multiple have been chosen.

View 2 Replies View Related

Application Express :: Multiselect Checkbox As Cascaded Item

Nov 14, 2013

I have a check box in which if i select more than one check box, based on that multi-select values, i wanted the next item values to get displayed. I have set up an example at

[URL]........

In this page, if i multi-select "place" check box i wanted the "departments"  to get displayed according to the above multi-select.If i do a single select in check box, i am getting the corresponding departments but i am not getting it while i select multiple check boxes. 

View 11 Replies View Related

Application Express :: Single Value As Checkbox Or RadioButton That Submits Page?

Jul 18, 2012

I need a page item with a single value that submits back to the page, so that I can conditionally display other page items.I know a traditional 'Button' would work, but the a checkbox or Radiobutton would be my preference.

Here is where I am stuck.

CHECKBOX - I have used Dynamic Events to hide/show page items, but in this case I need a SUBMIT.

RADIO BUTTON - This works great with either the Redirect or Submit option, but I only have 1 value, so I what it act like a on/off button, where if it is currently selected, and the user clicks it again, it changes to unselected..

View 1 Replies View Related

Application Express :: Update Record In Another Row When Date Changed

Oct 10, 2013

As all of you know, In the Apex,  when you create a form with report in the page, you are able to insert and edit data. But when you edit the data, the data will be modified in the same row. In other word, you loose the old data.

What I need to do is: I have revised_num field and production_date field. I want to create a form with report and insert and edit data as is in the apex and insert 0 to the revised num until production date is null. But when  production date is not null, then from that point, I want to insert data to another row and modify revised num to 1. and I want the revised num be incremented by 1 each time the user modifies the data after the production date is not null.I don't know where I should start.

View 12 Replies View Related

Application Express :: Changed Date Formats For Several Different Ways

Jul 18, 2013

I have an APEX Page , page no1 for person's details  that got fields like name, Date of Birth. When user enters the details, it get saved. Now when we want to edit a person's details, we click on that person then it goes to next page, where we can change/details of the person.But when i tried to do that, i am getting Not a valid month error.. log message shows that it is coming from : Automatic Row Processing (DML)- an after SUBMIT process. Is there a  way to avoid this error?I changed date formats for several different ways.

View 1 Replies View Related

Application Express :: Value Changed By JavaScript Submitted As Null When Using $x_disableItem?

Oct 21, 2012

Had some issues with a page on which i changed the value of an item using javascript and added a dynamic action (dummy pl-sql) that submitted the item. The problem was that if i also used $x_disableItem to disable the item in the function that set the value , the value submitted was always null. However if i used the "Disabled" attribute from the item Settings and remove the calling $x_disableItem in the function, the value submitted is correct.

To reproduce , create these objects on a page (default everything not specified):

<li>P1_VALUE - textfield
<li>P1_SET_VALUE - button calls "javascript:setValue();"
<li>P1_SUBMIT - submits the page
<li>Dynamic action:
- Event - Before Page Submit
- Execute PL-SQL (begin null; end;) - Page item to submit P1_VALUE

[code]....

So i have two questions:

1) Why is the implementation different (would have expected to behave in the same way)?

2) When using the javascript API function $x_disableItem , why is the value submitted null?

P.S: For the workaround i removed the $x_disableItem call with calling a custom function that toggles the read-only attribute of a given item.

View 2 Replies View Related

Application Express :: Auto-Close Modal Page When Nothing Is Changed In The Form

Jul 15, 2012

I am using Skilllbuilders modal page 2.0 to edit the form. Sometimes, the end user clicks on the edit link to trigger the modal page and sees the form , but he/she could not do any changes. Thus, when clicking Apply Changes button, we will be redirected to the page 102 ( the empty page ). How can I get around and make the page 102 to close automatically in case I am redirected to it ?

I put this in a JavaScript a dynamic action to be fired as page loads:

$(document).apex_modal_page('close');but nothing happen.

View 2 Replies View Related

Application Express :: Current Version Of Data In Database Has Changed Since User Initiated Update

Sep 25, 2012

I am experimenting with the 4.2 version of Apex at URL.....

I have created a tabular form (based on a view with an instead of trigger) and have restricted this form to "Update only" mode. Whenever I modify a field value and submit the change I get the error "Current version of data in database has changed since user initiated update process".

View 6 Replies View Related

Application Express :: Display List Of All Users On Page / Accessing Or Using Application

Mar 23, 2013

i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?

View 1 Replies View Related

Application Express :: Saving Private Interactive Report Overwrites The Primary Report

Dec 10, 2012

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

View 1 Replies View Related

Application Express :: Create Items Context Help Editable Report Or Report And Form App

May 9, 2013

How do I create Items context help editable report or report & form app?

what is its table?

View 2 Replies View Related







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