Script to set filter to Open Range Boundary

#1

So I’ve got:

var view = this.parentView.control;
var param = view.getViewParameterByName("filterParameter");
param.parameterValue.upperBoundaryValue = Number(textbox1.control.value);
param.parameterValue.lowerBoundaryValue = ????;

I want the lower boundary value to be “Open Range Boundary” but I can’t get it to work. I’ve tried null and a dozen other attempts, but no luck. Any advice?

Side note: for whatever reason, if I set lower to 0 and upper to 1, it doesn’t return values exactly = 0 (yes I have the ‘include’ option checked). Could it be an integer vs float issue? The only lower boundary that works is the Open Range.

#2

Hi Ken,

Have you checked this?
https://www.dundas.com/support/learning/documentation/create-view-content/how-to/set-token-value-by-script

And this?
https://www.dundas.com/support/learning/documentation/create-view-content/how-to/modify-a-filter-/-view-parameter-using-scripting#h3-8-tokenvalue

You can also create your own token if needed:
https://www.dundas.com/support/learning/documentation/create-view-content/filters/creating-custom-tokens

I hope this helps,
Olivier

2 Likes
#3

Your search skills greatly exceed mine, apparently! I always dig through both help files and the Cube before asking, but I missed those. Thank you so much!