How to filter items using report definition.
Ex:I want to display food items which are stored in data base using filters
@udaykumart16801936 Please can you clarify what you are trying to do - your question does not make much sense. Did you complete an Academy course?
Please carry out a PSC search on your key words.
We also have material available on the Pega Academy training.
In Pega Academy, you can learn about creating report filters in the module ‘Gaining insight into business efficiency.’ This module covers topics such as the role of reports in Pega applications, how columns and filters impact the contents of a report, and differentiating between business data and process data in reports. Additionally, you can practice creating custom business reports, which include adding filters to your reports, in the hands-on exercise titled ‘Creating a custom business report.’
Gaining insight into business efficiency > Overview
Creating a custom business report > 1 Create a public category for report definitions
To filter items using report definition, follow these steps:
- Create a new report definition or open an existing one in Dev Studio.
- Click the ‘Query’ tab.
- In the ‘Edit filters’ section, drag a property from the ‘Data Explorer’ to the ‘Drop column to add filter’ section.
- In the ‘Edit filter’ section, select a relational operator for the filter condition from the list of operators.
- Enter a specific value or select a property to compare with your property in the filter condition.
Click ‘Apply changes’ to add the filter condition to your report definition.
For example, if you want to display food items with a specific category, drag the ‘Category’ property to the ‘Drop column to add filter’ section, select the ‘=’ operator, and enter the desired category value. The report will display food items with the specified category from the database.