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