Skip to Content
1
Former Member
Jan 06, 2012 at 12:06 AM

Information Design Tool - Prompts with Dynamic LOV's

529 Views

Hi All,

In the Business View Layer of the new Information Design Tool I am having issues getting a dynamic list of values to work in a pre-defined filter that contains a prompt referencing the dynamic list of values.

Let me explain...

I have created a List of Values based on a Custom Hierarchy and called it Hospital Ward.

Hospital

Ward

When I preview this List of Values, it shows me Hospital and when I expand a Hospital I can see which Wards belong to that hospital. Perfect.

Next I create a Parameter, called 'Hospital > Ward Prompt' that allows multiple values and references the Hospital Ward LOV that I have just created.

Next, I create a filter and call it, Prompt Hospital Ward with the following definition:

@select(Hospital\Ward Description) in @prompt(Hospital > Ward Prompt)

I then proceeded to test the Prompt Hospital Ward filter in a Query.

Result Object:

Ward Description

Query Filter:

Prompt Hospital Ward

I execute the Query and the prompt pops up with the List of Values of Hospital > Ward. I expand Hospital and I can see all the Wards associated with that Hospital. I select 5 Wards and click OK. No data is returned.

Tell me what I have done wrong in this scenario? I think this is a bug with the IDT tool.

Why...because I can get the dynamic List of Values to work, when I don't created a pre-defined filter.

If I make the List of Values for the Object Ward Description reference the Hospital Ward LOV and then create the same query again, but this time, in the Query Filter, I don't select the pre-defined filter and use the Result Object in the Query Filter as well and prompt for the List of Value Hospital Ward, it works.

Result Object:

Ward Description

Query Filter:

Ward Description In List Prompt Hospital Ward LOV

This works and filters correctly.

The SQL looks like this:

SELECT

Dim_Ward.WardDescription

FROM

Dim_Ward

WHERE

Dim_Ward.WardCode IN @prompt('Select a Hospital, then a one or more Wards','A:A','Hospital_Ward LOV':'Ward Description',Multi:Any,Primary_key,Persistent,,User:-1)

Just wondering, really, why I cannot get the same to work with a pre-defined filter?

Thanks,

Ainsley