Are you talking about pre-filters?
You cna usually fo "from X to Y" with two pre-filters, a "greater than X" and a "less than Y", joined with "AND" (first column of prefilter options).
If for some reason you can't, you can create more complex filters using the "query" type. So your filter would look like:
WHERE
Field: id
Condition: IN
Value: SELECT id FROM yourtable WHERE ... your complex where clause here ...
Type: query
The value can then be any valid query which returns a result set of ids from the table.
-- hugh