How can i set up this filter ?

Kairi
Kairi
in Modeling

I want to allow users to input a text field with items separated by commas (e.g., 

X1,X2,X3,X4,X5

) and, after clicking a boolean (e.g., "Select"), have the page filtered to show data only for the specified items. How can I set up this filter?

Tagged:

Answers

  • Rnilsson
    Rnilsson
    edited September 24

    Hi,

    I think we need a bit more information of what X1, X2 is representing.
    If those are list members then I would sugest this solution instead.

    1)
    Have a Boolean added to an ADMIN module (no dim). ("confirm choice/select")

    2)
    Have a module (FIL01) dimensioned by your list
    1 "Filter Line item" (formatted as a boolean) = should have no formula
    2 "Filter Confirmed Picks" = If not "ADM01.select" then true/false (depending on how you want it to operate) else "Filter Line Item"

    Here they can select the items manually (instead of typing).

    Still want to add typing?
    Add SYS Lookup: "Item to find" (formatting text)

    Then you can add another filter to FIL01
    "Find Item" = Name(item(L1)) = sys lookup.'item to find'

    Then add this as a filter to the UX-card.

    This would allow users to search for an item, then check the boolean and search for another item.

    You could add a lot more logic to have a dynamic search function, but this is probably the most you need.

    Does this work for you?

    Best,
    Rickard

Categories