WAD 7.0: How to have a filter set before execution?

[Former Member]

I'll state the obvious and say that I am new to WAD 7.0...

I can't seem to find documentation on this, so if it does exist and you can point me to that i'd be greatful. Here is my issue:

Basically what I have is a Web Template with 5 graphs on it, all of which are tied to Data Providers that are linked to Queries and Query Views. What i'm trying to accomplish is to have a filter or restrction defined within the Template before it gets executed. Where can this be done? If you execute the Template you can then choose from a list of Regions to filter by, but how can i set this filter prior to execution, just so the graph doesn't look so messy on the inital launch of the app? i can't find any type of setting for that in the Web Item Parameters tab or in the XHTML tab.

This picture may help explain things a bit better:

http://img607.imageshack.us/img607/7669/pic1mr.jpg

If you need more information let me know and i'll provide what i can. Thanks!

[former_member186696 · Accepted solution]

Hello,

You can filter the query with a hard filter (fixed filter ) on query designer.

So, each query will comes already filtered.

Or, you can create a variable for this query. Then, you can select the filter via variable screen.

A last option, you can create views of all queries used and these views already filtered.

So, you can use the views on your template.

Best regards,

Edward John

[Former Member · Accepted solution]

Ok, so the actual query that is referenced needs to have its data filtered, it can't be filtered again/differently within the Web Template. That's kind of what I was thinking.

I may dig into the idea of creating a new Query View based on the Query i'm referencing, that sounds like a viable solution. Thanks for the help and guidance!