Hi, I'm trying to create a form that allows a user to select the date range from which an Ari Data Table will be presented. As a novice user I'm a bit confused about the process of passing form data to Ari Data Tables so that the WHERE statement can be used to filter on date.

Two questions:
1. What needs to be in the action attribute so that Ari Data Tables can pick up the start and end dates?
2. Is the syntax correct for the SELECT statement

Here's what's in the Joomla article

<form action="#" method="post">
Start Date:<input name="start" type="date" /><br />
End Date:<input name="End" type="date" /><br />
<input type="submit" />
</form>
{aridatatables moduleId="XX"}


Here's what's in my SQL statement

SELECT Date, Value
FROM `myTable`
WHERE email={$UserEmail} AND date>={$REQUEST:$Start} and date<={$REQUEST:$End}


Thanks!

Hello,

According to your HTML code, use the following variables in SQL query:

{$REQUEST:start} and {$REQUEST:End}


values of these variables should be compatible with value in "date" column from "myTable" table.

Regards,
ARI Soft

Excellent, thanks...now working!

Is it possible to link the data table (Ari Data Table module 1) and a corresponding graph (Ari Data Table module 2) to the same form so that both the table and graph can be updated from the same form data?

You can use request variables and value from module 1 in "Columns settings -> Format" parameter. You can read about it here.

Regards,
ARI Soft

I'm trying to search database by date also.
I've been working so hard to get this to work and I'm just so close.
I have the article setup:
<p>
Report Date Range</p>
<form action="#" method="post">
Start Date:<input name="start" type="cb_joindate" /><br />
End Date:<input name="End" type="cb_joindate" /><br />
<input type="submit" />&nbsp;</form>
<p>
{aridatatables moduleId=&quot;301&quot;}</p>


And my Module SQL statement:

SELECT firstname,lastname, cb_businessname,cb_phone, cb_joindate FROM jml_comprofiler
WHERE cb_joindate>='{$REQUEST:start} ' and cb_joindate<'{$REQUEST:End}'

The SQL statement works if I replace the $Request's with dates, but when I try to submit dates through the article form I get an Error page 0:Error. It is something with my action or method of post? Any ideas?
Thank you so much for any advice, tk

Could you provide a link to a page where we can see the search form?

Regards,
ARI Soft