Problems with filtering

Comments

4 comments

  • Avatar
    Nicolas Gauvin

    Hello,

     

    I am not sure to understand what you are trying to do.

    Maybe dependent category filter could help you achieve this?

    Regards,

    Nicolas

  • Avatar
    Randolph Abelardo

    Hi @Odeh.

    The dependent categoryFilter recommended by @Nicolas should do the job. The selected filter will automatically limit the options available based on the dependency you specified. If this isn't what you're looking for, could you please explain further?

    * Please note that this feature will only work in your scenario if 1 column is assigned as a parent category (dropdown) - column C. That is, the options for the dependent filters will be based on the currently selected item from the parent category.

    In this example, let's say you have columns A,B,C,D where Column A is assigned as the parent category. The options made available for columns B,C,D will be based on the item selected in column A. 

    But if you have the same setup as above and you select an option from column C first, the filters will not adjust the options available for columns A,B,D since the parent category is column A. The columns can only have 1 dependency. Interdependent columns is not supported.

    Please let us know if this helps or if you still need assistance.


    - Randy

  • Avatar
    OD

    I understand that Column A must be the parent category, however, is there a way to narrow the data with multiple parent categories?  In example.  For the following data:

    Make Model Doors

    If someone selects a particular model of a car in Column B, can it reflect in Column A and C?  I.E. If they select a Civic from Honda from Column B, can it then narrow Column A and C accordingly?  Is that possible?  Obviously the data I'm dealing with is not cars, but I want to use it as an illustration of what is happening.

     

    Thank you,

     

    OD

  • Avatar
    Randolph Abelardo

    Hi @Odeh.

    That setup is possible. You simply need to make column B as the parent. In column B, indicate:
    categoryFilter(C,A)

    But I recommend making column B's dropdown list the 1st option to appear on your view to achieve the desired effect. Otherwise, when your users select an option from Make (column A), the dependency won't work (see screencast below).

    Hope this helps.

    - Randy (Moderator)


Please sign in to leave a comment.