Application Express :: List Manager Translation
Feb 1, 2013
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.
View 1 Replies
ADVERTISEMENT
Feb 15, 2013
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.
View 0 Replies
View Related
Jan 7, 2013
how to decrease the size for list manager
View 0 Replies
View Related
Mar 14, 2013
I would like to ask if is possible to translate the "Browse..." button of File Browse item.
For me it seems that the button cannot be translated to a different language. I have tried to export the XLIFF and there is no string like "Browse...", also I have tried to edit it manually in translation repository, but the string is not present here.
View 3 Replies
View Related
Jul 1, 2013
A 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.
View 7 Replies
View Related
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
Mar 4, 2013
say 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 ?
View 2 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
Sep 9, 2012
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 Related
Oct 17, 2013
I 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.
View 2 Replies
View Related
Mar 8, 2013
I 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?
View 2 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
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
Dec 27, 2012
i 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]...
View 0 Replies
View Related
Nov 28, 2012
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 Related
Nov 23, 2012
I am new to apex , procedure to change the icon in List Region....... see the below link
[List Region Image[URL]....
View 0 Replies
View Related
Sep 3, 2012
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 Related
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
Oct 1, 2012
I 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.
View 3 Replies
View Related
Aug 30, 2012
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
View 4 Replies
View Related
Jun 11, 2012
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
View 3 Replies
View Related
Feb 22, 2013
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]
View 1 Replies
View Related
Jul 16, 2012
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.
View 3 Replies
View Related
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
Aug 5, 2013
Basically I have a report that as part of it's source sql takes in an element from a select list.
E.G. SELECT * FROM table_name WHERE table_column = : P1_SELECTLIST
This works fine when the user selects an option from the select list however the first time the page runs it always returns data not found. The options correctly appear in the select list as they should without any nulls although it seems the select list is still initializing as null. I have been told to try and add a computation before the header on the select list item, although I'm not sure if this would work/how to do this.?
View 4 Replies
View Related
Jun 29, 2013
I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action.
View 7 Replies
View Related
Oct 4, 2013
Apex 4.2.3 jquery mobile app
I want to style a select list using css .The HTML Form attribute class property does not work.
Item name: P1_LIST inline CSS:#P1_LIST{ -webkit-border-radius: 100px;border-radius: 100px;
background-color:yellow;border-color:yellow}
The background color is picked up. The other settings are not picked up.Is there something that I'm missing? [URL]
View 1 Replies
View Related
Oct 18, 2013
Let me explain, I have two items in my page, the first is not required, if it is null the second field is a value list based on selection A (select from A. .. A. .. where . A..) but if the field is not null then the list of values of the second field is based on the selection B (Select B from B where B. ..).
I create a dynamic action on the event "change" of my first field, on the "true action" I tried this:
declare vva_ternum Varchar2 (3): = null;Begin APEX_ITEM.SELECT_LIST_FROM_LOV (2, : P26_TERNUM, 'LOV_RSPRODUIT_TERRITOIRE'); End;
But it does not work!!
View 5 Replies
View Related
May 10, 2013
I am trying to create a tabular form based on a SQL query, that has a query-based select list with a where clause that references a column in the originating SQL query.
The situation is, I have a table that stores client_id, source_id and build_id, lets call it client_source. I have a second table, build_source, that contains source_id and build_id, with a one to many relationship between the two (source_id of 1 could have build_id of 1-7).
Using a tabular form, I want to select the corresponding build_id to be used in client_source, but the select list must only contain the build_id's for that rows particular source_id.
Here is an example of the SQL source of my tabular form;
select
s.ROWID,
s.CLIENT_ID,
s.SOURCE_ID,
APEX_ITEM.SELECT_LIST_FROM_QUERY(1, s.BUILD_ID,
'select b.build_id display, b.build_id return from
build_source b where b.source_id = s.SOURCE_ID ') lst
from client_source s
... what I am trying to achieve is that the source_id fields in bold match. When the query is built this way I get an 'invalid identifier' Oracle error on s.SOURCE_ID at runtime.
Is there some special tags that need to be used to reference the outside column?I am running on Application Express 4.1.0.00.32, on a Oracle 10g release 10.2.0.4.0 database.
View 2 Replies
View Related
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
View Related
