A possible solution is creating a view in your database based on the query and select data from the view by the module.

Regards,
ARI Soft

YOU SIR ARE A LEGEND!

Any idea why the individual sorting from the datatables plugin isn't working, looks like it isn't responding at all.

Could you describe in more details what exactly doesn't work (probably provide a link to a page where we can see it)?

Regards,
ARI Soft

Can I send you my backoffice login to you personally? The database is within a restricted area and prefer not to give out the info over the forum?

You can send it by email.

Regards,
ARI Soft

Hello, maybe i have the same Problem like the user told before. I have a large Database which has 8000 entries, the Database will grow up in the near future. At the moment i load up the entries to MySQL this your component i want to display the entries this the following code.

{arijdatatable bPaginate="true"}
{arisqltable}
{ariconnectionstring dbHost="test" dbUser="test" dbPass="test" dbName="test" dbType="mysqli"}
{arisqltablecolumns} {arisqltablecolumn id="ID" alias="ID" width="5%" className="idg"} {arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"} {/arisqltablecolumns}
{arisqltablequery}SELECT * FROM `csv_table` LIMIT 0, 30{/arisqltablequery} {/arisqltable}
{/arijdatatable}

Everything works thine, but the load time tooks up to 18 seconds at the moment. Is it possible to load the Data faster? Here is a link to the Homepage

www.derschlachter.de/joom_restart/index.php/zeitschriften/test-index

and this is my MySQL Database



Im a newbie in MySQL, and my english not very well, but i hope you can help me.

thanks a lot