SecureFilter pulldown data change by user choice

[metalmilitia]

Hi! I want to create a securefilter combobox that change respect choice made by the user; for example if the user choice "Fruit" in the first one the second one have to display only fruit-based food.

I tried this way:
2 input --> food-category, food
1 GetData from Relational -> select* from food-category that returns
a food-category-list
1 PromptSecureFilter that display food-category-list and set food-category_param
1 GetData from Relational -> select * from food-category, food where food-category.category = food.category that return a subquey food-list
1 PromptSecureFilter that display that display food-list and set food

in this way something goes wrong, infact the second PromptSecureFilter display only a null value

can someone help me? thanks

[metalmilitia]

Solved with a pentaho restart :-D

and so, question 2 :-D how can i have either prompt secure filter in the same page? is it possible?

[pstoellberger]

i don't think thats possible, you would need js/ajax to load the choices for the second pulldown list