LOV, or list of values, refers to drop-down/pop-up lists in combo boxes often found in graphical-user-interface computer applications.
Questions tagged [lov]
78 questions
0
votes
1 answer
Set hidden values for popup lov
I am trying to use a oracle apex popup lov. Everything works fine. My PLSQL query returns a list of values and it's getting displayed correctly. The question now is if there is a way to store hidden values to theses query results?
For example: The…

Filip Degenhart
- 631
- 4
- 19
0
votes
1 answer
Can we find a table that is used in a set of FMBs without opening it individually in Oracle Forms?
I am using both Oracle Forms version 11g and 12c.
Is it possible to find a table for e.g table1 used in the Oracle Forms application screens including LOV's without opening each FMB individually and searching in it.
Totally there are around 50-75…

Gautam S
- 41
- 1
- 1
- 7
0
votes
1 answer
Creating Dynamic LOVs
I have a form in oracle apex with more than seven items on it. they are
SUBJECT_ID,GRADE_ID,DOMAIN_ID, CATEGORY_ID, STANDARD_CODE, STANADARD_STATEMENT, LEARNING_TARGETS.
I want these items SUBJECT_ID,GRADE_ID,DOMAIN_ID, CATEGORY_ID, STANDARD_CODE…

tayyeb
- 1
0
votes
2 answers
Fetch Id from SelectOneChoice in ADF 12c
I am using Oracle ADF12C, I have a table which has an strong textselect One Choice>(Customized Query) as a column, on change of the value I need to open a popup, I have tried using value Change Listener to fetch the ID but not able to find. Any…

Shaik
- 1
- 2
0
votes
0 answers
Cannot pass a value of an IG column to LOV parameter
My problem is when trying to pass the value of an IG column to a parameter of LOV (based on Rest Data Source), the value did not passed.
However, I am able to pass the value of a page item successfully or a static value, but not the value of the IG…
0
votes
1 answer
Oracle APEX 20.2 Problem with the cascading LOV (built on Web Source) in an Interactive Grid
I have a master form and a detail interactive grid.
And I have two LOV's on the interactive grid, both of them are built on Rest Web Source.
First LOV is a master & the second one is the cascading LOV with a parameter from the master.
The problem is…
0
votes
0 answers
Problem with selection from LoV oracle apex
I created a LoV for the a page item with following PL/SQL Code:
SELECT r.REASON AS displayed, r.CODE
FROM REFUSAL_REASONS r
WHERE CODE='R';
I have set the following properties in the column mapping:
Return Value:SHORTCODE,
Display:…

user111
- 137
- 1
- 15
0
votes
1 answer
Text field with autocomplete oracle apex
I have created a function that outputs a nested table based on the email entered in a page element.
The values are fetched from the ldap.
The function works and when I call it, I get the desired values from the LDAP.
Now I have created a page…

user111
- 137
- 1
- 15
0
votes
0 answers
Set page item value depending on selection of lov in oracle apex
I have the following issue.
I have a page element of type popUp-LoV with the following SQL query:
SELECT u.Lastname || ', ' || u.Firstname AS displayed, u.UUID as ID
from STAFF s
left outer join USERS u on s.UUID=u.UUID
union
SELECT u2.Lastname…

user111
- 137
- 1
- 15
0
votes
1 answer
Oracle APEX return multiple values in LoV
I have a field as PopUp LOV and as source a shared component with the corresponding code.
`SELECT u.Lastname || ', ' || u.Firstname AS displayed, i.IUUID
from INTERNAL_SUPERVISORS i
left outer join USERS u on i.UUID=u.UUID
…

user111
- 137
- 1
- 15
0
votes
1 answer
How do I list numbers -for example from 1 to 20- in a LOV item by using pl/SQL function? Return values are same as display values
I'm trying to list numbers -for example from 1 to 20- in a LOV item by using a loop in a pl/SQL function. It must be possible but I haven't succeeded yet. Thanks for your precious helps.

Old Junior
- 1
- 2
0
votes
1 answer
Oracle ADF LOV based query and return the result set
I am new to Oracle ADF. My situation, There are two LOVs. First one has 2 values, emp and dept. Second LOV gives the values based on the first one. I have did this using LOV Switcher. Now I need to show the result row, based on the both the…

rishi08
- 1
- 1
0
votes
1 answer
How to choose a timestamp data type value from a LOV in Oracle APEX
See imagehttps://i.stack.imgur.com/BSlpn.jpg
What is a simple way to insert timestamp values in my setup?
The LOV right now exists of static content, I just filled in the '10:00' manually.
Still a noob so I'm sorry if this is very obvious.

JtotheY
- 7
- 1
- 4
0
votes
1 answer
How to condition an APEX LOV when using APEX_ITEM to create a dropdown list within an interactive report?
Hi everyone I am having a bit of a difficult time even trying to find articles on apex collections and the apex_item functionality but was wondering if anyone has any experience on how to condition a LOV when the the select list has been generated…

Helen Marmion
- 23
- 4
0
votes
2 answers
show display value instead of id from a LOV in display only table in oracle apex 20
Am using a LOV in a form like below,
Display | Value
------- | -------
A | 1
------- | -------
B | 2
------- | -------
C | 3
------- | -------
As you know in a select list display value is the showing value but actual save…

Pumayk26
- 537
- 10
- 28