cancel
Showing results for 
Search instead for 
Did you mean: 

Cascading filters back to start state?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member276213
Active Participant
0 Kudos

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

Former Member
0 Kudos

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

MustafaBensan
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

MustafaBensan
Active Contributor
0 Kudos

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.