Currently when you want to view or add a criteria of "one of" from a table field (like Fund ID, Appeal ID, etc.) in webview query, it loads a single list showing you checkboxes for all the fields you have selected. It only loads 20 codes at a time and then you have to select "load more" to see the next 20 and so on.

For many of us who have extremely large lists of Fund IDs (for example), this is not a functional way to access the information. I have to click "load more" over 20 times, wait each time for it to load and keep scrolling to the bottom to hit load more again until I finally get the full list.

If I want to view which Fund IDs I've already selected, I have to do the same "load more" behavior, and it still breaks at 20 records, alphabetically, so sometimes if I have 70 Fund IDs selected, it'll only show me 1 or 2 more every time I click "load more". I do this often if it's a query I use annually and I want to make sure I don't need to make any updates before continuing. These are the kinds of tasks that are critical to our operations and will be so much more difficult to accomplish with the way the interface currently functions.

If I want to search for a group of records (say Fund IDs that include "BA"), I have to search it, then click load more until I'm sure I have all the IDs showing and THEN click "select all". Simply clicking "select all" will not select all matches - only the matches that have loaded on the screen. This is less than ideal because 1) it's more time consuming to accomplish your goal and it lends itself easily to error in missing the table entries you actually want.

You also cannot toggle inactive codes on and off - it appears to be set only to show you active codes. This is also a problem as sometimes we need to query anyone who gave to any of our annual Employee appeals, not just the active ones, and we have no way to create a new query that does this in webview.

Ideally, the UX would be adjusted to behave more how database view query worked, with a side by side list where your already selected table entries were on one side and your unselected table entries were on the other side and you could easily move entries between the two lists as necessary. Both of these lists load fully, and the unselected entries are searchable. This allows for quick decisions and easy checking that you've selected everything you need, going in and out of search without having to reset everything time. This is a case where the new interface is actively working against functionality and I would love it if it was adjusted to better support user's needs.

It is incredibly difficult the scroll through a huge list of table entries and be positive that you've put a check box by every one that you need, if you cannot both view what you've already selected all together, view what you haven't selected, and search without having to take time reset the list to show you all entries.