The capability of binding a parameter to a request variable enabled dynamic and performant datasets that were previously not possible in DV. By utilizing session variables in the query definition, this feature allowed frontend filters to be passed efficiently to the backend queries even in complex datasets.
However, currently this feature only allows passing one value from a parameter to the underlying session variable, even when both the parameter and the session variable are allowed to contain multiple values. This limitation severely hinders the potential of this feature in situations where the user would like to select multiple values in a field on the frontend and use the selected values in the backend query.
Adding the capability of passing multiple values through a parameter-request-variable binding will enable many valuable DV use cases.
Based on the following 2 OAC documentations, it looks that this should be possible to achieve in DV:
- This documentation About Request Variables states that request variables support multiple values: "Only string and numeric request variables support multiple values. All other data types pass only the first value."
- This documentation Bind a Parameter to a Request Variable states that a request variable only accepts the first value in a parameter: "If a parameter that's bound to a request variable accepts multiple initial values, the request variable is set to the first value and the remaining values are ignored."
Many thanks,
