I have table called cmsold as follows
CREATE TABLE cmsold
(
id serial NOT NULL,
dd timestamp without time zone,
cat character varying(32),
model character varying(80),
sold bigint,
CONSTRAINT cmsold_pkey PRIMARY KEY (id)
)
inserted the following data
insert into cmsold(dd,cat,model,sold)
values('2013-11-10','cat1','model1',10);
insert into cmsold(dd,cat,model,sold)
values('2013-11-10','cat1','model2',20);
insert into cmsold(dd,cat,model,sold)
values('2013-11-10','cat2','model1',40);
insert into cmsold(dd,cat,model,sold)
values('2013-11-10','cat2','model2',50);
insert into cmsold(dd,cat,model,sold)
values('2013-11-10','cat3','model1',15);
insert into cmsold(dd,cat,model,sold)
values('2013-11-10','cat3','model2',25);
insert into cmsold(dd,cat,model,sold)
values('2013-11-11','cat1','model1',10);
insert into cmsold(dd,cat,model,sold)
values('2013-11-11','cat1','model2',20);
insert into cmsold(dd,cat,model,sold)
values('2013-11-11','cat2','model1',40);
insert into cmsold(dd,cat,model,sold)
values('2013-11-11','cat2','model2',50);
insert into cmsold(dd,cat,model,sold)
values('2013-11-11','cat3','model1',15);
insert into cmsold(dd,cat,model,sold)
values('2013-11-11','cat3','model2',25);
insert into cmsold(dd,cat,model,sold)
values('2013-11-12','cat1','model1',10);
insert into cmsold(dd,cat,model,sold)
values('2013-11-12','cat1','model2',20);
insert into cmsold(dd,cat,model,sold)
values('2013-11-12','cat2','model1',40);
insert into cmsold(dd,cat,model,sold)
values('2013-11-12','cat2','model2',50);
insert into cmsold(dd,cat,model,sold)
values('2013-11-12','cat3','model1',15);
insert into cmsold(dd,cat,model,sold)
values('2013-11-12','cat3','model2',25);
created a crosstab query in postgresql
select * from crosstab(
$$select cat,model,dd::date,sum(sold) sold from cmsold
group by 1,2,3
order by 1,2,3 $$,
$$VALUES('2013-11-10'),('2013-11-11'),('2013-11-12')$$
)
as newtable(
cat varchar,
model varchar,
"2013-11-10" int,
"2013-11-11" int,
"2013-11-12" int);
it generates following output
cat,model,'2013-11-10','2013-11-11','2013-11-12'
"cat1";"model1";20;20;20
"cat2";"model1";50;50;50
"cat3";"model1";25;25;25
How can i display the above output in web2py in grid format ?
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
