Cascading Prompts

[system]

SELECT
  Country.country,
  Resort.resort,
  Service.service,
  Service_Line.service_line
FROM
  Country,
  Resort,
  Service,
  Service_Line
WHERE
  ( Resort.resort_id=Service_Line.resort_id  )
  AND  ( Service.sl_id=Service_Line.sl_id  )
  AND  ( Country.country_id=Resort.country_id  )
  AND  ( ( Country.country ) in @Prompt('EnterCountry','A','( Country.country )',multi,Free)  )
  AND  ( ( Resort.resort ) in @Prompt('Enter Resort','A','Resort\Resort',multi,Free)  )
  AND  ( ( Service.service ) in @Prompt('Enter Service ','A','( Service.service )',multi,Free)  )

Here is the query for cascading prompt. I am unable to see the LOV even I check the (i) Automatic refresh before use (ii) Export with Universe.

Exported the universe to repository.

thanks,

---

jayad (BOB member since 2008-07-11)

[system]

So, did you have a question?

How did you build the “cascading lov”? This looks like a freehand SQL query. I notice that the LOVs defined in 2 of the 3 @prompts are defined incorrectly. The 3rd argument of the @Prompt function is the LOV, and should be in the following format:

'Class\Object'

In your code, only the Resort one appears to be correct.

---

MichaelWelter (BOB member since 2002-08-08)

[system]

Hi All,

I am trying to built a cascading LOV. And I have done that as well, but the QA guys are not happy with that. I have implemented the LOV in two ways

1. expand the parent and select the child. (With + sign)
2. select the parent first and and then you will see the restricted child values.
   solution 1 is not at all acceptable to QA whereas solution 2 is partially acceptable. Partially because the parent is displayed under the child when you go to “Advanced” area to enter the parameters.

My question is can i reverse that. for ur ease I have attached the snapshot.

Regards,

---

obaid (BOB member since 2008-01-03)

[system]

In my opinion, Change the display order through “Creating cascading list of values”

Does any one have any other solution to it?

Regards,
Izhar

---

izhar (BOB member since 2007-07-11)

[system]

Thanx for the reply Izhar, but it is still not happening.

Does any body has got anything to say on this.

---

obaid (BOB member since 2008-01-03)

[system]

how you implemented the 2nd options… I tried hard to do it but…

---

vishalbotre (BOB member since 2007-10-05)

[system]

Cascading Prompts- please view the topic

FAQ: Designer

How do I create cascading or nested prompts? Author: Robert Metzker Let’s create a Series of Cascading Prompts for the Island Resort Marketing Universe. We’ll simply work our way through the Resort class for a quick example. All of the prompts will be fairly similar, and I am going under the assumption that everyone has some Designer Experience. Let’s start at the Highest Level that we’d need a prompt for. That would be the Resort itself, since we need to know what Resorts we’re int…

---

sunchega (BOB member since 2008-04-23)

[system]

I want to create
“select the parent first and and then you will see the restricted child values”
type of cascading prompt and could not able to find the information about it the given link. Please let me know which steps I should follow to achieve it.

Thanks in advance!!

---

vishalbotre (BOB member since 2007-10-05)