I realize the question was asked before but I was not able to find the solution so posting again, my apologies.

I need Ari Tables to display Date of Submission from RSForm forms.

MySql query mentioned on these forums works just fine to display the data stored in #__rsform_submission_values table of RSForm. The help I need is with modifying the query to pull DateSubmited column from #__rsform_submissions table into #__rsform_submission_values table and THEN running SELECT query. I prefer not to modify the tables if it all possible.

SELECT
SubmissionId,
FieldName,
FieldValue
FROM
#__rsform_submission_values
WHERE
FormId = 6
AND
FieldName IN ('field1','field2','field3','field4','field5','field6')
ORDER BY SubmissionId ASC

Thanks a lot in advance.

Hello,

Use the following SQL query:



Regards,
ARI Soft

Thanks so much! Works perfectly.

Hmmmm. With the SQL like this for some reason the DateSubmitted column appears as a very last column on the right of the table, and it made the column TotalPrice that was previously there become column #2 in the table. TotalPrice also is not responding to alignment and is aligned left rather than center.
Columns are ordered, aligned and aliased in the module settings->column settings but displaying result does not respond to module settings any more? How do I change the order of columns and force them to align properly? Thanks.

It is not possible to define columns order in "Columns settings" parameters section. The extension uses order from "SELECT" query.

Regards,
ARI Soft

OK. Still, DateSubmitted is field2 in SELECT query. Yet it shows as field6 and field6 shows as field2 in the end result displaying table. Changing position of field2 in SELECT statement did not change position of the column in the table. Alignment is not working on field2 but is working on other columns? Thanks.