Application Express :: Change LOV Based On Another Field Value?

Sep 26, 2012

I have a need to change the LOV of a page item's select list based on the selection in another page item's select list. So in other words, for a page item that is a select list, I need to use one LOV normally, and a different LOV if the value of a different page item is set to X.

A dynamic action would be useful here (on change where Select List 1 = x), but I don't know how to take the action of changing LOVsfor Select List 2 based on that action.

View 5 Replies


ADVERTISEMENT

Application Express :: Recognize A Change Of A Field Value?

Aug 21, 2012

I created a table (software defect details) and an interactive report on it. Users can go to the details form where they can manage many information: STATUS is one of them and they can change it or not.

I would like to send an email when SUBMIT botton is pressed only if field STATUS has changed. How can I detect this? I mean, I wrote a procedure in order to send an email and it works, but it runs always: I cannot set it running only when the content of STATUS_ID has changed.

how to understand if a field value has changed and, if possible what the old values was? I know how to do that by using a trigger (:old.status, :new.status) but I don't when using an APEX procedure.

View 4 Replies View Related

Application Express :: How To Change Grayed Field Font

Nov 7, 2013

I need to change the grayed field item font ... ie i need to make disabled item value to be bright to achieve this what i have to do.

View 6 Replies View Related

Application Express :: Update Field On Change For SQL Query

Nov 26, 2012

We are using APEX 4.2, 10GR2, RedHat5.

I have a report that comes from SQL Query (updateable report). I'm using the apex_item.text and apex_item.hidden on fields. I'm using a button to submit and after submit process to add some logic that I need.

There could be 1 - 10 records in the report. There is only 1 field that is needed to enter a value, but the value of this field determines the value of another field. I think that I can do this with a submit button and an after submit process where I loop through all the records. I think I have this handled.

This is the question

When the value of that field is changed then the value of another field in the same row changes immediately. All the examples I've seen so far are for a single record and that doesn't work for us.

I guess this is a MRU process but I haven't seen an example where a dynamic action is possible on a Multi Row Update.

View 4 Replies View Related

Application Express :: Change Form Text Field Label Using Javascript

Oct 22, 2013

I have a field that will be providing different info based on document type. I would like to change the field label from javascript in DA. 

View 3 Replies View Related

Application Express :: Populate Text Field Based On LOV Selection With AJAX

Apr 24, 2013

I would like to populate a text box based on selection from a LOV. If someone selects a LOV value and then tabs off off of that element, I would like the text box populated from a sql statement based on the LOV value in the predicate.Application Express 4.1.1.00.23

View 1 Replies View Related

Application Express :: Interactive Report / Change Text Color Based Upon Value In Another Column

Nov 12, 2013

I have a sample report at this url:

workspace: homeworldusername: test_reportpassword: test_report APEX version is 4.2.3, database 11g release 2... Application #: 202 : IR REPORTS TEST Page in question is page #2   

I have the report setup and need to make the following change... I have 2 columns: Comm and bonus,

if the bonus > comm, I need to change the text color of the bonus color to Red   if the bonus < comm

I need to change the text color of the bonus color to Green   if the bonus = comm, I need to change the text color of the bonus color to Black I have tried using code with the select and am NOT wanting that since it will be bundled with the data when downloaded as CSV or Excel.. Had thought about using the built in highlighting but that doesn't allow comparing a column to another.. Was thinking of a dynamic action, but not clear as to HOW to do it.

View 10 Replies View Related

Application Express :: How To Change File Character When Export Application (4.2.1.00.08)

Feb 5, 2013

I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with

"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",

how can I do change it?

View 1 Replies View Related

Application Express :: Way To Change Application Builder Theme

Sep 24, 2012

Is there a way to change the Application Builder theme? There are themes for applications; how about for the builder itself? I looked but did not see a selection for this.

