I am facing issue to fetch data using report definition. the issue is i have records like Hyderabad,Chennai,Bangalore and Hyd,Mumbai,Mysore in AllLocations property. Now for reports user select Locations on UI then related record only we want to display. For example if user select Hyderabad then related record Hyderbad,Chennai,Bangalore comes but if user selects Hyd then both records come. I want to fetch only Hyd,Mumbai,Mysore related record only.
Current logic in report definition is AllLocations Contains Param.Locations.
Here Locations come dynamically means user can select Hyderbad or Hyd or chennai etc.
AllLocations and Param.Locations both are have comma saperated values
***Edited by Moderator Marissa to change type from Pega Academy to Product, update Product details and Platform Capability tags****
I am using table for populating the values on UI and the source is Pagelist Propepty. Table has two values one is check box and another one is Location. whenever check the location it goes as parameter to RD through activity.
Yes, because of the contains relationship it gives both values but my requirement is to display only the selected value.
How can i achieve this? Is there any other OOTB functions to restrict the value as Hyd in query?
You are passing the parameter through activity only right then keep one when condition in one step and check for your location parameter is Hyd or not if it is Hyd then set parameter value as one of the city name in your result like mumbai or mysore and pass that parameter to RD then it will return only your desired result this time instead of two results.