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
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.
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…
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