One thing you could do is first run the DataAssist wizard with no filtering and then when it is finished, go to the results page and double click the server behavior for the query and then go to the advanced tab and add the WHERE clause how you want it.
Regards