Summary view does not accept dynamic parameter multiple values
SummaryWhen calling a summary view or a list view and passing parameters dynamically with multiple elements, the elements are not parsed correctly. Filter conditions with string parameters always use the EQUALS operator in the generated SQL regardless of whether the string parameter contains comma separated elements, such as ("abc","xyz"). This causes the filter to fail.
Steps to Reproduce
- Create summary view with parameters
- Pass a parameter value such as, "abc","xyz"
Root CauseThis is expected behavior. List Views and Summary Views are deprecated and do not have the functionality to dynamically interpret whether a string parameter may contain multiple elements for a filter condition.
ResolutionUse Report Definitions which have the the functionality to dynamically interpret whether a string parameter may contain multiple elements for a filter condition.
Published April 12, 2017 - Updated May 3, 2017