It would be really sweet to do something like mycrumbtrail = SQLFORM.smartgrid.do_crumbtrail(...
or myconsole = SQLFORM.smartgrid.do_console(... On Thursday, April 4, 2013 9:17:11 AM UTC-4, Niphlod 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
