Application Express :: Display Value Into List Manager Box

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


ADVERTISEMENT

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 :: Get Display Value From Select List

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

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 View Related

Application Express :: Select List Read Only / Or Display Only

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

Application Express :: How To Decrease The Size For List Manager

Jan 7, 2013

how to decrease the size for list manager

View 0 Replies View Related

Application Express :: Display Quarter Of Year As Select List

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

Application Express :: Computation To Trim Off First Part Of String Within List Manager Item Values

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

Express Edition (XE) :: Display A List Of All User And Admin Accounts

Jan 28, 2013

I've installed XE and I want to know what accounts are active. If I log in to SQL*Plus as sys as SYSDBA how can I display a list of all user and admin accounts? I want to know who can log in.

View 3 Replies View Related

Application Express :: Select List With Value Yes And No

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

Application Express :: Display A Image

Nov 15, 2012

I am using this code

<img src="#IMAGE_PREFIX#LOGO.jpg">

in order to display in a HTML region a previous loaded image but it doesn't display the image? Something is wrong?

View 1 Replies View Related

Application Express :: Display Only And JavaScript

Oct 26, 2012

I have two Select Lists P58_TYPE_DOC (it shows for users that have not adm profile) and P58_TYPE_DOC_ADM (it shows just for administrator).

On my Page proprieties I have on HTML Header this code :

onload="show_fk_facture('P58_TYPE_DOC');show_fk_facture('P58_TYPE_DOC_ADM');"

I have to execute the java script when the page loads, but I cant execute the function for both items in the same time.

Because one of the items will be hidden, and the java script won't be able to find it.

I tried to use "if isNAN('P58_TYPE_DOC') else ....." but it doesnt work.

View 11 Replies View Related

Application Express :: Conditional List Of Values

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

Application Express :: Mobile - List Of Images From DB?

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 &#8211; 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

Application Express :: Hide / Display Tabs?

Jun 13, 2012

In my application, I have SSO authentication. However, I also want to restrict access to certain pages (tabs). What would be the best approach for this? Secondly, How can we hide/display tabs in the application?

I am on 4.1/11g

View 5 Replies View Related

Application Express :: Display PDF In Apex Region?

Jul 11, 2012

I have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.

I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned

[URL]...

View 20 Replies View Related

Application Express :: Display Horizontal Sub Regions

Mar 4, 2013

I am using APEX 4.0, my regions need to be displayed at "Display Point: Display Template Body 2" in column 2.I have 2 regions I want displayed horizontally, side by side.I want to use a parent region to contain them. I create my parent region, called it A, template = Reports, assign it to sequence = 10.I create my 2 sub region (B) and (C), sequence 20 and 30, template = Navigation, picking parent = A.By default, B displays above C. URL....

I copied the Navigation template, creating a new one called NAV2 and added this in the sub-region template section:(this cut/paste) doesnt display well here: it is the exact DIV begin/end block as posted above.

div style="float: left;"
#SUB_REGION#
div

I changed regions (B) and (C) to use template = NAV2, without any change in display behavior.I read further in the above post where it was recommended to reset the clear property, so I changed the above style like to: style="float: left;clear:none;".

View 5 Replies View Related

Application Express :: How To Display Blob As Text

Jul 9, 2013

I am developing an apex application using the apex cloud (apex.oraclecorp.com). I am using the DB link to show the data on APEX UI. I have a blob data which is stored in the remote DB, and I want to display the BLOB data as text on a popup or a new page or a download link.  I tried using display only item but APEX throws an error saying that remote DB is not supported. Also, It would be great if I can just show a download link on the UI for the BLOB data, again when I try to select the format as BLOB in the column attributes, When I give the table@dblink as BLOB table I get an error saying that "table@DBLINK not found". Is there any way to display the BLOB data as text or download it which is present in my local DB?

View 10 Replies View Related

Application Express :: Matching Against A Multi-select List

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

Application Express :: How To Connect List Of Values To Regions

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

Application Express :: Substitution String For List Entry

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

Application Express :: Last Image Of Popup List Of Value Does Not Hide

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

Application Express :: Enter Input In For Select List?

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

Application Express :: Changing Icon In List Region?

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

Application Express :: Display Row Number In Report Region

Feb 6, 2013

I would like to display the row number in the report region at the beginning of each row for each page (based on the number of rows to display per page).

So if the number of rows per page is 15, I would want to show each row from 1 to 15. When going to the next page (16 - 31) I would like to show row 1 to 15 again next to each row. And if the number of rows per page is 20, I want to see row numbers 1 to 20 on each page.

Since I believe an Update button only processes the current page, I would like to then use this row numbers (1 - 15) to get the values of the displayed column for each row to perform an insert to another table.

View 1 Replies View Related

Application Express :: Message Display Before Submit To Record

Nov 5, 2012

I have created two page process with two buttons "APPROVE" AND "CANCEL" button. first page process running approve invoice procedure on approve button and second page process running cancel invoice procedure on cancel button. i want to display massage before approve invoice and cancel invoice (DO you want to approve invoice) on approve button and (Do you want to cancel invoice on ) cancel button.

Working with apex4.1.

View 4 Replies View Related

Application Express :: Display State Of Interactive Report?

Jul 15, 2013

I've got an interactive report with detail and icon view enabled. How do I get the current display state (user looks at report, detail or icon view) out of the apex dictionary ?Is there any place in APEX_APPLICATION_PAGE_IR_... where I can find it ? I'm on APEX 4.0.2. Upgrade to APEX 4.2.2 is planned this fall. 

View 3 Replies View Related

Application Express :: Conditional Display With Re Captcha Plugin

Aug 22, 2012

I implemented the re Captcha plugin and it works ok. What I want to do is, on the same page where the captcha is displayed, to have a report region that is displayed conditionally based on the captcha result.

More specifically, the page has two items for user input (the captcha and a text item) and a Submit button. If the captcha is successful, then the text item will be submitted and the region displayed. The problem I'm running into is that the text item is always submitted regardless of the captcha.

View 3 Replies View Related

Application Express :: How To Display Picture Image On Form

Oct 24, 2012

I have just started using Oracle Application Express 11g. On my new attempt I am able to develop a table, report and a form, but I am not able to display picture image on the form though the browse link is active.

I can load the file name from the location folder to the form but it does not display. When I click on APPLY CHANGE then everything disappears. My main problem is how to successfully configure the settings for image display.

View 1 Replies View Related

Application Express :: How To Use Display Image Item On Page

Sep 24, 2012

APEX 4.0 Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server

I have a table which contain 3 columns, see below:

id primary key
pic1 blob
pic2 blog

there is 1 row in it(id=1), just for display 2 images.

Uploaded 2 images into above Blob fields by file browse function. Now, I want to show the 2 pictures in a Region by using display image item P1_AR, but it didn't work.

Based on: BLOB Columns specified in item source
Alternative Text Column: null
Filename Column: null
BLOB last update Column: nullSource used: Only when current value in session state is null
Source type: SQL Query(return single value)
Source value or express: select dbms_lob.getlength(PIC) from cp_pic where id=1

I got the error below after runing:
ORA-20999: P1_AR has to have a valid BLOB column as source

View 7 Replies View Related







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