[#11666] - \crosstabview not supported for postgressql. Dynamic column support required

Category:
Bug report
Priority:
Immediate
Status:
New
Project: Severity:
Critical
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

select * from (select * from(select did,f.field_name as field_name,p_value from(select t.did,t.column38470 As code,j.key::text AS parameter, j.val::text As p_value from (select c.column38470 as did,column38470 as field_name,c.* from table1407 as c where c.column38470='VC1809002' order by c.id
) as t, LATERAL jsonb_each_text(to_jsonb(t)) AS j(key,val) WHERE j.key NOT IN('Code') ) as t5 left join form_fields as f on t5.parameter='column'||cast(f.id as text) where did<>p_value order by did,f.form_id) as t UNION ALL select a.column36209 as did,b.column36198 as field_name,b.column36200 as p_value from Table1673 as a left join Table1674 as b on a.id=b.column36197 where a.column36209='VC1809002') as t5 where t5.field_name<>'' order by t5.did \crosstabview

sagar_1987's picture
Joined: Apr 16 2012 - 10:39am
Last seen: 1 month 2 days ago

1 Comment:

#1
Feedback
randomness