Unable to pass Property value to Function alias from Report Defination
I have created one report defination having Declarative join Index,
1) Declare Index join page name = MyInd
2) Created one function alias having SQL script like SELECT DISTINCT regexp_substr({1},'[^/]+', 1, level)
FROM dual
3) I am calling function from RD and passing Myind.Levelofcover( having value like a/b/c ) property
4) post execution getting below error
6) If I pass hard coded value as parameter like abc/xyz,klm it's working fine.
Accepted Solution
Barclays
IN
Hello @RonLee_GCS,
Thank you for your response
MyInd", Myind" and "myind everything is defined as "myind " no discrepancy in index prefix and page defined in Pages & classes.
Meanwhile I got to know that Pega yet not supporting LISTAGG() SQL AGG function in function alias and FDBK-16445 Enhancement Request is open at Pegasystem end.
Barclays
IN
I am using outer query as
SELECT listagg(value, ' / ') within GROUP (
ORDER BY value) AS value
FROM (----- Inner query -----)
Parameter used in Inner Script
Pegasystems Inc.
US
Are you using the page name or the prefix of the Declarative Index Join?
Also, I think the property prefix may be case sensitive. In your description and the screen shot, I see 3 different mixes of case - "MyInd", Myind" and "myind". Are you matching the case of the actual object?
The query that is being generated by your report is not evaluating the property name you are passing. It is passing the name as is, and the database will have no idea what "myind" is.
If you are using the Prefix to specified for your Declarative Index Join, I believe this should work.
Accepted Solution
Barclays
IN
Hello @RonLee_GCS,
Thank you for your response
MyInd", Myind" and "myind everything is defined as "myind " no discrepancy in index prefix and page defined in Pages & classes.
Meanwhile I got to know that Pega yet not supporting LISTAGG() SQL AGG function in function alias and FDBK-16445 Enhancement Request is open at Pegasystem end.