Support Article
Summary view does not accept dynamic parameter multiple values
SA-36443
Summary
When 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.
Error Messages
Not Applicable
Steps to Reproduce
- Create summary view with parameters
- Pass a parameter value such as, "abc","xyz"
Root Cause
This 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.
Resolution
Use Report Definitions which have the the functionality to dynamically interpret whether a string parameter may contain multiple elements for a filter condition.
Published May 4, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.