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 <[email protected]> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
