Discussion
Synechron
US
Last activity: 7 Sep 2016 9:51 EDT
Enhancement Need on Report Definition (RD) Rule
Hi Team,
Though we have feature to have multiple joins feature available at RD however having conditional join facility is still missing at RD. For example I have a source table Joins with Access Group table which can Joins with two different keys (e.g. Key1 & Key2) for display data for GroupA & Group B. Now with the exisitng situation I would need to create two RD rule. But if we have a this component conditionalized with when rule, we can just reference when rule for Group A or B and having the conditional joins implemented. This will help us promote the reusability and reduce the creation of multiple rule just because of conditional joins.
Regards,
Satish
***Updated by Moderator: Lochan. Removed user added SR Created tag. Apologies for confusion, shouldn't have been an end-user option; removed personal information.
Pegasystems
IN
So if I understand correctly, you would like a condition say mainclass.property1 = joinclass.key1 to be the only one in certain scenarios and in other scenarios you would like mainclass.property1 = joinclass.key2 to be the only join condition. And you would like this scenario to be controlled by a when rule?
Would it be possible to dynamically pass the filter using pyReportParamPageName parameter to pxRetrieveReportData API to execute based your condition?
Updated: 23 Aug 2016 4:58 EDT
Synechron
US
Thanks Rajiv for the input. Yes! you understood it correctly and ofcourse that can be a work around. But that again would cost another set of rules for passing or setting the parameters. My objective is enhance the reusability of RD and reduce the creation of any other extra rules. If we have option to call "When rule" at edit Condition itself we can conidtionally have different joins. Hope! I was able explain it, else we can talk in order to understand it better.
Regards,
Satish
<moderator removed personal details>
Updated: 23 Aug 2016 4:59 EDT
Synechron
US
And yes my join condition is as follows and that would not be possible with the suggested work around even :( .
When Group=A
mainclass.property1 = joinclass.key1
When Group=B
mainclass.property2 = joinclass.key2
Regards,
Satish
<moderator removed personal details>
Pegasystems Inc.
IN
Hi Satish,
An enhancement request has been created on our internal portal. The request ID is attached to your post above (under Related Support Case number field.)
Please refer this number to to Account Executive to track the status.
Regards,
Lochan | Community Moderator | Pegasystems Inc.
Pegasystems
IN
Thanks for the details, Satish. As of now there are no plans to support when rules to decide how the query should be generated. This is because we want the report definition to be able to generate and retrieve results just based on SQL and not execute other rules to figure out how to generate the query.
That said, I suggest you file an enhancement request and product management will take a look.
Pegasystems Inc.
IN
Hi Satish,
As I mentioned in my earlier reply, you will have to work with your company's Pega Account Executive for enhancement.
Regards,
Lochan