Filter results by dynamic drop down

How do I filter the results of a DataAssist results page via a drop down that is triggered after making a selection instead of the DataAssist Search form that you can lump at the top of the results page?

I haven't done this stuff for about 6 years when I built a custom CMS using interAKT's tools. I remember back then it was easy to populate the drop down with a related tables field/values that could be used to filter your current results page.

In this case the results page will only have 3 fields: img url, name and type.

I need to be able to filter the results by type via a dynamic drop down menu.

The type field is a related field to another table.

Thanks in advance!

Have you seen the dynamic dropdowns extension ?

it allows you to create cascading parent and child dropdowns from your recordsets.

Do I have to combine that with DA Search in order to filter the results?

Sorry for any dumb questions, I only got the extensions yesterday.

no you don't need DA at all to use this extension, it is separate

I know that, but can it be used in conjunction with DA to filter a DA results page?

Yes it can.

You can use the dynamic dropdowns just like any other form element to filter the results page.

is there a guide anywhere on how to do this?

dynamic dropdowns are just like any other form element.


when creating the recordset, in the filtering section, select the column that should be filtered. set the type to Form and then enter the name of the dropdown.

Thats what I thought and vaguely remembered although without a default value the results will be blank.

My sql is:

SELECT id_prd, name_prd, type_prd, tnailurl_prd
FROM products_prd
WHERE type_prd = colname

Colname =
Numeric
Default -1
$_POST['type_dropdown']

The Default value returns no records. How do I get the default to return all records?

you cant do this using a regular recordset, you would need to use DataAssist Search

set the criteria to use the select list and the type_prd column