Hi all,
I'm having a hard time trying to build a UX filter.
I have two lists:
- SS No ITC Customer
- SS No Product | Customer No Trading partner
In particular, the SS No Product | Customer No Trading partner list is a concatenation of product and customer (yes, the same customer of SS No ITC Customer).
What I want to do is to filter the product of theSS No Product | Customer No Trading partner list, depending on what I choose as a customer.
I built three modules:
- Selection module, in the selection line item you pick the customer from the SS No ITC Customer list
2.Mapping module, the list is the SS No Product | Customer No Trading partner, while in the mapping line item you choose a member of the SS No ITC Trading Customer list. A customer may have more than one product.
3. The last module has the SS No Product | Customer No Trading partner list. The Mapped Customer line item takes the customer from the mapping module, while the Chosen Customer line item follows this formula:
IF Sal Customer Choice test.Selection[LOOKUP: 'SYS18 Users'.User List] = Mapped Customer THEN TRUE ELSE FALSE
What I would expect would be a checked boolean everytime the chosen customer matches mapped customer, but instead what I have is the opposite. In fact, all the booleans in correspondence of my name are unchecked and obviously also the products belonging to the customer I'm interested in.
How should I solve this problem?
Thanks in advance