db.executesql(your_sql_statement) should work, I guess.
________________________________________
Kiran Subbaraman
http://subbaraman.wordpress.com/about/
On Thu, 04-06-2015 8:06 PM, Yebach wrote:
Hello
I have the following SQL for PostgreSQL
select
rw_worker
, rw_date
, array_to_string(array_agg(distinct results_woshi.rw_shift),'&') AS
shifts
from
results_woshi
where
rw_date > '2015-01-01' and rw_script = 42
group by rw_worker, rw_date
order by rw_date
The result is
49;"2015-05-01";"2200-0600"
50;"2015-05-01";"0600-1400&1400-2200"
51;"2015-05-01";"0600-1400"
52;"2015-05-01";"1400-2200&2200-0600"
any ideas how to translate it to web2py DAL
So I have to concatenate strings in group by statement where strings
are concatenated in order.
Thank you
--
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
<mailto:web2py+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.
--
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.
