ADDT Tutorial :: Dynamic Filter :: Demo 3 - 1 to 4 of 4

This demo uses one "price" and one "date" column for enabling a "price range" and "date range" comparison. Unlike the other demos
this Dynamic List is based on an extended Recordset which introduces an "alias" in order to apply the "price range" respectively
"date range" filters on just one column.

Showallrecords     Show filter
Product Name Minimum Price Maximum Price Starting Date Finish Date  
product four
£ 1050
12.12.2004
  
product one
£ 100
01.01.2007
  
product three
£ 800
20.10.1999
  
product two
£ 200
14.04.2005
  
 
 

Date & Numeric Fields :: Available Comparison Operators
Operator Meaning Example
< less than <2000
> greater than >1500
<= less than or equal to <=2005
>= greater than or equal to >=2007
= equal to =1500
<> not equal to <>1500
!= not equal to !=1500
adding an empty char between operator and value will work !