I wasn’t sure of the best title for this question, but here’s my issue…
In Vision I would have a power table and based on the result of a dropdown I would create a query string, then use this string in the SQL binding. I’m sure that’s all kinds of wrong, but that’s how I did it. With Perspective, and using named queries in general, what would be the best approach to this, short of stacking tables and using visibility?
The differences in the queries were substantial, returning different columns, different where clause, etc.