How to give report filter criteria to section level sourcing from data page ? Like all operands is equal ,is start with and ends with based on data type of the property available operands?
I want to filter data page results in the section ,right now we have filter options on the column ,which have limited operands like contains and equals ,I have requirement to show list of available option to compare two values : as is starts with ,ends ,contains , not equal ,equals and for numeric like less than ,greater than , less than or equal to ..
I would give you high-level implementation details,
- Configure your report definition rules to have multiple (in) parameters(but not required).
In report definition, have filter criteria for respective search keys like "starts with, ends, contains, not equal, equals and for numeric like less than, greater than, less than or equal to".
- Make the changes in data pages accordingly and have multiple parameters.
- In UI, have the input fields for each of your search criteria and map these properties on UI to the properties and pass these as parameters from UI to data page(subsequently to report definition rule).
Hope it helps you in implementation, kindly notify if it does by marking this post as answered.