No recordset filtering is not done using Data Assist sort. Data Assist sort is used to sort the recordset results, not filter.
to filter the recrdset, you need to add a where clause.
in the record set go into advanced view.
In the SQL window, you should see the select statement for the recordset like:
SELECT * FROM tbleName
add a where clause for the column names you want to filter, for example if the 2 columns in the table that you want to filter on ar ID and color:
SELECT * FROM tbleName
WHERE ID= paramID AND color = paramColor
in the variables section, create 2 new variables as:
Name: paramID
type: Integer
default value: -1
run time value: $_GET['ID']
Name: paramColor
type: text
default value: -1
Run time value: $_GET['Color']