Skip to Content
avatar image
Former Member

Cascading filters back to start state?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Dec 06, 2017 at 09:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2017 at 06:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded