can QaaWS do dynamic filtering?

[Former Member]

Is QaaWS able to filter query results at the time the web service is call?

[Former Member · Accepted solution]

Yes, it can. The QaaWS has to be designed to do so from within the QaaWS design tool, though.

In the QaaWS designer you can drag fields to a "Filter Objects" section and set various criteria, from pattern matches to operational comparisons (less than, greater than, equal to, etc.).

[Former Member · Accepted solution]

Javier,

Sorry for not being clear. I'm aware of being able to filter results in the QaaWS creation tool as you describe. What I want to know is if there is a way for me to pass a parameter to a web service built with QaaWS to filter on. i.e. I put a filter on year when building the QaaWS where year, city, amount is return. When I call the web service I pass in 2008, I expect only 2008 data to return. Is this possible?

[Former Member · Accepted solution]

Yes it is possible.

1.) Bring in Year, City, and Amount objects into the "Result Objects" pane.

2.) Bring Year into the "Filter Objects" pane, and set it to "Prompt." This will force the query to prompt the user to enter a year when the QaaWS query is executed.