HI,
I have a input parameter which can accept multiple entries. I have few default values such as 'A1','A2' ,'A3'. I also need to give space as a default value here.
And the input parameter type is Column and I have a value help view as well. When I select constant for Default value and click on the browse button and select space, it shows as if its is selected. but the filter does not happen for space and only happens for 'A1','A2' and 'A3'. The SQL generated does not even show " " as one of the criteria fields.
But when I go to the data preview prompt screen and then select the browse and select space, it gets filtered. But I do not want the user to do that everytime.
I tried directly giving space," ", '' but none of them worked. Have any of you set default value as space for input parameter?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.