CODEWITHSUNDEEP
sqlexpressoracle-apexlov
pixelious0618
pixelious0618

Reputation: 1

SQApplication Express (Apex) - Displaying the result from cascading list of values (LOV) selection

I have been working on this for a while now and am stuck on finding the solution.

This is what I would like the end result to be - displaying this table below based on the selection from LOV #1 AND LOV #2:

PIC 1

This is what I have so far:

PIC 2

How do I make the page to display the result of the 2nd LOV selection into the likeness of the first picture?

In other words, after the second LOV is chosen, I would like the third part (Column Names) to be displayed in a report format instead of selection list format.

I am on Apex version: 4.2.0.00.27

Upvotes: 0

Views: 176

Answers (1)

Thomas
Thomas

Reputation: 203

You need to create a report which has your select list as a bind variable and your SQL query using the select list in the where clause. Create a dynamic action on your select list for the OnChange event. You need to refresh the report in the dynamic action when triggering the event.

Upvotes: 0

Related Questions