Stack Overflow
Stack Overflow

Questions tagged [lov]

LOV, or list of values, refers to drop-down/pop-up lists in combo boxes often found in graphical-user-interface computer applications.

78 questions
4
votes
3 answers

Conditional Lists of Values in Oracle APEX?

I need to use the value of one Select List to populate the value of a second select list, but the items in Select List number two are going to be from a completely different tables depending on what's selected in list number one. Is there a way I…
Sonny Boy
  • 7,848
  • 18
  • 76
  • 104
3
votes
3 answers

Oracle APEX tabular form, need to make a column Read Only. Except on a new row when “Add Row” is clicked

I am new to Oracle APEX. Can you please help me with below issue? I am using APEX 5.0 I have a master detail page where I have a Tabular form. One of the column is using LOV from select list. Now I have to make this column values as read only so…
user3780030
  • 81
  • 2
  • 8
2
votes
1 answer

APEX Creating Dynamic List of Values in a tabular form

I have a query similar to : SELECT empno, empname, deptno FROM EMP in a tabular form, where deptno is a SELECT LIST containing all of the records in DEPT. I'm trying to use empno in a sub-select within the LOV query in order to limit the number of…
richard simon
  • 21
  • 3
2
votes
0 answers

Oracle Apex Select list with Cascading LOV Parent Item AND 2 parents with dependencies

I have the following problem: First: Two select lists (A & B) with years depending on each other. When List A has a selected year, list B should have the entry 'Alle'. And also the other way round. Works fine with a dynamic action. Second: Depending…
Raffaello03
  • 21
  • 2
2
votes
3 answers

Conversion of multiple values within one column

I am working in Oracle Apex 4.2. I have two tables: I have simple report to build select id, name, location_id from tablel1 ----------------------------------- | ID | NAME | PROJECT_ID | ----------------------------------- | 1 | P1 …
Jestem_z_Kozanowa
  • 607
  • 3
  • 13
  • 38
2
votes
2 answers

APEX LOV Display value reference

This us related question to: APEX LOV Display value look up where Tony Andrews recommends doing: select display_value from apex_application_lov_entries where application_id = 123 and list_of_values_name = 'DEPT_LOV' and return_value =…
Nick
  • 73
  • 1
  • 2
  • 7
2
votes
1 answer

Oracle Apex 4.1 how to create field which is either LOV and text field

I came a cross issue when designing new form in Oracle APEX. I was asked to create field which can be a populated by user input or by drop down list(popup LOV). Is there easy way of designing such element ? Any help greatly appreciated.
Jestem_z_Kozanowa
  • 607
  • 3
  • 13
  • 38
2
votes
2 answers

Oracle APEX - How to create popup LOV which contained multiple display values?

I am trying to create LOV in Oracle Apex 4.1 which would contain name and surname of employees and would return only his/hers id. The syntax which does not work looks like this : select FIRST_NAME,LAST_NAME as display_value, USER_ID as…
Jestem_z_Kozanowa
  • 607
  • 3
  • 13
  • 38
1
vote
2 answers

Oracle APEX - How to access Popup LOV value from Interactive Grid using JavaScript (some JS help please!)

Oracle APEX Version: 21.1.0 I have a number of interactive grids on an APEX page (one for each day of the week) and I want to save the data from each into an APEX Collection. The IG_MON interactive grid contains 3 columns, their Static ID's…
Mandy Walsh
  • 31
  • 3
1
vote
1 answer

Interactive Grid column with "Function body returning PL/SQL" gives errors referencing columns (bug?)

Lets suppose I have a table with 2 columns (A and B). One of these columns (A) will define the LOV of the other (B). I have an IG with column B set to "Popup LOV" and the list of values being "Function body returning PL/SQL". I have put this demo…
Gerard Otín
  • 21
  • 3
1
vote
2 answers

how to set direction for list of values 'LOV' in oracle forms

how can I change direction of LOV using set_item_property ? I want to change the direction based on a parameter value , if set_item_property is not available do you have any suggestions ?
Samah_Bari
  • 21
  • 5
1
vote
1 answer

session item does not change when using lov in primary key

I am implementing a Interactive grid to perform DML operations on a table. it has combined primary key of two columns One primary key column is display only and refer to master table and another primary key column I want to have a LOV to select…
Bhanni
  • 27
  • 1
  • 8
1
vote
3 answers

Filter Data block with a LOV value in Oracle Forms 10g

I need to implement a simple product form from a block of data called "PRODUCTS". The products are related to a "Partner" through the field "COMPANIES_PARTNERS_ID". This field will be represented by an LOV to select the Partner for which we want to…
Sergio Sánchez Sánchez
  • 1,694
  • 3
  • 28
  • 48
1
vote
4 answers

How to have static value as first value in list using JavaScript? ORACLE APEX - LOV LIST

I am using Oracle Application Express 4.2 and I have an LOV (List of Values) with a list of flight numbers in a select list. This is a dynamic list of values. I want to add a static value at the top of the select list that says "Upcoming". I also…
Chris M
  • 143
  • 2
  • 14
1
vote
0 answers

Customizing OIM Default user form interfaces: Implementing Custom Cascading LOVs

Below is the details of my tasks. Define component binding for the User Type field and any parent component of Job Code, for example, form root panel.
 Implement the model for Job Code LOV component by ensuring the following: I) The model must take…
prabhat gangwar
  • 61
  • 4
  • 10
1
2 3 4 5 6