Hello

When I enable Server side pagination = Yes,
sorting and pagination doesn't work any more.
If Server side pagination is disabled than sorting and pagination works.
ARI AJAX Dispatcher plugin is installed and enabled.


My query:

SELECT
U.name,
U.email,
U.registerDate,
U.lastvisitDate,
A.id,
A.cb_author,
A.cb_companyname,
A.cb_jobfunction,
A.cb_mainindustrysectorcategory,
A.cb_country
FROM #__comprofiler A INNER JOIN #__users U
ON A.id = U.id
ORDER BY U.name ASC


If I disable "Server side pagination" than list needs much more to load.
Currently, list contains approx 500 entries, but this number will grow into 2-3K


Any suggestions?

Joomla 3.2.1,
latest ARI data table module.

Regards

Hello,

Could you provide a link to a page where we can see the problem and a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft

Hello

So, with server side pagination turned on, pagination and sorting should work?

Also I've solved slow speed issue with only 5oo-ish items being rendered.
To display ARI Data tables I've used "Modules Anywhere" plugin and set it so that one article shows ARI module.
Module was displaying e-mail addresses, and Joomla also has Email cloaking plugin which autowraps every email address with block of JS code. This plugin was causing slow rendering of displayed data because it was wrapping 500 email addresses with this JS code.
I didn't want to tun off email cloaking plugin, but Joomla also has option to turn it off per article with this syntax added at top of article: {emailcloak=off}
Now ARI data tables renders fast as usual.
List generated by ARI module will be used by only 2 persons so server hog shouldn't be an issue.

This fix also solved non working pagination, but sorting still doesn't work


I've sent you login details for you to investigate because at some point list will grow even further so setting "Server Side pagination = Yes" would be wise

Regards

Try now please. We removed "ORDER BY" from the query and used "Choose table type -> ARI Data Table -> Columns settings" to define default sorting.

Regards,
ARI Soft

Hi

All works OK now.
Your module is getting better and better by every new release.

Thanks a lot for support during weekend.

Marking thread as solved.

Best regards.