I have one model “Backorders”. In “Backorders” there is a user lookup field that I need two filters to work on. When I create the two filters they do not work independently. If I enter data in filter 1 (include) it will show in filter 2 (exclude) and vice versa.
Filter 1 (Include): Is a multi-select option that will filter based on a user(s). So if you type in Stevie Wonder only Stevie’s records will appear.
Filter 2 (Exclude): Is a multi-select option that will exclude user(s). so if you type in Stevie Wonder all records except Stevie’s will appear.
I need the two filters to work independently that when I type something in the exclude filter the include filter stays blank.