I have a paged query in which I set the formatter to .randomize on the client side at the repeater.
Problem is it only picks/randomizes the same first three records. I would like the first three records (page) to pull random records from the whole table. It’s only randomizing the first page. Each other page is always the same.
Hmmmm, I can create a view in Navicat but it is not available to Wappler for some reason. And I can’t create the view in Wappler either. There is an error.
Brad, you cannot create views in Wappler.
You can just refresh schema on database level and on views level to see the newly created view in your database.
Yeah, it’s not there though. See screenshot above. Other connections on that project are showing views no problem. Just on this connection there is an error.
If you use a view with a random order then you shouldn’t use it for paging, the results are random with each select so the next page doesn’t have the same order as the previous.
Using client-side paging or if you have a way that it only randomizes the query per client session, so that the order is the same for the connected client when he queries it again to get the next page.
No, for client side paging you use a regular query and display data using the data view component. You define there the records per page etc.
Then you create paging based on it (data view).