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...
I was wondering if there is a substitution string ( or something else) that could be used to 'return' the name of a Form item that has cursor focus?
View 3 Replies View RelatedA 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.
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)...)
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'?
Variation of a post I entered last week.I have 2 queries, 1 obtains a list of paired entries, and the other for a given pair of entries returns a list of common locations.Both these queries behave exactly as I expect (although trimmed significantly for this example)With C++ code, i can recursively work through the results from query 1, and plug them into query 2, but this has a large time overhead.Preference would be to nest the queries so result is extracted during 1 connection, and not constantly requerying the database for additional sequences.
SELECT SWTT_HEADER.THR_ID AS S_HDR, DWTT_HEADER.THR_ID AS D_HDR
FROM RTDEV.TRIP_HEADERS SWTT_HEADER INNER JOIN
RTDEV.TRIP_HEADERS DWTT_HEADER ON SWTT_HEADER.TRIP_NAME = DWTT_HEADER.TRIP_NAME
WHERE (SWTT_HEADER.TME_ID IN (1)) AND (DWTT_HEADER.TME_ID IN
(2))Query 1 above gives me exactly the trip pairs I need, can range from 1 pair to a few thousand..Query 2 below gives me the common locations for a specific pair as extracted line by line from query 1.What I am looking for, is how to combine these 2 queries so that the values of THR_ID in query 2 are recursively pulled from query 1.
SELECT DISTINCT DWTT_BODIES.MASTER_NODE AS LOCN
FROM RTDEV.TRIP_HEADERS SWTT_HEADER
INNER JOIN RTDEV.TRIP_HEADERS DWTT_HEADER
ON SWTT_HEADER.TRIP_NAME = DWTT_HEADER.TRIP_NAME
[code]...
From the sample data, i expect query 1 to return pairs 1,9 2,10, 3,11 4,12 5,13 6,14 7,15 and 8,16
Entering 1 and 9 (first pair) as the THR_ID values in query 2 will yield B,C , as these 2 locations are common to both trips.
Entering 2 and 10 (2nd pair) as the THR_ID values in query 2 will yield G,H , as these 2 locations are common to both trips.
The aim is to achieve B,C,G,H from a single query.I figure if I can write C++ code for it, there has to be an SQL shorthand?
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 Relatedsay i got 10 select list each with value yes or no
I need to fire a dynamic action so i have a variable which will show the count of select list selected which has been selected as yes or no...
How can i accomplish this is apex 4.2 db 11g ?
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 ....
I have to review an application that has been developed in German and should be rendered in both German and English. So the previous developer has defined the application texts in German and has defined a translated application in English.
The problem is : there is a List Manager in a page that contains two buttons (Add / Remove). They are still defined with English text in the main application (German) and I cannot find any properties to change this.
The list manager also opens a popup with two other buttons. And the problem is the same. Do you any other solution than renaming every elements from the main application in English and then translate it in German?
I guess I can use a dynamic action to redefine the two visible buttons text. But it will not solve the problem for the popup buttons.
I am using Apex 4.1 and I have a select list in my page. I know i can access the value of the selected item by :P1_SelectList, but I would like to know how to access the display value of the selected item.
View 6 Replies View RelatedI was having a play with an icon menu system on apex mobile using a list template as described by Peter Raganitsch.Improve the APEX mobile Theme – Part 3 | get along with Oracle and APEX Though instead of using images from /i/, I wanted to source images from the database using apex_util.get_blob_file_src
However the rendered output begins
<img src="/i/apex_util.get_blob_file? If I run the following on page load
$('img').each(function() {
$(this).attr('src', $(this).attr('src').substr(3));
});
I get the output I want but the console is still full of errors and I feel very dirty.of displaying icon images from a report in the mobile interface?ie - similar to an iconic interactive report.
i am using List Manager Item .i have use List of values (lov)
SELECT LD.LOOKUP_NAME d ,LD.ID r FROM CRM_LOOKUP_MAS LM,
CRM_LOOKUP_DTL LD
WHERE LM.LOOKUP_ID=LD.LOOKUP_ID
AND LM.LOOKUP_TYPE='TRAVEL RHYTHM' and LD.ACTIVE_FLAG='Y'
order by LD.LOOKUP_NAME
}
when i click to add new value and click then pop up window open with LD.LOOKUP_NAME display value but when i click on add Button then value added in to below box with LD.ID
i want to display here my LD.LOOKUP_NAME value into below box.
How can i do this.
How can I search the tree with a given string?I don't find any function like "search(...)".I want to find the tree nodes which include the given string.
View 5 Replies View RelatedI have a 'Select List' widget (P_FILTER) which I have set to return multiple values. In my report region, I have something like this
Select A from B where B.Col_1 IN upper(:P_FILTER)
When user selects only 1 value, the report is correct but if user selects more than 1 value (e.g. 2), the report does not return any rows. How do I get the report to recognize the multiple values returned by the LOV?
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 Relatedhow to decrease the size for list manager
View 0 Replies View Relatedi am using Apex 3.2,
i am display popup list of value item with out refresh when i select some value from Radio button. But Pop up item lable and element is Hide but in last image of popup list of value does not Hide .
How can i hide this image of popup list of values
i am using
<script>
function Show_On_Radio_Value_2(pThis, pThat, pValue, pLabel){
var rv = html_RadioValue(pThis);
var elm = document.getElementById(pThat);
[Code]...
I would like to enter input in for a select list. That is, if I have a select list for the common colours (blue, green, red, ... ) that a user could query on, then I would like a user to be able to type in the colour - purple in the box next to the select list. I've looked at the select list options and couldn't see anything obvious?
View 2 Replies View RelatedI am new to apex , procedure to change the icon in List Region....... see the below link
[List Region Image[URL]....
I have Select list itemS based on Lookup tables. When the form in Edit mode, I want to prevent the end user from changing the value of these Select list items. How can I accomplish this ??? **If I change the type of the item to Display only, then it will show the returned value of the Select list.
View 1 Replies View Relatedv: 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.
I have, it would appear, successfully installed APEX 4.2 & APEX Listener 2.0 EA (in WebLogic). APEX works fine and it's reverse proxied using mod_weblogic through the OHS. I have configured APEX Printing to be via the APEX Listener.
However, creating a simple report, enabling printing, running the report (e.g. PDF or Word) produces the following few-byte content (only) inside the actual PDF file (obviously not in PDF format):
String index out of range: -1
Furthermore, it throws the exception below on the WebLogic console.
Any experience with the APEX Listener - and if so managed to rectify it?
SEVERE: String index out of range: -1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1931)
at oracle.dbtools.apex.hooks.postProcess.FOP2PDF.requestTOPDF(FOP2PDF.java:82)
at oracle.dbtools.apex.hooks.postProcess.FOP2PDF.postProcess(FOP2PDF.java:36)
[Code]...
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 RelatedI would like to convert some existing application popup LOV items that currently use a static list for the LOV values.I have not been able to find instructions on how to use the existing popup static list (or create a new static list) with the new SuperLOV plug-in. Is this possible to do?
If an example or instructions are available, a link to these.
I use apex 4.1..I have a tabular form a select like this
select
"STRATEGYID",
"STRATEGYID" STRATEGYID_DISPLAY,
"STRATEGYNAME",
"ISAVTIVE",
"STRATEGYSTARTYEAR",
"STRATEGYSTOPTYEAR",
"STRATEGYTYPEID"
from "#OWNER#"."STRATEGY"
where ISAVTIVE = 1STRATEGYSTARTYEAR and STRATEGYSTOPTYEAR as a Select List contain a value of year
I select from LOV like this
select y l, y v
from (select extract(year from sysdate) + rownum - 1y from dual connect by rownum <= 51)and
I have to Validate STRATEGYSTARTYEAR must Less than STRATEGYSTOPTYEAR
i am using Apex 3.2 ver.
i want to use below code in LOV select list
BEGIN
IF UPPER(:P23_SERVICE_TYPE) like 'GUIDE%' THEN
SELECT NAME D, CODE R FROM SPECIAL_SERV_MAS
WHERE NVL(ACTIVE_FLG,'N') = 'Y'
AND NVL(GUIDE_FLAG,'N') = 'Y'
and CITY_CODE LIKE NVL (:P23_CITY_CODE, '%')
[code]....
When i put this code in my LOV Select list Section then display me Error
Not Found The requested URL /pls/apex/f was not found on this server.
Oracle-Application-Server-10g/10.1.2.0.2 Oracle-HTTP-Server Server at tidevserv1 Port 7777
Technical description:
Oracle apex version 4.1.0
Oracle Db 11g
how to set Value to select list page item based on the return value of other select list page item(before header process i need to include or need to write a process)
Example:
Select country: [This is my first select list ]
Select State: [ This is my second select list, which i want to set in before header process based on the first select list]
I need to display quarter of current year in select list.
for example current year is 2012 so, i want Jan-Mar 2012,Apr-Jun 2012,July-Sept 2012,Oct-Dec 2012 in select list.
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