QueryString Filtering

I got the dataassist querystring bind to work.

I know how to pass the values however I don't know how to filter data to display the proper items from my database. I believe this can be done with dataassist sort, Just don't know what option to click on.

Example say $_GET['ID']
$_GET['Color']

How can I get those values to pull from my mysql the same data found in the columns.
Say ID would actually be the Itemsname column in mysql and Color would be Color column in mysql. Color Column Blue=Blue so that it displays all columns with same value.

Thank You!

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']

Thank You

I have been working on that but how could I just pull ID, right now I can only pull ID and Color.

example.com/ID?= Can't get it to work.
example.com/ID?=&color= does work.

change the where clause to OR:

WHERE ID= paramID OR color = paramColor

Thanks Again!

you're welcome.

Any way that I can get the values of the parameter to work with the data displayed

?ID=brand
show only the brands

?ID=brand&Color=Blue
show the color related to the brand selected

I know the OR choose between the 2 columns but how do I get them to relate?

you would need to add an order by clause:

WHERE ID= paramID OR color = paramColor ORDER BY ID

Ok comes back to what I first asked. I use Dataassist Wizard and Ecart but I wanted to understand how to make my site more dynamic.

I asked originally about Sort with Dataassist. Can I skip that and use Dataassist QueryString Binding to create the parameter url itself based on the values ID, Color and how should I set up a link to make this function work?

I believe that is the reason why it still won't work until I get that to work.

Thank You!

no, the sort will not filter your records.

sort merely puts the returned record in order using an ORDER BY clause.

to filter your records, either use a WHERE clause in your recordset, or you can use data Assist Search

To Create the URL Parameter in the bindings tab, click the Plus button and select URL Variable.

The data assist query string binding is only used with the sort server behavior.