Applying filter criteria on data list based on multiple attributes having custom select list
I am trying to achieve filtering data list (shipment data) based on two filters - carrier name and status of shipment.
Both the attributes are custom list type where user can select one or more than one values. Based on selection, user will able to see data from the data list after user clicks on "Find" button. Screen attached as attachment.
Case1: user selects carrier as UPS
Case2: user selects carrier as UPS and FedEx
Case3: user selects carrier as UPS and status as "Intransit" and "Delivered".
How to define my filters to achieve this?