SQLFORM.grid does pagination
On Jan 12, 8:53 am, Saurabh S <ggtestlo...@gmail.com> wrote: > Hi, > > I am developing an online booking application in python using web2py > framework on google app engine. > > I have two tables, one is users table and other is activities table. > My users table contains user id for each record and my activities > table contains user id for whom an activity has been created. > > My user table has different authorization levels such as clients and > volunteers. > > I have more than 1000 records in both activities table and user table. > > Now I need to fetch all the activities of all the clients. Since all > the data cannot be displayed at a single click, I have used > pagination. So I have used the limitby on my database queries. > > The issue that I am facing is When I try to match the id of people > with the id present in activities, if first set of activities have > been fetched using limitby and then I match them with the user id of > clients and there is no match then the the records for the remaing > id's are not fetched from the database. > > Please provide any suggestion on how to use limitby filter when we > have data coming from more than one table(there is a one to one > mapping in these two tables) > > Thanks in advance
