Create a grid with sql joining two table the pagination not function, grid with a simply sql work fine this is a bug please there is a workaround ?
Yes, you could create a view in SQL which joins the two tables together. Then base your grid on the single view. We find this works better in SC anyway, as the inbuilt SQL-parser sometimes gets confused by anything more than simple SQL anyway. In fact we always base our grids on a view, even if it’s really simple, so that we can later change the view if we do ever need to make it more complex.
yes also i have solved the problem like your suggestion thanks for your response