Skip to Content
0

Cascading filters back to start state?

Dec 06, 2017 at 01:13 AM

49

avatar image
Former Member

Hi,

For example i have 3 drop downs like country, state and city when i drill down country it pops up country list i select a country and then in the state drop down i will get list of states specific to that country and in the city list i will get list of cities. I select a city data get's displayed now i directly select all countries second and third filter should automatically clear and show all data for all countries, all states and all cities. Is this possible without java script, i have used binding functionality for source and target. I couldn't find this option in DS not sure i can do it directly.

Any ideas?

Regards

Harish

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

3 Answers

avatar image
Former Member Dec 06, 2017 at 08:02 AM
0

Hi Mustafa,

I am on DS 1.6 SP3, issue is all the development has been completed and if at all i have do completely scripting drop downs is going to be a re development which is not feasible.

If there is any shortcut solution then that would help a lot of rework.

Thanks

Harish

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Harish,

You could try upgrading to the latest SP of DS 1.6 to check if the binding behaviour has been fixed. Otherwise I don't think there are any shortcuts and you will have to implement script code like Lakshmikanth has suggested.

Regards,

Mustafa.

0
Former Member

Hi Mustafa,

I had another issue with planning dashboard which will be resolved by upgrading to DS 1.6 they doesn't want to upgrade to 1.6 instead they will be going with Lumira from next year.

Thanks

Harish

0
Lakshmikanth Adharapurapu Dec 06, 2017 at 09:08 AM
0

Hi Harish,

Please find the below steps:

step1: Write below script in your start up

DROPDOWN_COUNTRY.setItems(DS_1.getMemberList("Country", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL "));

DROPDOWN_STATE.setItems(DS_1.getMemberList("STATE", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL"));

DROPDOWN_CITY.setItems(DS_1.getMemberList("CITY", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL"));

Step2: Write below script in your drop down country on select

DS_1.setFilterExt("Country", DROPDOWN_COUNTRY.getSelectedValue());

DROPDOWN_STATE.setItems(DS_1.getMemberList("STATE", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL"));

DROPDOWN_CITY.setItems(DS_1.getMemberList("CITY", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL"));

Step3: Write below script in your drop down state on select

DS_1.setFilterExt("state", DROPDOWN_State.getSelectedValue());

DROPDOWN_CITY.setItems(DS_1.getMemberList("CITY", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 800,"ALL"));

Step4: Write below script in your drop down city on select

DS_1.setFilterExt("city", DROPDOWN_city.getSelectedValue());

This should work :)

BR,

Lakshmikanth Adharapurapu

Share
10 |10000 characters needed characters left characters exceeded
Mustafa Bensan Dec 06, 2017 at 06:36 AM
0

Hi Harish,

I have previously observed exactly the same behaviour when using the property binding functionality for implementing cascading filters. The only solution to achieve your desired behaviour was to use scripting for filtering instead of binding.

What version of Design Studio are your running by the way?

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded