Hello,

I'm successfully using ARI Data Tables module with context filter.

Now the table has grown that big, that the "server side pagination" became necessary. But when it's turned "Yes", filtering stopped to work. Always gives "No matching records found". Column sorting stops to work too.

Do I do something wrong? How to get the filter working with server side pagination? Thank you.

Hello,

What SQL query do you use? It can be not compatible with "Server side pagination".

Regards,
ARI Soft

SELECT
`userid`,
CONCAT ('<img style="height:16px;width=16px;" src="media/com_ars/icons/',IF(`block`=0,'ok_small.png','locked_16.png'),'"/>') AS "state"
,CONCAT ('<img style="height:32px;width=32px;" src=".../assets/images/avatars/',IF (`avatar`='','_grey.gif',`avatar`) ,'"/>') AS "Avatar",
CONCAT('<a href="index.php?option=...',`userid`,'&lang=en">',`name`,"</a>") AS "Name",
CONCAT('<a href="mailto:',`email`,'">',`email`,'</a>') AS email,
`phonemobile` ,`city` AS "City",
FROM #__table1 t1 LEFT JOIN #__table2 t2 ON t1.`id`=t2.`userid` WHERE NOT `username` IN('admin') AND `published`=1 ORDER BY `userid` ASC

Thank you in advance for your comments.

"Server side pagination" doesn't work with "virtual" fields (like "state", "Avatar").

Regards,
ARI Soft

Thank you. Actually, it works OK except filtering. Means, it loads only the "visible" page, then you can walk on page by page.

But the filtering is a must) I need to be able to filter two or three fields of those ten; is there a way to set individual fields filters with "server side pagination" on? Thanks.

The extension doesn't support this ability when "virtual" fields are used in "SELECT" SQL query.

Regards,
ARI Soft