Discussion
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.
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?