Links can be created with help of "Columns Settings -> Format" parameter.

About filters, it is possible to use request variables in SQL query so you can create a custom HTML form and user parameters from this form in SQL query. Request parameters are used in query in the next way:

{$REQUEST:VAR_NAME}

Where VAR_NAME is a name of request variable.

Regards,
ARI Soft

I am using ARI Data Tables module to grab data from a remote db. Here is what I am trying to accomplish (Love your products by the way)...
I want to grab a list of CUSTOMERS and then when you click on the column of the CUSTOMER ID it will link to a page with their PROFILE PAGE/ORDER HISTORY(specified by the sql query I write of course.)

Any ideas? I can create the list but I am having trouble linking to the specific PROFILE PAGE/ORDER HISTORY by clicking on the id. I have read the references in this forum but I must be missing something.

Read this post.

Regards,
ARI Soft

I did read that post but I am trying to click through to a page that loads another ari data table module with details unique to the row of data I clicked on.

ADDED ON---- the data is coming from another db, not the joomla db

Ok, I was able to figure it out finally.

For anyone trying to make this work, here is how I did it.

Created 2 instances of the module as stated above.

For the Top Level (in my case, the CUSTOMER LIST) Set "Columns Settings" in ARI Data Tables Module - reference ID to the field you want as a link, such as "CUSTOMER ID" (this will be the field that links to the full data page) set the "Format" as a link <a href="index.php?option=com_content&view=article&id=ARTICLE_ID_HERE&FIELD_FROM_DB_HERE={$value}">{$value}</a>

Then on the other module for the page that shows details.... write your SQL Query in ARI Data Tables module like this
(EDIT TO SUIT YOUR NEEDS) - this ones selects all in a specific table which is what I was trying to accomplish.
SELECT * FROM table WHERE column = {$REQUEST:DB_COLUMN_GOES_HERE}

Ok... I need help with one more small thing.

I can get from "CUSTOMER LIST" to "CUSTOMER PROFILE" page but I am having trouble showing "ORDER DATA" for that specific "CUSTOMER"

FYI - The "ORDER DATA" is in the same database but a separate table that also has "CUSTOMER ID"

Any help would be greatly appreciated as I've gone through this forum and through my settings multiple times...