Hi,

I'm trying to use server side pagination as there are lot of records to load.

I've enabled Server side pagination and Ajax dispatcher plugin.
I've used backquote in most of the columns, still there are no records loaded.

Please guide.

Here is the query:
SELECT image,(case when (image!='') THEN image
when(department='Doctor') THEN 'dashboard.getion.in/images/Doctor_icon.png'
ELSE 'dashboard.getion.in/images/Patient_icon.png'
END) as image,
CONCAT( `name`, ' ', `extra_field_8` ) AS Name,
`extra_field_6` AS Gender,
`mobile` as Mobile,
`extra_field_5` AS Age,
`email_to` as EMail,
c.tags,
CONCAT( `id`, '-', `alias` ) as 'edit'

FROM `k8i9f_ce_details` d
LEFT JOIN(SELECT `ce_id`, GROUP_CONCAT(`title` SEPARATOR ', ') as tags FROM `k8i9f_ce_tags` t
LEFT JOIN `k8i9f_ce_leads_tags` l ON l.`tag_id`=t.id
group by `ce_id` ) c ON c.`ce_id`=d.id
WHERE `user_id` = (select team_id from k8i9f_jsn_users where id={$UserId}) AND published = 1

Hello,

"Server side pagination" doesn't work with nested queries. The possible solution create a view and use a simple query in the module.

Regards,
ARI Soft