Question
Instellars Global Consulting
IN
Last activity: 29 May 2017 4:33 EDT
How to use a property in Report Definition for the purpose of querying if the property is not exposed and cannot be exposed as well ?
How to use a property in Report Definition for the purpose of querying if the property is not exposed and cannot be exposed as well ? The is no option to expose the property to use.
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
US
You can use it (and live with the severe guardrail) as long as you have the UDFs installed on your data base. UDFs are the custom java functions loaded in your data base and most implementations do not allow these to be installed in their DB. So its your call.
Also when you say you cant expose the column- is it a property on top level page (the class u r querying) or property on a nested page or page list?
If it is a page list i recommend to write a Declare Index or if it is on nested page, create a new property on top level page, write a declare expression to fill it so that can be exposed.
Or any specific reason that you cant expose?
If you use an unexposed property on a report def and UDFs are not there , there will be runtime exceptions like cant read from pr_read_stream etc..
Techmahindra
IN
Hello Mayank,
Can you show an example of how you want to refer the property.
I am confused when you say your unable to call in RD. The report definition will allow you to use an unexposed property however with a guardrail warning.
Regards,
Shanthini Charles
Accepted Solution
Pegasystems Inc.
US
You can use it (and live with the severe guardrail) as long as you have the UDFs installed on your data base. UDFs are the custom java functions loaded in your data base and most implementations do not allow these to be installed in their DB. So its your call.
Also when you say you cant expose the column- is it a property on top level page (the class u r querying) or property on a nested page or page list?
If it is a page list i recommend to write a Declare Index or if it is on nested page, create a new property on top level page, write a declare expression to fill it so that can be exposed.
Or any specific reason that you cant expose?
If you use an unexposed property on a report def and UDFs are not there , there will be runtime exceptions like cant read from pr_read_stream etc..
Instellars Global Consulting
IN
This question was asked to me during an interview. The interviewer asked me "that without exposing the property we need to use it in RD" and there should not be any warning.
Pegasystems Inc.
US
Instellars Global Consulting
IN
Thanks for the replies, i got to know that its not feasible or at the least its not suggested. May be it was to test the my confidence on my Pega knowledge.
Will close the discussion.
Techmahindra
IN
Thanks for confirming Mayank, may be as you only identified the person wanted you to know about how to implement custom guardrail warnings in the system.
Regards,
Shanthini Charles