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
1
vote
2 answers

Select list oracle apex second value

When I create a Select list based on a SQL query it asks for 2 columns. For example I did something like: select itemcode, itemname from items in a select list called LST_ITEMS. I need to retrieve or get both of the values when I call it with…
Alex Sáenz
  • 25
  • 2
  • 4
1
vote
2 answers

Getting all return values of LOV programmatically

I'm currently working on a CRUD application and I have defined a LOV like this: My question is how can I get all these return values in for example a ValueChangeListener defined like this: public void onValueChanged(ValueChangeEvent ev){ …
EldarGranulo
  • 1,575
  • 1
  • 14
  • 37
1
vote
1 answer

OpenUI Get List of Values

I am looking for a smart solution how to retrieve the Data from a LoV from a Business Component of Siebel. I tried to read the control with,... var controls = this.GetPM().Get("GetControls"); for(var control in controls){ var value =…
Max Weber
  • 1,081
  • 11
  • 21
1
vote
1 answer

How to select between two LOV's based on some condition in Oracle form 6i

I am developing a form in Oracle Apps (Oracle Form 6i). I need to provide LOV for a particular field, Say "size" and also I want to have multiple LOV which can be selected by some condition. For example: I have two field : "Liveries_Category" and…
Arka Banerjee
  • 47
  • 1
  • 10
1
vote
1 answer

ADF Cascading Lov Search and Select popup customization

I have built a cascading LOV with Group and division fields (Combo box with list of values). When I select a value for Group and click on Search and Select dialog for Division field, the SearchAndSelect popup has both Group and Division fields as…
Soumya R
  • 455
  • 1
  • 5
  • 21
1
vote
3 answers

How to pass parameter top LOV query in SpagoBI

How I can pass a parameter to a LOV query in SPagoBI? I am creating a LOV using query ... something like this: select id, name from table1 where parent_id = ${parent_id} When I click on "Test before save" to evaluate query appears window with title…
gandra404
  • 5,727
  • 10
  • 52
  • 76
1
vote
1 answer

Using SQL Not exists in LOV in Apex 4.0

I'm having trouble with the following sql query select sr.rekeningnummer display_value, sr.rekeningnummer return_value from studentenrekening sr where not exists (SELECT * FROM studentenkredietrekening skr …
Elvira
  • 1,410
  • 5
  • 23
  • 50
1
vote
0 answers

SQL - How to embed LOVs?

I'm trying to suggest DB structure. There is little problem and I hope anyone can help me. There are following tables: VEHICLE (basic entity with shared properties) id kind_id KIND (personal car, utility vehicle) id name KIND_SPECIFIC_EQUIPMENT…
MakoBuk
  • 464
  • 2
  • 8
  • 18
1
vote
1 answer

Oracle : Execute Query with LOV selected value

I need to run a query with a value that is selected from a LOV. I've got the next setup : a block named "MENIU" a table named "MENIU" with a column "ID_MENIU". a LOV named "LOV_MENIURI" a parameter named P_IDMENIU a button on the form named…
Mosfet
  • 35
  • 1
  • 3
  • 7
1
vote
2 answers

Oracle Apex - Optional List of Values (LOV)

Is there a way in Oracle APEX to use a list of values or select list but do not force the user to select an item and allow them to enter different items? The basic functionality which I require is similar to a combo box where you can optionally…
Mark3308
  • 1,298
  • 11
  • 22
1
vote
1 answer

Oracle ADF: remove blank option in cascading LOVs

I'm using JDeveloper 11.1.1.7.0 I have a problem with cascading LOVs. They finally are working fine, but I have an issue I can't fix, and it's the blank option at first. I have been trying lot of things: setting the No Selection Item at first: It…
yaki_nuka
  • 724
  • 4
  • 26
  • 44
1
vote
1 answer

Oracle Apex: Conditional List of values with concat

I am trying to build dynamic and conditional LOV on condition taken from the page item. I came across this example ... IF :P123_CHOICE = 'EMP' THEN RETURN 'SELECT ename d, empno r FROM emp'; ELSE RETURN 'SELECT dname d, deptno r FROM…
Jestem_z_Kozanowa
  • 607
  • 3
  • 13
  • 38
1
vote
1 answer

APEX 4.2 - Using LOV with Interactive Report

now I am using ApEx 4.2 and I want to update my form from Classic Report to Interactive Report. I have a LOV for translating IDs to human readable labels. But with Interactive Report, I can't configure my form using my LOV. with Classic Report I…
Dr. Stefan Franke
  • 13
  • 1
  • 3
0
votes
1 answer

List of values with multiple return items

List of values, with multiple columns and multiple return values in Apex. It's a question i've seen around the web quite a few times, but i'm struggling with it aswell. Coming from Oracle Forms, and now migrating forms to Apex, this is a feature…
Tom
  • 6,988
  • 1
  • 26
  • 40
0
votes
0 answers

Oracle APEX Restrict Shared component LOV during run time

I have a requirement to show 7 columns in the select list of the LOV, I tried using shared component LOV but unable to restrict it based on the values from the form field. let's say there is a field :P100_Customer. My shared component LOV is SELECT…
vr_oracle
  • 11
  • 3
1
2
3 4 5 6