Hi,

I just purchased the ARI Data Tables module, and it has met every requirement that I was looking for. However, for some added functionality that is mostly cosmetic - I was wondering if you can add a filter to the column (especially for ranges).

My table looks like...
table name: student_rutgers
attributes: name, ruid, gpa, campusPermit, carManufacturer

I want to be able to select from a drop down for instance... Honda, and have only records that match that carManufacturer.

*EDIT* Also would like to be able to be able to drop down on the gpa column and be able to select ranges (i.e. 2 through 2.5, 2.5 through 3, etc.)

Right now in the SQL query I just have:
SELECT *
FROM student_rutgers

Thank you in advance!
-Adam

Hello,

The extension doesn't support ability to create a separate filters for each column, but it supports ability to use request variables in WHERE clause of SELECT SQL query. For example it is possible to create a HTML form outside a table with filter parameters and use them in the query. For example if want to use categoryId request variable in a query, it will look like:

SELECT
id,
title
FROM
table
WHERE
cat_id = {$REQUEST:categoryId}

Regards,
ARI Soft