Skip to Content
avatar image
Former Member

Cascading LOV / Smart filtering in BO Xi 3.1

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 15, 2017 at 06:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2017 at 06:13 PM
    Add comment
    10|10000 characters needed characters exceeded