Version 5.2 (starting with build 1513) now supports a query displaying items NOT in a reference list already.
This BSV demonstrates the concept:
http://www.awareim.com/community/Not_Query_Demo.bsv
1 ) The rule to for the query to show instances NOT selected (the top query) is:
FIND Customer WHERE COUNT RegularUser WHERE (RegularUser=LoggedInRegularUser AND Customer IN RegularUser.SelectedCustomers)=0 ORDER BY Customer.Name
2 ) Through using Auto Refresh capabilities of the 2 queries, items move "real time" between the selected and not selected lists.
3 ) When combined, these features mitigate the limitation that queries can only apply a process on items selected on one page. While that limitation still is true, the dynamic nature of selecting & moving instances to a selected items query provides some relief.
4 ) Once items are moved to a selected items area, a process can easily be applied to all of the selected items.
To see this BSV in action:
5 ) Click "add new customer" and add some. I suggest adding more than 5 so they continue to page 2 of the query.
6 ) In the top query, click "Select" for some individual instances & watch them be removed from the top query & added to the bottom query
7 ) Now do the same for multiple instances at one time.
8 ) In the bottom query, clicking "flag selected customers" and "unflag selected customers" shows that a process can be applied to all selected items. Not that these processes will apply across ALL pages of the bottom query.
9 ) Click in the top menu bar "review selected customers". This shows one other way of viewing the Customers stored in LoggedInRegularUser BO.
10 ) Click in the top menu bar "remove all selected customers" to more all items back from the bottom query to the top query.
