Don't understand what you need exactly... Is stat a string type containing 'check in' or 'check out' and you want just odd number of record or you have an other field with timestamp or something and you want only the odd hours to appear in the grid??
Richard On Wed, Sep 4, 2013 at 12:54 PM, António Ramos <ramstei...@gmail.com> wrote: > > hello i need to use the sqlform.grid(query,etc... to show records > > *my problem* > the query is not just like > ((db.tab1.stat='check in')|(db.tab1.stat='check out')) > > > > i need to query only records that appear with stat='check in' or 'check > out' odd times in tab1 and not even times > > > For example , this should not be in the grid > > user a check in > user a check out > user a check in > user a check out > > > but this should > > user a check in > user a check out > user a check in > > > how do i create a query for this? to use in sqlform.grid(query, .... > > -- > > --- > 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. > -- --- 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.
