cancel
Showing results for 
Search instead for 
Did you mean: 

Cascading LOV / Smart filtering in BO Xi 3.1

Former Member
0 Kudos

Hi All,

I am working on creating a cascading prompt where I want a LOV results be depended on the previous prompt selection.

I read the thread :

Cascading LOV / Smart filtering in BOE 4
but Dev H didn't give the solution.

Does anybody know how do achieve this?

Thank you in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Amit,

Thank you for the prompt reply.

I followed the above link but the issue is :

Let say I want to select a Cascading LOV for Route - Milepost. which means user select the route, only milepost that exists on that route should be displayed.

So I created a cascading LOV using on Milepost Object.

While running the report :

I used Route , Milepost on the result panel and then used Milepost object in query filter with prompt.

When I run the report; it prompts to enter SRI (example I enter route 1), unless I enter SRI ; it wont prompt Milepost (example I enter 10). But after running the report , I get all the routes that has milepost 10.


But my expectation is to get only route 1 and Milepost 10 in the result (report run result).

Please let me know if I can achieve this.


Thank you

amitrathi239
Active Contributor
0 Kudos