yes , stat is a string with "chech in" or "check out" i also have a timestamp for the check in or check out.
I dont want odd /even hours I want to know if the user is checked in I have an RFID app to check in /out outside workers via an rfid tag. when the user checks firstime, the app records "check in" , after that , checking again his rfid tag the app logs "check out" . During the day the worker can go out to lunch and checks out, after lunck checks in again. so for a user i can have user a check in (time...) user a check out (time...) user a check in (time...) I want to create a grid to show who is inside, so i need a query of odd rfid checks for each user 2013/9/4 Richard Vézina <ml.richard.vez...@gmail.com> > 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. > -- --- 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.
