Mark,
I hear you on this one…but I don't believe this is an option at the moment. When users take advantage of SQL grid overrides they have to keep in mind that the values they see are 'display data' only. The filters work by comparing the actual data in the fields to your query.
Need more help? Ask us about Method consulting services.
Valbon Shabani
Director of Education
Method Integration Inc.
Toll Free: 1.888.925.6238 ext. 715
Local and overseas: 416.847.0400 ext. 715
Fax: 416.640.6027
E-mail: valbon@method.me
Website: http://www.linkedin.com/in/valbon