I'm a Geek thru and thru, I guess, but I think you might have to be xxxx retentive to like all these square boxes. And these old eyes have to squint to focus among the vast sea of gray shades.

View 2 Replies View Related

Application Express :: Change To Application Process Not Recognized?

Sep 13, 2013

I'm trying to make changes to a PL/SQL procedure in an application process and no matter what I do in the PL/SQL text (even removing semi-colons and messing up syntax) no changes register when I call the procedure from a page process. I've also tried creating a new application process with a similar procedure of a different name, and no page processes will allow me to call the procedure, saying that it needs to be declared. APEX 4.1.1

View 1 Replies View Related

Forms :: Update Field Based On Another Field Checkbox

May 3, 2013

I have a table where i need to update one field values based on another field of the same table , simply as it is.I have done this using one select all check box , on clicking that all check boxes of item_trans table will get selected , then i will un select some of check box and then using one button, i will update the value of the fields which are checked only.

I have put the sample code but when i am updating its taking long time and hanging.I am also attaching the form based on the test case provided.

--tables with insert statement
create table item_trans (trans_item varchar2(12),trans_qty number,trans_act_qty number)

insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE1',40,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE2',20,NULL);
insert into item_trans(TRANS_ITEM,TRANS_QTY,TRANS_ACT_QTY) VALUES ('TREE3',20,NULL);

--i want to set the value of trans_Act_qty as trans_qty

--i create one dummy or test block to keep the select all check box. for that table test script is

CREATE TABLE TEST
(
C VARCHAR2(2000 BYTE),
B NUMBER,
A NUMBER
);

insert into test (C,B,A) values ('A',1,1);

--code written in select all check box which is created on test.block.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
:M_END_YN := :M_END_ALL;
[code].......

--code written in M_END_YN ( actual check boxes where i will uncheck).

IF :M_END_YN = 'N' THEN
:M_END_ALL := 'N';
END IF;

--code written on button to update those values which are checked.

BEGIN
GO_BLOCK('item_trans');
FIRST_RECORD;
LOOP
IF :M_END_YN = 'Y' THEN
[code]......

View 5 Replies View Related

Application Express :: How To Change Logo URL

Feb 14, 2013

How to Change LOGO URL (When I click on logo redirect should go not to home page, but to any page that I want set manually).

View 3 Replies View Related

Application Express :: Set Value For Read-only Field?

Sep 22, 2012

I have a form that based on a table,

Col1: text field
Col2: text field with Disabled =Yes and Save session state = Yes

I create a dynamic action on Col1 to set value for Col2, when I submit page an error raised: Session state protection violation

visit: [URL]...

My purpose is: Col2 is set value by Col1 via Dynamic action, and is read-only, user cannot modify.

View 7 Replies View Related

Application Express :: Refresh Tree On Change Of Shuttle

Sep 27, 2012

I have a requirement in which on Change event of shuttle, the tree present in another region of the same page should refresh. On refresh, the tree should include the values selected on the right hand side of the shuttle as its nodes.

View 3 Replies View Related

Application Express :: Interactive Report Get Where Clause And Change It

Sep 9, 2013

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. 

View 4 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 :: Creating A Report Not Based On A Table?

Jun 10, 2013

In APEX I've always created form on report so as to have the list of records of a table and the possibility of inserting/updating every sinle record by means of the form on it, ok?I have an application concerning classic costumers, orders, ... with a table for every item.

The problem is that I have to gather all information ao as to produce a classic bill with a typical layout where you have on your left some descriptions and on your right an amount but of course the layout is not based on a classic table, do you mean?Do I have to create a table in which I'll add data and null values so as to get the layout desired

View 2 Replies View Related

Application Express :: Highlighting Accordion Based On Selection

Nov 19, 2012

I have created three accordians where there will be sub tabs under each Accordian. There will be two logins. Where when i login with Admin all the 3 accordians will be shown. But in the user logins 1st Accordian will be hidden and only 2nd & 3rd will be shown with their sub tabs.

