Dynamic Queries

How do you do dynamic queries in Zoho Creator? For example, when using criteria or filters in defining Views, I cannot see how to make the select criteria work with variables, only constants. I am still trying to learn the code... Examples would be great. Thanks,

-dm-
david.miller