Lets say you want to filter users based on department. You'll end up with two questions in your service offiering
- Department to search in. refresh the next question after changing this value.
- User.
the first question contains a simple list (see the table at
This Blog Post for more details on that)
- [null]
- LegitDepartment1
- LegitDepartment2
- LegitDepartment3
- ETC...
the second question is your actual query result question. The Criteria on this is going to compare the user's department to the results of the first question. >when the form loads, it going to run the following query:
- System.User where Department = [Null]
Since there are no users with a null department, this result will be empty and return immediately.
Then, the user goes down, hits the right department, and then hits refresh on the second question and gets the correct users, clicks the right one, and goes on with their life.