In order to highlight the tab & also for Accordian to be open based on the selection, i wrote code as follows

$("#R16463536713741058563").accordion('activate',0);

in the page under the Execute When Page Loads region where ('activate',0) means the position of the accordian which will be taken as 0,1,2..etc.But when i login as user then as the 1st accordian will be hidden & the 2nd and 3rd accordians will become 1st & 2nd. So 1st & 2nd accordian wil be consider as 0,1 positions here.

So when i click on the 2nd accordian tabs then the accordian is not opening because in the pages of this accordian tabs i have given the code as

$("#R16463536713741058563").accordion('activate',1);

as the active is 1 so the accordian in position 1 is opening but i want the accordian in 0 position to be opened as i selected the tab under that accordion only.

View 0 Replies View Related

Application Express :: 4.2 - Validate Field In Tabular Forms?

May 13, 2013

1.- i have a product_item field (wich is a lov and user choose one value), so i need to call a function (sending it the selected value product_item) that will return me some data about the product i selected, for example :

if the function return 'A' then
disable the next item on tabular form, lets say quantity
else
enable the next item on tabular form, lets say quantity
end if

2.- i need to determine the result of two items operations:
total := final_quantity - start_quantity
the user will introduce start and final quantity and i will determine the total.

View 0 Replies View Related

Application Express :: Numeric Field In Tabular Form

Mar 25, 2013

I am using APEX 4.1 and Oracle 10g XE.

I want to restrict 3 digits after decimal in tabular form. Only three or less than three digits should be allowed after decimal and should be stopped automatically.

e.g. 34.543

View 6 Replies View Related

Application Express :: Default Value Date Picker Field

Nov 21, 2012

In a detail tabular form I am referencing a date picker field from the master form as default value.This is the situation in the detail form:

TABULAR FORM
Column Name: FECHAREGISTRO -- the field's name in the detail tabular form

Default Type: Item (application or page item name)
Default: P68_FECHAREGISTRO -- It's a field in the master form and also is Date Picker format
Reference Table Owner: SAMPEDRORIVEROS
Reference Table Name: BITACORAABOGADO
Reference Column Name: FECHAREGISTRO -- It's a date field in the database

At execution time I have the error:

report error:ORA-01790: expression must have same datatype as corresponding expression

I think it is because i must use to_date and to_char in order to change the datatype and i have tried using:

Default: to_date(to_char(:P68_FECHAREGISTRO,'DD-MON-YYYY'),'DD-MON-YYYY')

and in Default Type: PL/SQL Expression or Function but I get a different message at execution time:

report error: ORA-01722: invalid number.

View 1 Replies View Related

Application Express :: Change Read Only Condition From Always To None On Real Time

Sep 4, 2012

Can we change the condition of an item from always to none on the real time ? How ?

View 3 Replies View Related

Application Express :: How To Change Column Order In Interactive Report

Oct 18, 2013

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? 

View 7 Replies View Related

Application Express Listener :: Configuration - How To Change From Port 80 To 8080

May 29, 2013

I installed apex and configure the apex listener at port 80 by mistake couldn't pay attention to use port 8080. The installation is complete but the apex is running at URL.... but the login window is invisible on the page. I can just see the name on the tab "Application Express Login" . When i click on the error message at the bottom of the browser, the message says "apex is undefied" line 35.

When I run the server, I get a message "No free port within range 80. How can I change from port 80 to 8080? how to either un-install the listener or change the port 80 to 8080

View 3 Replies View Related

Application Express :: Change Content-disposition In Email Attachment?

Sep 17, 2013

I am using apex_mail (in Apex 4.1) to send emails with an attachment.

v_mail_id := apex_mail.send(
p_to => 'somebody@gmail.com'
...etc...
);
apex_mail.add_attachment( p_mail_id => v_mail_id
,p_attachment => v_image
,p_filename => 'signature.jpg'
,p_mime_type => 'image/jpeg');

