Hello,
If you show data from a database, it is possible to use request variables in "WHERE" clause of an SQL query. For example it is possible to load "ARI Data Tables" module into an article and create a HTML search form outside the module. The form will contains controls to select start and/or end date. For example if controls from the form have name start_date and end_date and you want to filter by publish_date field in a table, query will look like:
| Code: |
SELECT
id,
title
FROM
my_table
WHERE
({$REQUEST:start_date|empty:} <> '' AND publish date >= {$REQUEST:start_date|empty:})
AND
({$REQUEST:end_date|empty:} <> '' AND publish date <= {$REQUEST:end_date|empty:})
|
Regards,
ARI Soft
