No. But you can do: recs = db(m.mt_account==184901310)(*m.name <http://m.name/>[:2].contains(['cr','bu','se'])*)(m.writetime >lastupdate)( m.name[-4:]=='LOTs').select( m.mt_account,m.name,'ROUND(SUM(m.searchvalue),2)',m.writetime,groupby=m.name [2:8])
On Wednesday, 2 July 2014 01:31:28 UTC-5, Pham Quang Dung wrote: > > Hi, > Below are the DAL query and its SQLite version, the bold expression was > always 1 (true) which made me think its not working? > > recs = db(m.mt_account==184901310)(*m.name <http://m.name>[:2] in > ['cr','bu','se']*)(m.writetime >lastupdate)(m.name[-4:]=='LOTs').select( > m.mt_account,m.name,'ROUND(SUM(m.searchvalue),2)',m.writetime,groupby= > m.name[2:8]) > SELECT m.mt_account, m.name, ROUND(SUM(m.searchvalue),2), m.writetime > FROM any > info AS m WHERE ((((m.mt_account = 184901310) AND (m.writetime > > '2014-07-02 13: > 13:56')) AND (SUBSTR(m.name,(LENGTH(m.name) - 3),LENGTH(m.name)) = > 'LOTs')) AND *1*) GROUP BY SUBSTR(m.name,3,(9 - 3)); > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