Apex creates this as an attachment:

Content-Disposition: attachment;

I would like to change it to inline:

Content-Disposition: inline;

so I can reference it in my email body with <img src="cid:signature.jpg"/>. Well... I hope it is going to be shown inline anyway if I change Content-Disposition.

Currently (with Content-Disposition: attachment;) it works for Outlook, but, for instance, not in Gmail in the browser. Gmail shows the image separately as an attachment.

Is there a way to change the content-disposition with Apex?

I know it is possible to do it with utl_mail, but this is currently not installed in our databases. I need to involve our DBA to set this up, and I don't know if he is willing to do that.

View 2 Replies View Related

Application Express :: Change Page Template Body To Use 8 Columns Instead Of 12?

Nov 6, 2013

Apex Version: 4.2.0.00.27Theme: 25 I have a page that I need to divide by 8 segments, rather than 12 ( I will need to place items and buttons in one of the 8 columns). To begin, I have made a copy of the One Level Tabs - No Sidebar page template. I have tried to edit this template, and played with multiple combinations changing the Grid Layout and Display Points settings, but instead of creating a page that has 8 columns, that span the width of the page, I am just left with blank space. See attached:.[URL] And these are the Page Template Settings:[URL]  Is it possible to change the body section of the page template to have 8 columns span the entire width, without the dead space?

View 2 Replies View Related

Application Express :: How To Change Column Header Value Dynamically In IR Report

Oct 29, 2012

I have created report with the collections. Report query has been changing dynamically but i got problem with report header names and headers names has not been changing dynamically it is always showing like c001,c002....etc so, i have created global item(G_ITEM) in shared components--->Applications items after that I have created process(before headers) and assigning some value to G_ITEM and used &G_ITEM to column headres in IR Report but here &G_ITEM is not showing any value.

How can i achieve dynamic headers names by using *&G_ITEM(global items)*

View 1 Replies View Related

Application Express :: Tabular Form - Change Column Values Before MRU

Jun 4, 2013

I have a problem with Tabular form. Configuration: Oracle 10g, Application Express 4.1.0.00.32.

I have tabular form on simple table. I need to change some column values before MRU. For example: i have column named "UPDATE_DATE" where i need write SYSDATE every time this record was updated. I've created page process, associated with my tabular form.

Process point: On Submit - After Computations and Validations;
Sequence set to 1 (before "ApplyMRU" process - it has sequence 10);
When Button Pressed: Submit;
Execution Scope: For Created and Modified Rows;

Source:

declare
indx varchar2(255);
l_map wwv_flow_global.vc_map;
l_id number;
l_pk number;
begin
[code]........ 
   
But this doesn't work. MRU process writes old values, that was posted from browser. I tried change values by

apex_application.g_f04(:APEX$ROW_NUM) := sysdate;but this also not work.

How can i change values before MRU? Why wwv_flow_tabular_form.set_row_values doesn't change values?

View 5 Replies View Related

Application Express :: Default Value Of Radio Button Based On A Condition?

Oct 1, 2013

i have used radio button under dynamic conditions for an interactive report.eg: radio button values are like a) front end b)middlware c)back end.so based on the selected value of the radio button, interactive report appears. and each fields in radio button have separate set of users. now my issue is,based on the user logging in, the default value should set up while the page is loaded...[i.e... if a front end user logs in, the default value of tat radio button shd be front end...] 

View 5 Replies View Related

Application Express :: Automatic Row Fetch Based On Select List

Oct 27, 2013

db11gxe , apex 4.0 , firefox 24. I want to do automatic row fetch when the value of a select list changes ?but first i should ofcourse create a tabular form to fetch the data into it , but what i want is ,if i fetch 2 rows then the report contains only two rows , if i fetch 3 , the report contains only 3, if i fetch nothing , the report has nothing ? 

View 0 Replies View Related







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