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

  1. Create summary view with parameters
  2. 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 April 12, 2017 - Updated May 3, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.