Application Express :: LOV With Optional Values For One Entry
Jul 11, 2012
As there is no boolean datatype in oracle (I wonder why, it exists in ms-sql, and I'm still quite new to oracle) you have several ways to 'simulate' a boolean. (1/0, 'Y'/'N', in german 'J'/'N', or this in small caps...)
Now for a checkbox you have to include the 'true'-value in the LOV. But what, if your database doesn't use '1', as you have implemented, but 'Y', or what, if the 'false'-value is not '0' but null? Each time you would have to adopt your STATIC2:...
So I am wondering about a flexible solution, and I would like to ask if and how it is possible. (Havn't found anything via searching for that yet.)
Instead of writing:
STATIC2: ;Y ... and having only the 'Y/N' implementation working, how about it would look something like that:
STATIC2: ;NOT('0' OR 'N' OR 'n' OR null) ... and a lot of reasonable boolean-implementations are incorporated. You could use a standard LOV for all checkboxes, dealing with different 'booleans'
But just like that, its not working...
So, a) it there a syntax for that at this point? and b) what do you think about that in general, or whats your 'best practice'?
View 0 Replies
ADVERTISEMENT
Feb 25, 2013
I have to check if an entered item is identical to a previous entered item.
Tried to use the Page Level Validation but am confused with the way to do it.
P.S> The issue is that the entered item should be identical to part of the previous item (i.e. substr(P5_item, 1, 8)...)
View 3 Replies
View Related
Jul 4, 2012
I have created a list with name Test_List and 5 values in it.
I want to pass the values dynamically when i select the list values (any of the 5 values).
I tried:
For each list setting(List Details --> Static list entries --> Target) i have set the
Request as ?Test_List=#Test_List#
Note: Here Test_List is my list name.
Also i have tried
Request as ?Test_List=&Test_List.
But nothing seems to be working...
View 8 Replies
View Related
Jun 16, 2012
Just to let you know this new section in SQL*Plus FAQ wiki page: How to have optional parameters and default values in SQL*Plus_script.
View 1 Replies
View Related
Jul 25, 2013
I used Region, Process by to search the report which appears as shown above. Then I use Choose Auditors column to select my Auditor and copy paste it into the report under To be Audited By col. Is there a way to automate the process. I am here using a tabular form in APEX. My main aim is to assign auditors based on Region, not equal to Processed by.
View 4 Replies
View Related
Apr 26, 2013
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 2 Replies
View Related
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
Apr 16, 2013
While working with Apex, i want to implement the following functionality :
the requirement is that, if the user creates a record in the one tab then the fields (say, Project Number, Task Number , Waterfall Number) used for creating the record should be defaulted in the next tab. How can i acheive this.
View 0 Replies
View Related
Mar 9, 2011
where i could get the order entry application wich is found in oracle 10g forms book ?
View 4 Replies
View Related
Nov 15, 2012
Is there any way I could set the condition on the list of values.
For example if Value of the item x is null then use select ...
and when value of the item x is not null use this select ....
View 4 Replies
View Related
Jun 20, 2012
I have two page , from first page to second page I am passing some values using url parameter passing but some values contains comma ex :- P1_ NATION text field contains INDIA,USA,UK
but apex treated that as these are separate values and assign it to separate items
suppose my intention is like P2_NATION,P2_EMPLOYEE,P2_EMPID :INDIA,USA,UK,SAGAR ,123
but apex treating it as P2_NATION = INDIA :P2_EMPLOYEE=USA :P2_EMPID = UK
I am using apex4.1 , db 11g , ie , chrome , ff.
View 2 Replies
View Related
Sep 14, 2013
I want to make DML process when the user logout :-i do the following steps :-1-I change the url &LOGOUT_URL to another page not the login page like 10 , as wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:102- Make tow process in the pageone (on-load before header) to do dml code like this
BEGIN
UPDATE SYS_USERS
SET ACTION_STATUS = 2
where upper(:p101_username) like upper(USER_NAME);
commit;
END;and another process after header
apex_application.g_unrecoverable_error := true;
wwv_flow_custom_auth_std.logout(
p_this_flow => :APP_ID,
p_next_flow_page_sess => :APP_ID ||':101'
);
to go to the login pagebut the dml code not executeand when try to login again i have this errorContent-type: text/html; charset=UTF-8 Content-type: text/html; charset=UTF-8 Set-Cookie: ORA_WWV_APP_100=-1; HttpOnly Location: /apex/f?p=100:101
View 1 Replies
View Related
Aug 20, 2013
I created list of values like Bar chart,Column Chart,Pie Chart.these list of values added to the text field named as Chat type. In same region i created 3 chart sub regions. My requirement is if i select chart type-pie chart.the page will show only pie chart region only.Same to Bar chart and Column charts also.
View 3 Replies
View Related
Dec 6, 2012
I was making some page validation to APEX_ITEM manual tabular form. When every a validation executes it will clear all the data what user enters. What is the best method to hold the session values in APEX_ITEM.
View 4 Replies
View Related
Mar 27, 2013
I have created a workflow which is going through 12 pages. At each page the user needs to choose his variables.
This could be the y-axes, x-axes, amount, surname ... etc. The variables are given to the next page via branch to next page process. Everything works well until I need to create an interactive report out of the chosen variables.
Lets say I have a variable called :P7_XAXIS with static LOV :
Amount,Amount;Date,Date;quantity,quantity
Page 8 is my IR. If I try :
Select :P7_XAXIS from mytable This will not work.
But if I try
Select Date from mytable This will work. Why? In my workflow there are several variables that can be used in a where condition. This also works. But I need to access the values before the condition and I also need to get a chart out of it.
View 1 Replies
View Related
Nov 23, 2012
APEX 4.2 - Base code from Denes examples
CODE ON HTML HEADER
<script language="JavaScript" type="text/javascript">
function f_setglp(pThis,p_app_item,p_other_record_level_item)
{
var curr_id = $x(pThis).id; // OK !
var curr_glp = $x(p_app_item).id; // returns undefined
var curr_orli = $x(p_other_record_level_item).id; // returns undefined
[Code]...
The Javasxcript function fires OK on click in the "Product" attribute but: PMO_GLP_PK is an Application Item that Javascript can´t reference as I called YES_NO is another tabular form attribute and the reference returns also "undefined"
what is the best way to implement this ?
View 4 Replies
View Related
Aug 23, 2012
this modal popup, it works correctly but not passing values from page page1 to my page3. How do i pass these paramater values to page3,
function modalWin() {
if (window.showModalDialog) {
window.showModalDialog("f?p=&APP_ID.:3:&SESSION.:POP:NO::P3_EMPNO:#P1_CUSTOMER_ID#::","name","dialogWidth:600px;dialogHeight:400px");
[Code].....
View 4 Replies
View Related
Aug 7, 2012
I had a complex drill-down dashboard where I was setting page items through $s(Page Item, value) from the Chart Links. But when I did the same thing in APEX 4.2 EA on [URL]...it is simply opening a blank page. whether in 4.2 that Java API has been removed?
View 4 Replies
View Related
Oct 4, 2012
I have a user requirement where they want to be able to select multiple values for a single parameter that will act as a filter for a report. The possible values for a parameter can come from almost any master data Oracle eBusiness table. I don't want to just present the user with a LOV where they search down a list selecting what they want. That wouldn't be very practical for selecting part numbers from 1000's of rows. I also want the user to easily see what values they have selected. I thought about providing a button that would navigate to a multi-row form where they could record their values and use those values in the where clause of the SQL for the report, but that is a somewhat complex solution I have never tried before. how to do this. I'm working in the latest version 4 of APEX.
View 1 Replies
View Related
Nov 20, 2012
Not able to open login page 101 in my internal application. I am getting below error
ORA-12170: TNS:Connect timeout occurred
Error Not able to get parameters values
OK
View 2 Replies
View Related
Sep 18, 2012
How can i apply currency format to the select list values queried from database tables. The data is stored in database in number format. The user wants to see 1000 separator commas in the list item values.
View 2 Replies
View Related
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
Sep 3, 2012
I am running a two node rac on grid 11.2 and db 11.2.0.3. My application does not like the scan listener, therefore I have to configure the remote listener parameter to the vips of the two hosts, which is working fine.
But it comes out the the system needs the service registered with the scan listener. So. How can I add a static service entry for my scan listener ?
View 7 Replies
View Related
Jun 10, 2013
The values in the page item dont get submitted hence generate errors in my application , in apex 4.2 using collectionEg.
apex_collection.add_member(p_collection_name => 'ORDER', p_c001 => :P56_product_id, p_c002 => :P56_product_name, p_c003 => :P56_list_price, p_c004 => 1);
Can there be a reason why ?
View 4 Replies
View Related
Jul 27, 2012
I am working on APEX 4.1.1 on Linux server. I have created one application in which I have take a HTML region where i have written the following code:
<input type="text" id="APP_ITEM1" name="APP_ITEM1" />
I am able to see the text box in page, but not able to fetch the value from it.
View 9 Replies
View Related
Sep 14, 2012
Application Express ver. 4.1
I have created a form. Some of the elements are hidden such as updated_by and update_date. I have provided the default values for these attributes as pl/sql expression in the "default section" (Application->page->edit page item). I am using the Process Row process that is automatically created when a form is created.
The problem is when I click the update button, the updated_by and update_date is passed as null values which throws an error from the database.
View 2 Replies
View Related
Apr 17, 2013
Oracle 10, Apex 4.0.
Working on this query:
SELECT waarde1,waarde2,
APEX_ITEM.POPUP_FROM_QUERY (3,waarde3,'select select ((waarde1-0.1)+(level*0.1)) d, ((waarde1-0.1)+(level*0.1)) r from (select * from lov_test where waarde1 = c001) connect by level <= (((waarde2-waarde1) *10)+waarde1)') waarde3
FROM lov_test
ORDER BY 1
The idee is to get a popup or dropdown box for "waarde3" in witch the selectable values are waarde1 to waarde2 rising with 0.1 at a time.
And this in a multi row updatable report.Example
waarde1 waarde 2 waarde3
(possible values in the dropdown box)
1 4 1-1.1-1.2 ... 3.8-3.9-4.0
3 7 3-3.1-3.2 ... 6.8-6.9-7.0
The error I get is:Error in init lov: ORA-00936: Ontbrekende uitdrukking. p_lov:select select ((waarde1-0.1)+(level*0.1)) d, ((waarde1-0.1)+(level*0.1)) r from (select * from lov_test where waarde1 = c001) connect by level <= (((waarde2-waarde1) *10)+waarde1)wwv_flow_security.g_security_group_id:1264429985836387wwv_flow_security.g_curr_flow_security_group_id:1264429985836387 Unable to initialize query. For every row in the table lov_test.
View 5 Replies
View Related
Jul 27, 2012
We have generated a fancy custom interactive report, in which the columns of string type, but can hold string, numeric or date values. However the type of values are uniform for a particular column. The end users wants to use the numerical values for generating charts, but, being a string column (though the data is numeric), it throws an error and they could not generate the chart. Is there any way to make use of this string column type numerical data for generating chart?
The current version of apex is 4.1.
View 4 Replies
View Related
Sep 7, 2012
I would like to have a table in HTML region and to display in the table some Page Items from the page.
I got the code like this:
{
<table>
<tr><td>&P1_ECEMEA_ASSISTANCE</td></tr>
<tr><td>&P1_ECEMEA_WIP</td></tr>
</table>
}
It shows the Page Item names as text, not the values. However this code without the table tags:
{
ECEMEA Request for CQT Assistance: &P1_ECEMEA_ASSISTANCE.
ECEMEA CQT Work in Progress: &P1_ECEMEA_WIP.
}
works and the Page Item values are displayed.
Is it possible to display the Page Item values in the HTML table at all or I have to use a different method of showing the values in a table? The above is only a snippet of the code. I need to display about 30 Page Items, formatted in a table with headings.
what kind of region is the best to be used or if I should only use some escape symbols in the table code.
View 2 Replies
View Related
Aug 15, 2013
I am creating multiple entries for auto populate item as shown in this jquery plugin link below but i am trying to change this so values come from table query. how can i achieve this even using web services in apex 4.1.1 but i am trying NOT to use remote url or external file?
[URL]......
View 3 Replies
View Related
