Hello, I am trying to add a new filter on Material queue manager essentially the team in the warehouse need to see both PUR-SHP and STK-SHP currently the transaction type is only one drop down box I was thinking if I add another box I could achieve this ?
However I cant see the option to edit the filters
Best I could do was to filter it client side instead of doing it via the rest call. If you want to try this approach… test this out in PILOT first.
First, copy the Transaction Type combo box and paste in a second one.
Change the binding to something else (I just added a “2” at the end):
Now, go into the Grid’s Grid Model > Provider Model > Rest Params
Delete the tranType line… you’ll no longer be sending that through the rest parameters.
Now, just above the Rest Params… add a Client Filter:
TranType = '?{FilterControlView.TranType}' OR TranType = '??{FilterControlView.TranType2}'
The first filter is required… the second is optional (will run even if null).
You should be able to test this out at this point, but you’ll have to manually refresh the grid in the grid’s overflow menu.
To refresh the grid automatically, you can add an event on Column Changes to the TranType & TranType2 columns:
