Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Server side pagination not working with this query
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Server side pagination not working with this query
#58964
Server side pagination not working with this query 1 Year, 1 Month ago Karma: 0
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
The administrator has disabled public write access.
 
#58991
Re:Server side pagination not working with this query 1 Year, 1 Month ago Karma: 670
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
The administrator has disabled public write access.
 
Go to topPage: 1