Hello,
PB 2019R3 - PostgreSQL 11
Sample Query to construct a datawindow. Actual query is bit length and does more
SELECT *
FROM crosstab(
$$SELECT *
FROM example
Where field1 = '100'
And field2 = '200'
ORDER BY id ASC, key ASC;$$
) AS ct(blablafirst INT, blablasecond TEXT, blablathird TEXT);
The above query works. NO issues.
When we replace '100' with retrieval argument like this
Where field1 = :as_data1
And field2 = '200' <--------------- Error in this lineAnd then retrieve the datawindow, we get error
Any solution?
Happiness Always
BKR Sivaprakash
That was and still is, a long term restriction of the Crosstab DWO style. :-(
Regards ... Chris
Only in query we generate Cross Tab and result is shown in Tabular DW. Just to overcome the limitations of cross-tab dw, you mentioned, we went with this [special (!)] query. We used a Tabular DW to show the output.