Coming in ERSDE 3.9 – support for multi-value parameters in the query designer

Location: BlogsNews & Blog    
Posted by: host 5/14/2013 5:33 PM
Even though Enesys RS Data Extension queries support multi-value parameters (using “IN” clause either at the list level or within a SqlQuery statement), it was only possible to pass a single parameter values when executing the query (for testing purposes) within the query designer.

Even though Enesys RS Data Extension queries support multi-value parameters (using “IN” clause either at the list level or within a SqlQuery statement), it was only possible to pass a single parameter values when executing the query (for testing purposes) within the query designer.

 

image

 

This is not a major show stopper if you consider that you can preview the report within BIDS and therefore pass multiple values through regular report execution (which is anyway often easier if your report parameter get its values from another query).

 

image

 

However to make it easier to test an individual query, it is now possible to pass multiple values directly within the query designer by using a comma to separate each value like shown in the following screen shot:

 

image

Permalink |  Trackback