Skip to Content
0

How to pass ListBox values to the datasource

Apr 25, 2017 at 12:03 AM

54

avatar image

Hi Expert,

I have list box and chart/crosstab. Based on my selection in listbox the values have to change in the graph/cross tab

On "Start up" i have below code which populate the values in the list box

var values=DS_1.getMemberList("_kZ3abwXPEeePdcwFKyYXrQ", MemberPresentation.EXTERNAL_KEY, MemberDisplay.TEXT, 500); LISTBOX_1.setItems(values);

in "On Select" of list box, i have below code to filter the crosstab/data source.

DS_1.setFilterExt("_kZ3abwXPEeePdcwFKyYXrQ", LISTBOX_1.getSelectedValues());

but i am getting error "Cannot convert from string array to input string".

What i am doing wrong here, How i make this work?

I know the problem is multi value, i need multi selection.

Any help, much appreciated.

Thanks

VJ

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mustafa Bensan Apr 25, 2017 at 01:53 AM
0

Hi VJ,

You should make the following changes to your code:

1. Use INTERNAL_KEY instead of EXTERNAL_KEY

var values=DS_1.getMemberList("_kZ3abwXPEeePdcwFKyYXrQ", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 500); LISTBOX_1.setItems(values);

2. Use setFilter() instead of setFilterExt() in "On Select" event script of the List Box

DS_1.setFilter("_kZ3abwXPEeePdcwFKyYXrQ", me.getSelectedValues());

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded