Lisp HUG Maillist Archive

multicolumn lisp panel and pagination

I understand that you can have a function called to return the string used to display each item in the multicolumn list panel. This column takes a single 'item' argument. 

Does item include the row number? Is it possible to obtain the row number of the passed item?

I would like to use the multicolumn panel to page through a huge dataset where obtaining the whole data set and stuffing it into the multicolumn list panel would not be feasible.

Knowing the row numbers that the list panel is trying to display would make things trivial.

	Thanks, Joel

---
http://twitter.com/wagerlabs


Re: multicolumn lisp panel and pagination

Here's what I want to do ...

I have a data set of, say, 12 million rows. I want to display a multicolumn list panel with 50 rows and I want the panel to think there 12 million rows in it. I want the panel to tell me when I scroll off the screen and ask for an item using a row number. 

I will use the row number to page in more data from database as needed, using the PgSQL OFFSET and LIMIT commands, for example.

Is this doable with CAPI and the multicolumn list panel?

	Thanks, Joel

---
http://twitter.com/wagerlabs


Updated at: 2020-12-10 08:39 UTC