Massimo, do you have a preference as far as licensing? I don't want to discourage people from using it, but if anyone makes a much-needed improvement I would like to get benefit of it. If the ideas are worthy of incorporation into grid or smartgrid, that would be great.
I don't do works for hire, so I own the code completely. I'll post in this thread once I've cleaned up the code and uploaded it to github. I wrote it without referencing grid or smartgrid, so it does not take advantage of shortcuts in those two methods. But it does have selectable number of rows per page, and it keeps any query, orderby and rows per page parms in the session, so if you go off on an excursion to edit something, it retrieves the index just as you left it. Also things like the console maker are split off into separate functions. I thought this would provide a couple of advantages. If you wanted a console or paginator on some page, you could easily incorporate it. At the same time, if you wanted to substitute a different console building function, you could easily do so. Cliff Kachinske On Wednesday, April 10, 2013 9:18:17 AM UTC-4, Massimo Di Pierro wrote: > > Please! > > On Wednesday, 10 April 2013 06:36:45 UTC-5, Cliff Kachinske wrote: >> >> Johann, >> >> I developed an alternative to grid/smartgrid which has most of the >> features. >> >> I can put it on github if you like. >> >> Caution: not documented. But I'll put up a sample controller that uses >> it if you like. >> >> The main drawback is the search widget isn't nearly as slick as >> smartgrid's. And you do have to create your own query parser. >> >> But it does have a selector for the number of rows per page. >> >> On Monday, April 8, 2013 3:11:20 AM UTC-4, Johann Spies wrote: >>> >>> I can use SQLTABLE for this and then have to write some code for >>> pagination and search options - all which are already in the SQLFORM.grid >>> available. In this case addition, deletion and editing will be avoided. >>> >>> Regards >>> Johann >>> >>> >>> On 4 April 2013 15:17, Niphlod <nip...@gmail.com> wrote: >>> >>>> I'm guessing it will be hard. You'll better code a view and access it >>>> as a "fake table". >>>> >>>> PS: you show it in a grid.... then what record do you want to >>>> add/edit/delete ? >>>> I'm guessing that this time you want to use the grid just to search, >>>> orderby and paginate, but there's a LOT of logic inside it for more things >>>> that needs to be considered. >>>> >>>> On Thursday, April 4, 2013 12:23:58 PM UTC+2, Johann Spies wrote: >>>>> >>>>> How would I be able to use a query like this (or the DAL equivalent) >>>>> to show the result in a grid? >>>>> >>>>> select so as Journal, SUM(aantal) as Articles >>>>> from isi.nr_arts_per_journal >>>>> group by Journal >>>>> order by Journal >>>>> >>>>> Regars >>>>> Johann >>>>> >>>>> -- >>>>> Because experiencing your loyal love is better than life itself, >>>>> my lips will praise you. (Psalm 63:3) >>>>> >>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to web2py+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> >>> >>> -- >>> Because experiencing your loyal love is better than life itself, >>> my lips will praise you. (Psalm 63:3) >>> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
